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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 How can I edit a SSIS package

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2008-02-20 : 09:53:13
OK, I've figured out how to create and schedule my packages.
now I want to go back in and redefine some of the options.
How can I get at it so i can edit it.

thanks
ICW

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-20 : 10:05:48
Is this a deployed package?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2008-02-20 : 10:08:03
I created it with the import wizard, and save it as a ssis package.
I have since included it as a step in a job I created.
Hope that makes sense!
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-20 : 10:21:40
Have you saved it File system or database?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2008-02-20 : 10:28:29
Database..I think...I thinks it's in the MSDB database somewhere
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-20 : 10:35:44
Well, then first save the package to file system. Then in Business Intelligence studio, create new SSIS project and add the package file saved.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2008-02-21 : 00:42:14
thanks
Go to Top of Page
   

- Advertisement -