I had a package where I am dumping multiple excel files (only sheet1 having data) from a folder to my database. I had taken a for each loop container configured it, Used a Variable @dump in the configuration of foreachloop container. In the data flow task taken an excel source and oledb destination, done with configuration of these. In the properties of excelconnection manager I tried to set the expression @dump to make all files in to the loop. But after doing this I got an error at excel source saying " SSIS Error code DTS_E_OLEDBERROR. An OLE DB error has occurred. ERRor code : 0x80004005...... ", with the help of an article from google, in the foreach loop container properties I made 'Delay Validation' property to 'True'. Then the package got executed. I want to how to over come with out making property to True and want to know the reason for that error.
Thanks in Advance, Naveen.
asked Aug 31 '12 at 05:43 PM in Default