Hi I am trying to move an existing console application to an SSIS package using the script task. However, my current code references an external DLL. Is it possible to add this reference or can SSIS only using native .net libraries?

Mike,You have to create your own .NET library and implement interface to this external DLL in it. This .NET library has to be properly signed, so you can installed in your global assembly cache (GAC). Make sure you also include a copy of the library in the following folder:\\Program Files\Microsoft SQL Server\90\SDK\AssembliesAnd then you will be able to reference this functionality in your SSIS script tasks.

Here is an example of using a custom .net assembly within a Script Task or Script Component: http://microsoft-ssis.blogspot.com/2011/05/referencing-custom-assembly-inside.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com