question

GaryFurash avatar image
0 Votes"
GaryFurash asked ZoeHui-MSFT answered

SSIS Script Task Only Works w/ x64 Turned Off?

Using: Windows 10 Enterprise, SSIS+ 2.0.100.2142, Visual Studio 16.10.31410.357, targeting SQL Server 2019, reinstalled Visual Studio for Applications (VSTA) 2019 latst

If I run any sort of script task (even one that does nothing) with x64 bit runtime turned on, I get this error:

"Failed to start project, library not registered"

I understand that the x64 runtime only applies to local debugging (not what happens when I deploy to the server, but...

is there any workaround? What's going on?

I found some older posts that say you can fix it by turning on the precompiled option, but as of recent versions that's no longer an issue.

vs-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @GaryFurash,

Someone said that we could use the Execute Process Task instead of executing it as a package. This will respect the x32/x64 setting.

You may have a try.

execute-process-task

Details you may refer:

https://stackoverflow.com/questions/28218901/how-to-execute-a-32-bit-ssis-package-in-a-64bit-package

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.