CODEWITHSUNDEEP
c#ssis
Loganj99
Loganj99

Reputation: 449

Ssis Script can't find dll

I am having issues with dll references in ssis scripting. I have an ibm dll that I reference on the C drive. Every time I reference it, it puts it in the folder C:\Users<Name>\AppData\Local\Temp\SSIS\c90f4b396fa54b3e9b7540b970489b79\obj\Debug\Interop.cwbx.dll

It runs just fine in visual studio (because it puts it in the temp dir), however when I import the package to management studio, it errors out at that script task, because it can't find it. This is all done on the server.

Upvotes: 0

Views: 1455

Answers (1)

Jammer
Jammer

Reputation: 10208

As far as I know DLLs need to be registered in the GAC for SSIS to be able to use them.

Use gacutil.exe to register them and then try the pipeline again.

Upvotes: 1

Related Questions