April 26, 2012 at 3:54 am
Hi Friends i have small doubt in loading data .
suppose i have a folder that folder contains 3 excel sheets data and 5 flat files data. all sheets data like
id,name,sal so how to load flatfiles and excel sheets data dynamicaly in ssis .iam trying to useing foreach enumrator but some error occurs. plz tell me how to use foreac enumrator while loading flat files and excel sheet dynamicaly. plz tell me the process. is it possible or not to loading data
April 26, 2012 at 4:00 am
Have two ForEach loops - one for txt files, and one for Excel files.
John
April 27, 2012 at 3:17 am
You should have two for each container one for text file and one for excel
or convert excel into text files
April 27, 2012 at 5:37 am
Next time, also post the error message. It would be quite hard to debug without it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply