Hello,

I'm trying to roll out a program I developed to quite a few servers. The
program is developed in Visual Studio 2005 (VB.NET) and includes an
Integration Services Project as well as a VB solution. I'm having trouble
when I create the setup project and roll it out to other servers. The login
fails when it comes time to execute the package in my program on other
servers.

If I create the installer and install the program on the machine that I
developed the solution on, everything works fine. I've included the .dtsx
files in my bin for the solution and changed the path to the dtsx files to
the correct path, but the dtsx files are not keeping the correct login
information for the remote database and fail to login. I've also hard coded
the login information for the dtsx package into my program's code and got
that to work once, but generally it does not.

Can somebody tell me how to create an installer package for a solution that
includes an Integration Services project and dtsx files? All servers that the
solution is being rolled out on have SQL Server 2005 full-version installed.

Thanks,

John