Junk Characters returning to package from SQL Server Package Configuration

• waskelton4

  Newbie

  Points: 2

  More actions

  October 11, 2012 at 8:43 am

  #263185

  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

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  October 12, 2012 at 2:44 am

  #1548496

  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

• waskelton4

  Newbie

  Points: 2

  More actions

  October 12, 2012 at 7:10 am

  #1548612

  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