October 11, 2012 at 8:43 am
Hello All,
I was very excited to see that the Package Configurations can help me maintain a clean DEV to PROD development and testing process but I haven't been able to get it to work.
My current issue is that after exporting the package connection string to SQL and then reloading the package I'm getting the following:
In Server Name, User Name and sometimes Database I'm getting stuff that looks like this '㜱⸲㜱ㄮ㘷㈮㘰' after I run the package to get my connection information from the SSIS configurations table.
It is showing correctly in the SSIS configurations Table.
Is this the result of the package encrypting these or am I having some other troubles?
Thanks!
Will
October 12, 2012 at 2:44 am
Does the configuration table have NVARCHAR columns?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 12, 2012 at 7:10 am
I'm not sure if the original copy did or not but I believe it did.
I created it from the script generated by SSIS.
Since this post I have dropped that table and recreated it as well as started from scratch on my SSIS project.
Still doesn't work but I'm no longer having this issue.
Thanks for the reply!
Will
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy