How come I keep losing the password in the destination table??

• Loner

  SSC-Insane

  Points: 21279

  More actions

  April 4, 2008 at 1:08 pm

  #120842

  I tried to do a 'Data Flow Task' copying data from an outside source to a SQL Server table.

  Unfortunately my company is behind in fixing the security of SQL Server, instead of using window authentication, it still required to put in user id and password. It worked fine when I ran it. But when I deployed it to other server, the password of the SQL Server table dropped, it was not in the connection string. Is there any way to fix it?

  Thanks

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  April 4, 2008 at 3:39 pm

  #798723

  I think method #2 or #3 in this article would be what you want to do.

  http://support.microsoft.com/kb/918760