April 7, 2008 at 3:42 am
I've created a SSIS package in VS 2008 and want to run it on a IA64 server. It contains a script task and I know from SSIS 2005, that you need to do a precompile of the script task for it to work on IA64. How do you do that in SSIS 2008? I simply can't find that option box anywhere. The script runs fine in VS 2008 on my x32 laptop, but not on the IA64 server. All other packages are running ok.
Here's a dump from the DTEXEC log:
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1300.13 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:59:10
Error: 2008-04-07 10:59:11.51
Code: 0xC0010018
Source: Script Task
Description: Failed to load task "Script Task", type "Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91". The contact information for this task is "".
End Error
April 7, 2008 at 6:38 am
There is a PreCompile property in the Custom Properties section. This defaults to True on both SQL 2005 and SQL 2008.
Your error message is not very descriptive. I seem to remember the error message for trying to run an uncompiled script task on a 64 bit SSIS server being much more instructive. I don't think this is your problem.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply