Friday, June 18, 2010

SSIS: How to deploy an SSIS package?

There are 4 ways:

1. Build a deployment manifest file in BIDS, then copy the directory to the applicable SQL Server then work through the steps of the package installation wizard

2. DTUTIL utility to copy, paste, rename, delete an SSIS Package

3. Login to SQL Server Integration Services via SQL Server Management Studio then navigate to the 'Stored Packages' folder then right click on the one of the children folders or an SSIS package to access the 'Import Packages...' or 'Export Packages...'option.

4. In BIDS is to navigate to File | Save Copy of Package and complete the interface.

SSIS Interview Questions And Answers

No comments:

Post a Comment