Authentication in SSIS

• Ron Monbleau

  Grasshopper

  Points: 20

  More actions

  July 11, 2007 at 2:41 pm

  #117653

  I'm trying to connect to a DB2 database and pull some information.  I've got DB2 connect installed on my SQL server and I can connect to the DB2 database and get the info manually.  When I create an SSIS package so I can shcedule the process, I can't save the userID and password that I need to connect to DB2.

  Can someone point me in the right direction to do this?

  Thanks

  Ron

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  July 13, 2007 at 1:59 am

  #719200

  Check the Protection level in your package properties. See BOL for more info on that.

  Alternatively, you can use a configuration to set the value of the username and password (My preferred method)

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!