CODEWITHSUNDEEP
c#ssissql-server-2012ssis-data-flow
Alberto Geniola
Alberto Geniola

Reputation: 15

SSIS component DLL Deployment

I've developed a custom SSIS DataDlow component.

Now it's time to deploy the DLL. In my work and test environment I've simply registered the DLL in the GAC and coped it into:

"C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents"

and into

"C:\Program Files\Microsoft SQL Server\120\DTS\PipelineComponents"

Is there any Best Practice to follow? Is this the best way to install a custom component in SSIS?

TY!

Upvotes: 0

Views: 240

Answers (1)

Marc Bernier
Marc Bernier

Reputation: 2996

I can't say if it's the best practice, as there doesn't seem to be anything published on this matter. However, that's how I've been doing it for some 5 years now, and it works well 90% of the time. The other 10% are users who installed SQL Server on a drive other than C:. You'll see the same directory structure for both drives, but usually only one of them is in the PATH. You'll want to install to the one pointed to by the PATH.

Unfortunately, there's no reliable registry key that makes this easy to figure out. In addition to the above PATH logic, the installer offers an "I'll select where to install the DLLs" button, it's a useful fallback.

Upvotes: 0

Related Questions