SSIS packages - where do they go?

[sqlsadie108]

Hi,

I imported and migrated a DTS package from 2000 to 2005.

Where am I supposed to store this package?

Right now I have it in a folder I created under "Projects"

Thanks

 

[SQLBill]

There you go. Actually, you can put them anywhere you want them.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

After the package is converted it's probably stored on your workstation. In the SSMS you will need to connect to the SSIS instance and upload the dtsx file to the SSIS server so that it can be run by the server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sqlsadie108]

Thanks mrdenny,

for answering all my newbie questions

How do you:
upload the dtsx file to the SSIS server so that it can be run by the server

I'm still reading my book! Haven't gotten to the part about how packages are stored and run...

Thanks