I have to read all the excel files in a a particular folder one by one and move the contents to an sql database using SSIS.
The no: of excel files will vary each time.
Also the files will have different names.
Once a file is parsed it will be moved to another location (we will be using File System Task fo r this)
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…