I am migrating an existing package, working packages, from SQL2005 to SQL2012.
I have variables that are passed/used in a Script Task. My problem is the Dts.Variables statement does not recognize the "dts.".
Says it's not declared. I don't understand why it works find on my production server (SQL2005) and not here.
I also tried finding the assemblies needed and one article mentioned Microsoft.SqlServer.Script
Task; but I can't find this.
Below is the my first problem string....
Dim File_Name$ = DTS.Variables("User::DB_Fi
Any help would be greatly appreciated it.