SSIS packages tasks go green (Extraction) but the table destination is empty
Hi everyone,
Ive been working with this package for a while... it was perfect until yesterday...I keep running my package and everything turns green... I have data on the source...but when I open the destination table is EMPTY !!! how come?? Does anyone knows
what could be wrong?? thanks in advance...
Regards,
Adriana
January 26th, 2011 9:17am
What steps are in the DF?
Did you watch the Rowcounter while debugging? Is it counting up?
Try to add a DataViewer after every step in DF.
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2011 9:21am
I'd agree with Christa in ensuring that you are actually seeing data flow through the data flow. In addition, are you sure that nothing else is modifying the data between when you run the package and when you are checking for data?Please mark answered posts. Thanks for your time.
January 26th, 2011 9:54am
Hi,
This is the components:
1. OLE DB Source with a query not transformations at all... just a filter of dates and a field. If I run that query on the sources pops information normally.
2. Copy Column (This is not necesary i think but I didnt developed the package)
3. OLE DB Destination
No transformations, and I will check the rowcount... and Ill comeback to you... thanks !
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2011 10:14am