Retrieving SSIS project/packages from SSIS catalog

There are two ways to export a package from SSISDB to SSDT Export as .ispac from SSMS(SQL Server Management Studio) and save in SSDT (SQL Server Data tools) Export as Zip file from SSMS Export as .ispac from SSMS Step 1: In SSIS Catalog, tight click on the package that has to be exported and … Continue reading Retrieving SSIS project/packages from SSIS catalog


Single mail on Failure

To get a single mail with an error message, when the package is failed. When we include a mail task on event handler (on Error) and if the package failed with 5 errors, we will receives 5 mails which would be confusing so to get a single mail on error following steps can be followed. … Continue reading Single mail on Failure

BIDS – 32-bit Run time

BIDS is a 32-bit run time application (reference can be found here). So, when we are using SSIS we are using 32 bit facilities to build our package. Nowadays, we are using 64-bit OS and other hardware. For Microsoft Jet Driver (MS Access or Excel), there is no 64-Bit version of Jet Driver so any … Continue reading BIDS – 32-bit Run time