Post reply

Passing entire file path in SSIS

  • August 23, 2010 at 9:06 am

    #141755

    Hi everyone,

    I need to pass an entire file path in SSIS. This file path contains an file with values that need to get inserted into the table in SQL Server.

    For eg :- "C:\documents and settings\my documents\importdata.xls"

    in the above example, importdata.xls contains values that need to get inserted to a table in SQL, the table in SQL also has the same number of columns as in the excelsheet.

    How can i do this in SSIS ? Please provide me with the steps in SSIS on how to achieve this as I m new to SSIS.

    Thanks !!!!

  • August 24, 2010 at 5:01 am

    #1210916

    You can store the file path in a variable. Use an Excel source with an Excel Connection Manager to read out the Excel file. Then use this variable in an expression to set the ExcelFilePath property of the Excel connection manager.

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

Viewing 2 posts - 1 through 1 (of 1 total)

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