SQL Server Performance

run a package on a different server using DTSrun command in command prompt

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 sql login 'login1'. Can someone give me a pointer why i encounter this login error?Wingman
  2. satya Moderator

    Do not duplicate the posts for teh same problem, refer your other thread.

Share This Page