February 27, 2008 at 12:00 pm
I'm trying to update data from SQL Server 2005 to a Sybase Server using SSIS. I have the Sybase drivers installed on my work station and I'm saving the connection details (user name, pwd, server name) etc inside of a Native OLE DB\Sybase ASE OLD DB Provider connection. I'm also checking off allow saving password.
When i run the package manually using BI Dev. Studio, it works without any errors. When i deploy it to a server, it gives a login failed error.
When i close the do a test connection inside of BI Dev Studio Connection manager a second time, it fails. On verifying the details, it seems like the password isn't saved in the connection manager, in spite of checking off allow saving password.
Anyone has any ideas or a work around or a different way i can move this data to Sybase.
Saving the information in an XML file on the file system isn't an option due to policy.
Thanks in advance.
February 28, 2008 at 2:49 am
I had the same issue. But when I aved the password in XML file and load it from package configiuration of SSIS, issue was solved.
My Blog:
March 1, 2008 at 9:11 pm
You can set your package setting ProtectionLevel to EncryptSensitiveWithPassword, and set a strong PackagePassword to encrypt the password of the remote server.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply