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.
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? |
 |
|
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. |
 |
|
reddy_vam
Starting Member
43 Posts |
Posted - 2009-01-06 : 14:18:06
|
Thanks alot Visakh |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-07 : 12:13:31
|
welcome |
 |
|
|
|
|