June 10, 2014 at 6:42 am
We have SQL 2012 SSIS packages deployed to the Integration Services Catalog - SSISDB.
In SSDT, how do I COPY a previously deployed package down to my project?
In the past, I could open BIDS project, Add Existing Pkg, and point the pkg needed and save(download) into my project.
In SSDT, I created a new project. When I right mouse click my 'SSIS Packages' and select 'Add Existing Package', I see File System, SQL Server, SSIS Package Store --- but the Packages available on the server in SSISDB are not displaying therefore I cannot copy to my project?? (fyi, I'm sysadmin and local admin on the sql server)
thoughts?
June 10, 2014 at 7:30 am
In the project deployment model, you can only export at the project level, not at the individual package level.
Basically this means you need to export the entire project out of SSMS to your filesystem.
Once it is exported, you can add an existing package in the usual way by selecting it from the filesystem.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply