November 21, 2008 at 7:08 am
I have a script task which will not compile. I need to set the PrecompileScriptIntoBinaryCode option to true as it will run on as 64 bit environment. Though no matter how many times i edit the script after this point it just will not compile.
I am running post sp2 and all i have found so far with my searches on google is either install SQL SP2 or Open the script task and re-save it to have the binary code generated.
Any ideas?
November 21, 2008 at 7:21 am
I have found that opening the script tasks on the 64 bit box with the precompile set to true does the trick. Kind of a pain I admit and seems like there should be an more streamlined method of doing this since you would have to keep doing this every time you want to modify the script and do development to the project, plus you have to have BIDS setup on the server (at least a DEV or UAT server).
We are running SQL Server 2005 SP2 on Windows 2003 R2 64 bit servers.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 21, 2008 at 7:59 am
Hi,
I have found the issue. I was given the package to troubleshoot without the knowledge that there was a custom dll in use. By adding this custom dll into the reference section of VSA i was able to compile the script correctly. Only problem was that BIDS & SSIS was misleading me with regards to where the issue actually was.
Thanks anyway for the idea.
November 21, 2008 at 8:08 am
That would do it. Nice catch on the extra reference not being available and the squiggles should have been there to see that the reference was not available. Lessons learned and have a good one.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 7, 2011 at 4:26 pm
Please suggest what was the custom dll we need to add. Does it related to your SSIS package or it related to BIDS?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply