Post reply

Importing Spreadsheets

  • November 4, 2015 at 3:16 pm

    #309548

    Hi All

    I use a BID package to import a number of spreadsheets into my SQL table.

    In the table I've created an additional field "file detail"

    Each time I run through the data flow and puck up the next spreadsheet how would I go about adidas the spreadsheet file name to the "file detail" field for each record.

    Thanks for your help

    Andy

  • November 5, 2015 at 1:30 am

    #1837881

    How are you importing the spreadsheets? A for each file loop? If so you would have a variable to switch out the connection string to the spreadsheet.

    I would create a simple stored proc to update the table set the "file detail" column equal the a variable where the file detail column is null, then add in an extra execute sql task to execute the proc and pass in the variable from the package.

    Or if your comfortable with coding you could always look at creating a .NET script like in the following article http://www.select-sql.com/mssql/how-to-use-a-variable-inside-sql-in-ssis-data-flow-tasks.html

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

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