December 1, 2011 at 12:17 am
hi
in my ssis i m having 2 variables called a & b
by using row_count transformation i count this 2 variables value like
a=9
b=12
in my target table i want to add this 2 values update into my table..
ie update <table_name> set <col_name>=(?)
if i use one variable in execute sql task it will work
but when i use update <table_name> set <col_name>=(?+?)ie(a+b)
then pass 2 variable in execute sql tesk it will not work
so how to do this in ssis
December 1, 2011 at 12:22 am
please post the error message you are receiving.
December 1, 2011 at 12:30 am
failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply