May 23, 2011 at 8:41 pm
I have a wierd issue, im trying to connect to DB2 using 'IBM DB2 ODBC driver' that I downloaded by downloading the IBM DB2 client. I configured the DSN in the ODBC Administrator and the connection tested ok. When I add a ADO.Net source to my SSIS package and try to use .Net/ODBC data provider the connection succeeds momentarily but fails the next time i open the package because the password doesnt get stored, i tried storing it in config file still the package fails with missing password.
My issue is that i am working with SQL Server 2008 Standard Edition so need to use ODBC to connect to DB2 database to get my data. Could this be a problem with the ODBC driver or am I missing something in SSIS, please help me with this or provider an alternate solution so that i can connect to db2 .
May 26, 2011 at 6:15 am
Normally this isn't an issue with your drivers, but with the protection level of your package.
Can you check which setting it has? (It is a package property).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply