I used SQL server intelligence studio to create a package on my laptop. The package has a connection manager to connect to a SQL server A using a sql login 'Login1' to read some data from a database and export the data to a flat file destination in server B. I ran the package on my laptop using dtsrun command in a command prompt and has no problem. When I copied the same package to server A and run it in the command prompt, I encountered a login failure for the login 'login1'. Can someone give me a pointer why i encounter this login error? Wingman
Do not multipost the same thread that will cause most of confusion to you as well, refer to your other thread.