Junk Characters returning to package from SQL Server Package Configuration

  • 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

  • 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

  • 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