Friday, January 1, 2016

SSIS packages are not visible in File System after File system deployment in Integration Service via SSMS

SSIS packages are not visible in File System after File system deployment in Integration Service via SSMS. If you choose the installation folder other than the default folder, it won’t display in Integration Service in SSMS.
You have to choose default DTS package locations, if you want to view via SSMS. For example, for SQL Server 2014 version path is:
C:\Program Files\Microsoft SQL Server\120\DTS\Packages

Cheers! Uma

2 comments: