Link to home
Start Free TrialLog in
Avatar of stretch73
stretch73Flag for United States of America

asked on

Editing Integration Services Package

I'm in a real bind trying to edit an integration services package on SQL 2005.  I ran a data import and then at the end of the wizard just selected to save it as a package.  Now I need to add something to the import and I can't figure out how to open it to do so.

Any thoughts?

N
Avatar of stretch73
stretch73
Flag of United States of America image

ASKER

Found a workaround.  Just re-did the import and re-saved the package.  Will need to readdress this when time allows.
Avatar of tncbbthositg
tncbbthositg

For future reference, I believe the best way to edit an SSIS package is to use Visual Studio 2K5.  If you're really super smart, you can just edit the XML :).

TNC
It is a valid question.  Can you refund the points and leave the question up?

TNC
You got to use SQL SERVER BUSINESS INTELIGENCE STUDIO.
MNetic, is your SQL Server Business Intelligence Studio not a part of Visual Studio 2K5?  How'd you manage to arrange that?

TNC
ASKER CERTIFIED SOLUTION
Avatar of DarthMod
DarthMod
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial