Updating an SSIS package stored on SQL Server

  • I have recieved some education on SSIS (all on control flow, data flow, tasks, ...) but then my company decided to use Informatica and we didn't pursue SSIS. I am now at a different company and there is an SSIS package stored on a SQL Server that needs a small change that I can handle easily. The problem I have is that have no training in accessing the package, updating it and putting it back. I found one article that said to open a new project and then add an existing package. i did that and found the package made the change and have no idea how to put it back on the server. I would appreciate if someone could give the basics on "how-to update an existing package stored on a SQL server".

  • If you have permission, open the SQL Server Management Studio and make a new connection to the Integration Services on the target server. Then just right-click on the folder where the package should be stored and select import package > from file system etc.

    If the package name stayed the same, it'll ask you if you want to overwrite existing, so say yes.

    Details on various alternative methods: http://msdn.microsoft.com/en-us/library/ms137592.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply