SQL Server Performance

Package failed to execute on a different computer

Discussion in 'SQL Server 2005 Integration Services' started by WingSzeto, Mar 12, 2008.

  1. WingSzeto Member

    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
  2. satya Moderator

    Do not multipost the same thread that will cause most of confusion to you as well, refer to your other thread.

Share This Page