DTS Check Source

I'm trying to export data from oracle db (source) to a SQL Server db (destin
ation). How can I check that there is data in the source db first before exp
orting the data.
CheersCat,
you can count the records in one of the tables you are referring to and then
put this value into a global variable as an intial step. After that you
execute the import dependant on the global variable value. Using multiple
paths in a workflow is a way to implement this :
http://www.sqldts.com/default.aspx?218.
HTH,
Paul Ibison