none
Loading data from excel to excel using SSIS RRS feed

  • Question

  • Hi Experts,

    I've a requirement to load data from one or more excel sheets available in shared folder to another excel sheet in another shared folder.

    For example, the data from excel sheet names AAA,BBB should go into new excel sheet ABB and data from AAA, CCC should go into another new sheet ACC.

    the sequence should be first we have to load ABB  and then ACC and if any error happens in between we have to send email.

    so everytime whenever we have files in source folder this package should get run automatically by picking up the files from the folder and loading into the respective destination excel sheets.

    Could you please give idea on how can do this better. I've following points in my mind...

    1. Creating a table in sql server with unique id and sheet name and file path

    2. In ssis, having foreach loop container,

    3. inside foreach loop, data flow task to pick up file name from variable and loading till enumerated.

    please help in doing it better and in efficient manner.

    Thanks in advance 

    --NoorBi

    Saturday, August 17, 2013 2:02 PM

Answers

All replies

  • Hi ,

    I've a requirement to load data from one or more excel sheets available in shared folder to another excel sheet in another shared folder.

    Load or move / copy the files ?

    Loading Mutiple Excel Files - http://bi-polar23.blogspot.in/2007/08/loading-multiple-excel-files-with-ssis.html

    the sequence should be first we have to load ABB  and then ACC and if any error happens in between we have to send email.

    Make use of Send Mail Task - http://technet.microsoft.com/en-us/library/ms142165.aspx

    so everytime whenever we have files in source folder this package should get run automatically by picking up the files from the folder and loading into the respective destination excel sheets.

    Make use of  WMI Event Watcher Task - http://technet.microsoft.com/en-us/library/ms141130.aspx

    Yes, getting list of filenames in table or variable of Object type and then loop thru each files using ForEach Loop Container .


    sathya --------- Mark as answered if my post solved your problem and Vote as helpful if my post was useful.

    • Marked as answer by SQL2012BI Sunday, August 18, 2013 9:26 AM
    Saturday, August 17, 2013 5:30 PM
    Moderator
  • Hi,

    I found something here...

    http://sqlsaga.com/ssis/how-to-load-data-into-a-database-table-from-an-excel-spreadsheet-using-ssis/

    https://www.facebook.com/sqlsaga


    hope it helps :)
    Saturday, November 23, 2013 10:11 PM
  • HI, I want to use SSIS to pull the LIVE data from the website and dump the data into my sql server database. Could any one suggest me the steps to achieve this. Can this be accomplished by Web services task. For example I want to capture LIVE gold price or cricket score and dump into my DB table.
    Friday, April 4, 2014 7:20 AM