December 21, 2011 at 9:33 am
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
December 21, 2011 at 3:29 pm
Can you also paste the error message you are getting?
December 22, 2011 at 5:06 am
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