Connecting to a pre-SQL 2012 SSIS Instance with SQL 2012 SSMS

If you are using SQL Server Management Studio in SQL 2012 to try to connect to an older SSIS instance (SQL 2008 R2 and earlier) called “SSISServerName”, you will get an error: Connecting to the Integration Services service on the computer “SSISServerName” failed with the following error: “Class not registered”. This error can occur when […]

Read more
FTP within an SSIS Script Task

A fellow user on the SSIS forums has posted his code to FTP from within a script task. I just want to increase visibility to this as the stock FTP Task is somewhat limited. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1258083&SiteID=1

Read more