Execute SQL Task error

  • Hello,

    I have an issue with execute sql task. I have 2 variables in execute sql task.Count and filename.In the sql statement I have given like this

    INSERT INTO dbo.esg_account_audit(operation,num_records,file_name)

    Values( 'Account file loaded',?,substring(?,32,32))

    The first ? is count and the second ? is filename. I am getting an error. Please correct me if I am doing anything wrong.

    Thanks

  • Can you also paste the error message you are getting?

  • srik.kotte (12/21/2011)


    Hello,

    I have an issue with execute sql task. I have 2 variables in execute sql task.Count and filename.In the sql statement I have given like this

    INSERT INTO dbo.esg_account_audit(operation,num_records,file_name)

    Values( 'Account file loaded',?,substring(?,32,32))

    The first ? is count and the second ? is filename. I am getting an error. Please correct me if I am doing anything wrong.

    Thanks

    How did you do the parameter mapping?

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

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

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