There is no such thing as a "dumb question" if you don't know the answer...

To answer your question, when you schedule the package to run, it creates a job in...

I'm guessing this is where Microsoft may not support it. You can...

Once you have the DTS package created in Enterprise Manager, right-click on the package and select Schedule Package. This will setup the schedule to run inside of the SQL Agent.

If...

That can be set differently for each column. It looks like you'll need a way to modify the XML of the package to be able to change it for each...

I believe you have to have the variable created in the package before you can map a parameter to it.

Does the Agent user have appropriate rights to the destination?

Are you trying to do DTS in 2000 or SSIS in 2005?

I don't recall seeing that this is not supported by Microsoft. Be sure to run the Upgrade Advisor to make sure the database will be compatible with 2005.

These links should...

Just a thought here, how does maintaining SOX compliancy affect this?

My knowledge started with...

Also be sure to run the Upgrade Advisor to make sure you don't have any issues with objects in the database that are not 2005 compatible.

This showed me 70 vendor...

Many thanks, the example is perfect. One more thought - If I setup that script to run weekly, would it ever be beneficial to just do a rebuild of ALL...

Paul Randal (1/26/2008)

---

Specifically, rebuild will update statistics with a full scan (so don't manually update stats too otherwise you could end up with worse stats if your default is to...

Definitely good to know. It seems like Microsoft needs to put a little more thought into this. Since this has to be done from the original media, it should be...

Interestingly enough, our vendor has certified the product for SQL Server 2005 but they require the database to remain in compatibility mode 80.