SSSI Package failing when using SQL authentication

• na1774

  SSCrazy

  Points: 2301

  More actions

  July 18, 2012 at 12:22 pm

  #264019

  Hello Everyone,

  I have a typical issue.

  I have 2 DBs D1, D2 in 2 diffrent server S1, S2. Now I have craeted a package in my local machine in which I have two connection managers which has connection to S1(D1), S2(D2). Basically I am imporing data from D1 to D2 using 'Data Flow' tasks. Both S1, S2 are SQl Servers. In the connection managers I am using sql server authenticated users who have db_owner role on the databases D1, D2.

  Now when I run the package from my local machine I get the following error.

  

• Rocky's

  Ten Centuries

  Points: 1102

  More actions

  July 19, 2012 at 4:09 am

  #1514725

  What is the error you are getting?Please post the error then only we can identify the issue.