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

Advertisements

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