Import w/o data but not fail
Trying to figure out how I can tell myself there is no data for that date and log it.
I can preview entire data set but I can’t be sure if it is picking all the right headers
As you said, you can do a Preview of the data source – what you see there is what you’ll get for data when the integration runs so I’m not sure what you mean by “picking all the right headers”.
Thanks Patrick, I figure it out. If I view excel source, I see the data, if I view data in the mapping ie create JE, I see the header row, sort of like how integration manager has the header/data preview. Usually when I preview the header, I can see if its selecting all the right rows I”m trying to import.
Another useful SC global variable is GlobalProcessCount.
This if the Record Count variable in the Process window and is the number of documents to be processed.
So if this GlobalProcessCount = 0, then that means there was no source data read.
Thanks for the info. Is there a way to pass the global process count into a sql statement if I run it in task ? should be right ? Ill give it a try.
If you would like to submit an answer or comment, please sign in to the eOne portal.