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
 SQL Server Administration (2005)
 Maintenance SUB plan export

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-04-01 : 11:55:11
My subplans are not getting exported using SSIS/BIDS. If I use SSIS/BIDS only the first plan gets exported, the rest don’t. Anyone came across this problem?


------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-01 : 14:43:01
Can you explain clearly what you did in SSIS/BIDS?
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-04-01 : 14:53:50
Solved this one!

The subplan option is introduced in SP2. I was doing an export from SP2 to SP1. Hence subplans were not getting copied.



------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -