Easy one

[Sinopia]

I have created my first DTS package which transfers SQL tables to txt files. The last transfer did not finish successfully because I forgot to redefine my columns after removing a table and join. I fixed the problem but now I have four out of five successful transfers and only want to re-run the fifth.

I just can't figure out how to only run one piece of my package, unless I edit each workflow property option and 'disable' all of the successful tasks. Isn't there an easy way to just manually run one process that I have selected??

There is very little that truly can't be done. If it's justifiably needed it's best if one won't not try it, and eventually doesn't not finish it.

 

[Sinopia]

Does this mean this is not so easy?

There is very little that truly can't be done. If it's justifiably needed it's best if one won't not try it, and eventually doesn't not finish it.

 

[MaffewW]

If you are running SQL 2000 DTS then you can right click the step and click execute step. I dont think the option was available in SQL7

Matt

Brighton, UK

 

[Sinopia]

Thanks, yes. I'm using SQL7.

There is very little that truly can't be done. If it's justifiably needed it's best if one won't not try it, and eventually doesn't not finish it.

 

[closesupport]

Sinopia

You can use workflow to switch on and off different parts of a DTS. I use this technique when building complex DTS routines and I don't want to run part of a DTS that is already tested. If you are interested in this technique then let me know.

Cheers

Pete