Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DTS Source Modification
0 views
Skip to first unread message
Eric Dion Baker
May 21, 1999, 3:00:00 AM5/21/99
to
Hello All -
I have a DTS Package that moves data between 2 SQL Server databases. I have
a status flag field in the first database that I would like to modify once
that record has been pumped to the other database. Any suggestions? Is it
possible to modify the "DTSSource" value?
Any suggestions or help would be greatly appreciated, please feel free to
post or email directly.
TIA
Eric Dion Baker
eba...@pensat.com
Irina Krechmer
May 21, 1999, 3:00:00 AM5/21/99
to
In the transformation script you can use ADO to execute a stored procedure
or SQL query that would update the status field in the source database.
or SQL query that would update the status field in the source database.
Eric Dion Baker wrote in message ...
Euan Garden
May 21, 1999, 3:00:00 AM5/21/99
to
Hi Eric,
You could execute a DDQ Update to change the flag in the target
database after the pump has executed.
You could execute a DDQ Update to change the flag in the target
database after the pump has executed.
Euan
Eric Dion Baker <eba...@pensat.com> wrote in message
news:btj13.824$ve5....@news.rdc1.ne.home.com...
Bill Hodghead
Jun 7, 1999, 3:00:00 AM6/7/99
to
You can also use a DTSLookup in an ActiveX script task to do a update on the
source flag. The lookup doesn't need to be a select.
source flag. The lookup doesn't need to be a select.
0 new messages