Monday, February 20, 2012

No Toolbox

This seems like a rather simple questions that I've hesitated posting for a day now, but as of yet I can't really find an answer through my searches online.

My SSIS package is using a couple of the Konesans Transforms, this worked fine on my development box with my dev SQL server. The time has come now to deploy my package to my production SQL server. The instructions on installing the transforms on my dev box all uses Visual Studio to add the components.

Is there a way to deploy 3rd party (own my own) SSIS tasks with the package? Does it require a seperate install? How can I do it without Visual Studio?

Thanks for any help,

-Dan

You don't need Visual Studio to install the custom components. You need to add them to the toolbox in BIDS in order to use them, but that's not teh same as installing them.

All you need to do on your production server is make sure that the DLLs are in the GAC (c:\windows\assembly)

-Jamie

|||

Thanks Jamie. I can do that.

I'm hoping though the future might hold a little more functionality in the "Deployment Utility." I'm also using my own libraries for some script tasks and it'd be nice if the deployment utility recognized the dependancy in visual studio and provides a way for it to be installed into the GAC on deployment.

|||

Nice idea. Request it at the Feedback Centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||

Thanks for the link, it was handy for submitting a bug on my FTP issue.

|||I downloaded Visual Basic studio 2005 Trying to do a project for my class final and it has no toolbox? Please help|||

>I downloaded Visual Basic studio 2005 Trying to do a project for my class final and it has no toolbox? Please help

Sorry, we'll not be able to answe this here. Please repost this in the appropriate Visual Studio forum where I'm sure they will jump on it.

No comments:

Post a Comment