I have a package that was originally developed using BIDS 2005 for SSIS 2005. The package uses a script transformation as an output to write specially formatted flat files. The original script transformation was written using VB (as was the only option at
I was running 32-bit Windows XP Professional at the time.
I recently upgraded to SSIS 2008 and BIDS 2008. After the package was upgraded, the script transformation was dropped and recreated so it could be rewritten in C#.
Up until this point, everything had worked fine.
I just upgraded my workstation to Windows 7 64-bit and I am still using BIDS 2008. Today, I modified the code in the script transformation to add some additional output to the flat file.
After saving the package (without error), it was run in the BIDS debugger.
The changes I made did not result in the output file changing at all. The script editor in the package showed my changes, but every time the package was run, the output file reflected the state of the file before I made my code changes.
I'm fairly certain this is because the code is not pre-compiliing when I save the package.
To test this, I deleted the component and recreated it with the new code and it worked.
Has anyone else encountered this in SSIS 2008? I know this was a problem with 64-bit environments and SS
View Complete Post