InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 06:32:22 GMT20http://www.sqlservercentral.com/Forums/Topic1369898-1292-1.aspxYou're welcome :-)Wed, 10 Oct 2012 11:23:01 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1369898-1292-1.aspxThanks you very much!Wed, 10 Oct 2012 09:45:36 GMTjdbrown239http://www.sqlservercentral.com/Forums/Topic1369898-1292-1.aspxYou posted in a 2008 forum but it looks like from the title of your post you're on 2005.Here is a link on how to connect to a SQL 2005 Integration Services Instance:[u][url=http://msdn.microsoft.com/en-us/library/aa337083(v=sql.90).aspx]Connecting to a Remote Integration Services Server (SQL Server 2005)[/url][/u]When you 'save to SQL Server' where you're really saving the package is in the msdb Database of the SQL Server you specify. You can see your packages here:[code="sql"]SELECT *FROM msdb.dbo.sysdtspackages90;[/code]And you can access them via SSMS, just follow the link above.Mon, 08 Oct 2012 13:43:24 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1369898-1292-1.aspxWhen i use the import\Export to move data and select the option to save as an SSIS package it says it will save it in SQL Server. What is the actual file location and can I access it with SSMS?Mon, 08 Oct 2012 09:36:04 GMTjdbrown239