April 17, 2012 at 2:11 am
Hi
I'm trying to put together a packege to lift data from 3 Excel spreadsheets in a folder.
I've got a For Each Loop container which picks up the name of the spreadsheet then a script task to update a Connection String variable which is then passed into a Data Flow.
In the Data Flow I have an Excel Source with an Excel Connection Manager and I pass the Connection String variable in.
Finally I have an OLE DB Destination which drops the data into a table.
The problem is that sometimes the package works, but sometimes it doesn't.
When it works it picks up all the records and inserts into the table no problem.
Sometimes the Data Flow part will just hang with the Excel Source yellow and the OLE DB Destination green, but no error message is generated that I can see, it just seems to stop.
Anyone seen this before, or could possibly suggest any way of finding out what's happening?
Any thoughts appreciated - Don
April 17, 2012 at 5:13 am
Certainly experienced the same problem when using an excel source within a foreach.
What I did find was that this issue only seemed to occur when running in design time and I put it down to a very slow machine at the time. Not conclusive I know, but it was extremely intermittent in occuring.
'Only he who wanders finds new paths'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply