Where do DTS Wizard jobs save?

[Catadmin]

Does anyone know where does a job created with the DTS Import Data or Export Data wizard save?

I know there are four locations / types of DTS packages:

The MSDB saved package
The Meta Data Services package
The Structured Storage File package
and the Visual Basic Code.

Due to security reasons, I don't want to save my packages as the SSF or the Visual Basic Code package. I would prefer to save it in the MSDB rather than using Meta Data Services (only SQL will ever be using this package), but I haven't ruled out Meta Data Services as it tracks the history of the package.

I thought when I went through the wizard, I would get a choice of how to save the package, but I'm not seeing it. Anyone know what I'm missing?

Thanks!



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[Catadmin]

Additional question.

When scheduling the steps and precedence in DTS, can you create 3 steps, have step 1 & step 2 run at the same time, then have step 3 only run if BOTH step 1 and step 2 succeeded?

Or will I need to create precedence on both step 2 & step 3 so that step 2 doesn't complete if step 1 fails and the same for step 3 if step 2 fails?

If that didn't make sense, let me know and I'll try to clarify.

Thanks!



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!