Access SSIS Package from local Machine
Hi,
I have installed Microsoft Sql server 2008 R2 on my laptop.
I want to access the SSIS package that has been on some other server.
Please provide the instructions to access the remote Package.
Note:The SSIS package which is reffering to the Data base that is reside on different server.
Thanks in Advance.
Santosh Y
October 3rd, 2011 3:11am
You need to connect with the Integration Services running on the SQL Server which is hosting your SSIS packages. In a typical environment Open SSMS->From the Server Type, select Integration Services, provide server name, your credentials and connect.
After successfull connectivity you can locate your SSIS packgaes under MSDB/File System.
Vikash Kumar Singh www.singhvikash.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 3:23am
You need to connect with the Integration Services running on the SQL Server which is hosting your SSIS packages. In a typical environment Open SSMS->From the Server Type, select Integration Services, provide server name, your credentials and connect.
After successfull connectivity you can locate your SSIS packgaes under MSDB/File System.
Vikash Kumar Singh www.singhvikash.blogspot.com
October 3rd, 2011 10:15am


