hi ppl,
i'm trying to design a dts that does the following:
1st - select COD,NAME,PHONE from TABLEXPTO where SENTFLAG=0
2nd - write thoose records into a file expfile.txt
3rd - if the writing of the records runs well then
update TABLEXPTO set SENTFLAG = 1 and SENTDATE = getdate() where SENTFLAG = 0
4th - send an email with the atach file expfile.txt
Note: the tabelxpto is like this
COD,NAME,PHONE,SENTFLAG,SENTDATE,PKID
I try to use datadrivenquery but something is in may way...
BY
i'm trying to design a dts that does the following:
1st - select COD,NAME,PHONE from TABLEXPTO where SENTFLAG=0
2nd - write thoose records into a file expfile.txt
3rd - if the writing of the records runs well then
update TABLEXPTO set SENTFLAG = 1 and SENTDATE = getdate() where SENTFLAG = 0
4th - send an email with the atach file expfile.txt
Note: the tabelxpto is like this
COD,NAME,PHONE,SENTFLAG,SENTDATE,PKID
I try to use datadrivenquery but something is in may way...
BY