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
    WingSzeto, Mar 12, 2008
    #2

  2. satya Moderator

    Do not multipost the same thread that will cause most of confusion to you as well, refer to your other thread.
    satya, Mar 13, 2008
    #3

Share This Page