Viewing 6 posts - 1 through 6 (of 6 total)
there are total 9 excel file in my folder and trying to extract them using for each loop container and data flow task and loading onto sql server destination.
once i...
September 6, 2012 at 12:12 pm
i changed the provider and followed the example that was specified in link that u posted me
everything works fine but the excel files are not being iterated only the...
September 6, 2012 at 11:44 am
hi J Livingston SQL,
as mentioned in the example i have specified
In the Collection I have provided Enumerator As: "Foreach ADO.NET Schema Rowset Enumerator"
Provider: .net provider for Oledb\microsoft jet 4.0...
September 6, 2012 at 11:21 am
i have tried this example but encountered with a prob i.e., in FIG 9 the database file are to be added
When i try to add database file...
September 5, 2012 at 3:53 pm
hi Evil Kraig F,
Thanks for the reply, as I'm new to ssis could you please explain in detail or if possible provide an example pkg for the requirement
Thanks in...
September 5, 2012 at 3:27 pm
i have tried the example but i'm getting an error saying
"[Excel Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager-source"...
September 5, 2012 at 3:08 pm
Viewing 6 posts - 1 through 6 (of 6 total)