DTS Check Source

I'm trying to export data from oracle db (source) to a SQL Server db (destination). How can I check that there is data in the source db first before exporting 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