Hello,

I'm rather new in sqlserver and dts. I have to archiv old data from our
main database to an archivdatabase (data older then a year). I build a
dts package which shoud run following:
Copy the needed tables to from database to archiv (runs without an
error just the first time, I know). On error, send mail and go to the
next step. Here, test the first archiv table of exist. If not, send
mail and go to next table. If it exists, transform data from database
to archiv. If fail, send mail and go to next table. If no error go to
next table.

My problem now is, that the package runs to the first transformation
(of 9), do it well and stops then, even I planed to go the step, check
next archiv tabel of exist. May I only run one transformation in a
package?

You can run many transformations in the package but without an error message
I doubt many of us will be able to providfe anything other than generic
help.

Are you moving the whole DB?
What is the purpose of the destination?

You may have more success with BACKUP/RESTORE


Allan

"catweezle2010" <catweezle2010 (AT) gmx (DOT) de> wrote

Hi Allen,

no, I don't want to move the whole database, just a few thousend
records of some tables. In dts there are three kind of handles: on
success, on error, when finish. I can't believe, there is no way to
say, go this way when error and it stops after a few steps after this.
My first errormail comes up as second step. After this two other steps
will be handeled (testquery and first transformation). This two without
an error - then it stops.

I think I've found it. I did it in row, which means, I trie to copy
data from table 1. On succsess i delete the original data an go to copy
data from table 2. On error I send a mail an go then to copy data from
table 2. So I com from two sides to table 2. In meaning one way for
succsess and one for fail. But dts only knows 'and'. So both workfolws
must be done, what woud be nonsense. Now I'm testing to start the copy
of data parallel. After this each transformation goes a failway
(sending an errormail) and a rightway (in the moment a successmail,
later the deletequery). And it seems to run.

Thanks for help.