September 9, 2009 at 5:01 am
Hi All
I know that this would be a easy 1 for someone on here:
I have 8 directories which I need to scan about every 2 hours to check for new files. I have no control of the file names or creation dates or rename of file names etc.
Therefore I decided to keep a list of files which I've already read in, in a SQL Table and every 2 hours I would kick the job off on these 8 different directories, then use a FOREACH file to check if the filename is already in the stored table.
Currently I've got about 3000 files in all the directories, and at first I thought that a FOREACH File and then FOREACH ADO inside would be quick but that turned out to take more than 5 mins.
I therefore need to FOREACH file and then inside the dataflow either call a Stored Proc to retrieve a boolean if the current file is found in the stored table or do a lookup or something similar.
The Stored Proc approach, tells me that there is no output column to pass on to the next step in SSIS, even thought I pass an output parameter to the SP. The lookup again complains that there is no input columns.
I know it is an easy 1 but I think that the coffee I'm drinking is just to weak and I just can seem to find the correct way about this simple problem
Thanks
September 10, 2009 at 7:22 am
Did u create a resultset [0] for the stored procedure output??
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply