Post reply

Single file excel file upload to sql destination

  • July 30, 2014 at 2:28 pm

    #309587

    Hi,

    I have a file which changes every week @C:\TEMP(data and filename both) schema remains the same all the time. I want to import this data to sql and save it to archive folder.

    I will have only one file in temp as the executed file goes to archive. The folder becomes empty.

    Please suggest.

    I have tried for each loop for this but doesn't seem to work. I am using visual studio 2005 and my excel files are in 97-2003 version(.xls)

  • August 5, 2014 at 6:53 am

    #1735156

    your question is not clear,

    I can understand two questions.

    How can I view / why my files are not visible once it is processed from the package. ?

    How can I import an repository file into DB and then move the file to an archieve file ?

    kindly reply back which is your question. or give your question clearly as it is not now.

  • August 5, 2014 at 6:57 am

    #1735157

    susmitha117 (7/30/2014)

    Hi,

    I have a file which changes every week @C:\TEMP(data and filename both) schema remains the same all the time. I want to import this data to sql and save it to archive folder.

    I will have only one file in temp as the executed file goes to archive. The folder becomes empty.

    Please suggest.

    I have tried for each loop for this but doesn't seem to work. I am using visual studio 2005 and my excel files are in 97-2003 version(.xls)

    How come the for each doesn't work?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 5, 2014 at 6:59 am

    #1735159

    hi

    sorry for not being clear. I am trying to build a ssis package where after imported to sql table the excel file should go to archive folder(to have a history of processed files). My source file is excel and destination is mssql.

    I have solved this issue by using file system task after my data flow task.

    Appreciate your reply

    Thanks

  • August 5, 2014 at 7:03 am

    #1735162

    yes, that is the solution I too thought, and make sure you give "Operation"="move" in the file system task editor and overwrite destination set to true.

    Thanks,

    Prabhu

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply