Hi,
I have a package in DTS which uses SQL server connection to a database. When i migrated the pacakge to SSIS password was not stored .
Migration is from DTS store to MSDB of SQL server integration services. When i right click the package on MSDB and run the package, i see th connection property as User ID=aaa;Initial Catalog =aaa etc.,, but no password.
What i am thinking is Create a sql server login as aaa and set the protection level as server storage by this i assume that it takes tha password from sql serve login, but i am not sure whether this will work. The problem is that i cannot run this package and test.
Can anybody please suggest me whether my approach is right or let me know the solution.
Thanks,
ek