Post reply

SSIS EXECUTE SQL TASK

  • April 18, 2016 at 2:54 am

    #313307

    Hi All

    I am using Execute SQL task to insert data into excel file with connection type as 'excel'

    If i use following query it executes successfully and data loads into excel

    INSERT INTO [Sheet1$B1:B1] VALUES ("Sample")

    but it gives error if i pass the value through parameter

    INSERT INTO [Sheet1$B1:B1] VALUES (?)

    I want this value to be configurable but not able to find the proper solution, Can you please help me in this?

    Thanks in advance 🙂

    nik

  • April 18, 2016 at 4:08 am

    #1872685

    One way to do this is to create a variable with an expression which includes the value that you want. You can then use the variable as SQLSourceType in the Execute SQL Task.

    Jez

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

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