June 7, 2010 at 5:54 am
This is my first exposure working with SSIS packages. What I am trying to do is open an existing SSIS package on a remote server instance from my desktop.
There are a bunch of SSIS packages that I have to inspect to see exactly what they are doing and then get them scheduled on our Production Server. The person that developed the packages is long gone : )
I connected to the Production Server and exported the packages and then imported them into a Test SSIS instance on another server so I could play around with them.
I then launched Business Intelligence Development Studio on my Desktop but cannot figure out how to connect to the remote instance so that I can inspect the packages to see what they are doing and test them. Can anyone help?
June 7, 2010 at 6:22 am
Use the Export Package as u used earlier but choose the package location as the File system and save the package to your disk. Now you can open and edit the package using the BIDS.
June 7, 2010 at 6:37 am
Thank you. So if I want to redesign the package.. I would export it, make the changes, and then re-import it??
June 7, 2010 at 6:59 am
I opened the package in BIDS using File\open and choosing one of the packages that I exported.. I right click on one of the tasks in the package and choose properties.. then I have 2 options:
Edit Package and Load DTS2000 Package internally.
Both options do nothing.. i just get a clock and it never opens.. am i doing something wrong?
June 7, 2010 at 12:08 pm
Editing the packages is always done with the files in BIDS. You cannot edit them "in-place".
From a source control perspective this is good. You should have a master copy of the packages OUTSIDE of the database. Check them out, edit them, check them back in.
Do you have the backward compatibility tools installed?
CEWII
June 7, 2010 at 12:31 pm
I do not know if the backward compatibility tools are installed.. ?? how do I tell?
You are right.. it is great for source code control. we use source-safe and checking the packages in and out sounds like a great idea!!
I have been playing around with this on and off all day and I finally went into the Legacy Section in Management studio and I am able to see the DTS Packages and edit them there.. evidently this SQL server was upgraded in place or someone migrated the packages from a 2000 instance.. I am not sure. I'm hoping I can just edit the DTS packages and schedule them that way..
June 7, 2010 at 4:06 pm
You CAN edit DTS in-place but you cannot schedule them like you used to be able to do by right-clicking and chosing schedule..
I strongly recommend using source control for both DTS AND SSIS..
You might go out to the SQL Server Feature Pack website and download the backward compatibility tools and install them on whatever machine you are using to edit the package.
CEWII
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply