How to upload an SSIS package to an sql 2005 server?

[BOA_Dev]

I have an old 2000 dts package that I converted into an Integrated services package using the Business Intelligence Dev Studio but I have no idea how to upload it to my sql 2005 database. Has anyone here done this before? Something tells me I'm going about this all wrong...

 

[giadich]

If I remember correctly sql 2005 has a migration wizard fro this and you see it when you do a right click i think.

 

[BOA_Dev]

Hi giadich,

I went to Management->Legacy->Data Transformation Services->right click->Migration Wizard. I selected the packages to migrate and it seemed to work however when I tried to open the Data Transformation Services folder it gave me a permission denied error. Im not the dba so that's something I may have to work out with him.

But since I already converted the dts into an SSIS package isnt there a way to take that and upload it to the server? I don't even see a folder where SSIS packages would be stored in the Management Studio.

 

[giadich]

If you connect to the DB server you won't see the packages... It's gotta be SSIS or something like that... I forgot the formal name for it and can't get to my server from where I am currently at.

About the permission error, this is a known issue... You have to install some components to fix that issue. I suggest you talk to your DBA about it and follow the link below to fix that issue.

http://support.microsoft.com/?kbid=917406

 

[Greg.NET]

There must be a way through the intelligence dev studio

 

[Greg.NET]

ah here we go:

http://msdn2.microsoft.com/en-us/library/ms137565.aspx

 

[BOA_Dev]

ok that shows me how to upload them to the server. awesome. But I still don't know how to view them. I saved them to the "SSIS packages" folder on the server but that folder isnt visible from the management studio.

I just want to be able to open up the package, make any changes I want, save it to the server, and execute it. Just like in the sql 2000 enterprise manager.

 

[BOA_Dev]

thanks giadich I logged into Integration Services instead of the db server. But it only lets you execute the packages from there, I can't edit them. Every time I want to change a package will I have to export it from integration services to intelligence studio, then edit it in intelligence studio, and then save it back to the server?