Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Add SSIS Packages

Author  Topic 

reddy_vam
Starting Member

43 Posts

Posted - 2009-01-06 : 12:14:38
Hi,

I am new to using SSIS packages. I have few SSIS packages having .dtsx extension. Can somebody please tell me how can I add them to SQL Server.

Thanks,
Reddy

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-06 : 12:15:36
Do you mean to store in MSDB database or something else?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-06 : 12:28:34
connect to integration services on your server. then go to stored packages-> MSDB right click and choose import package.then browse to dtsx file and select it. then select rely on server role option for security.
Go to Top of Page

reddy_vam
Starting Member

43 Posts

Posted - 2009-01-06 : 14:18:06
Thanks alot Visakh
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-07 : 12:13:31
welcome
Go to Top of Page
   

- Advertisement -