To Use SSIS Packages in Transform
Create a Manual SSIS package.
NOTE: The name of the package must end in imp (For example: dswPatty_dgSAP_ANLA_imp.dtsx).
The package needs to be saved in the DataGarage_SSIS_FilePath folder.
NOTE:The Data Source Paths used for Manual SSIS packages are the DataGarage_SSIS_FilePath and the DSW_Package_FilePath. If you select System Administration > Data Sources in the Navigation pane and access the Vertical Views of these entries, you will see the file path that each package is currently using. You can either manually move the package from the DataGarage_SSIS_FilePath folder to the DSW_Package_FilePath folder or you can point the DataGarage_SSIS_FilePath and the DSW_Package_FilePath to the same folder, and then you won't have to manually move the SSIS package.
Check the Vertical View of the Target Sources page in Transform and confirm that all CranPort and SSIS packages display in the Package Name list box.