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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics