Dear All,
I have created a DTS Package in Integration Services 2005.
Within the DTS Package declared a variable named xxx and passed a value 1234.
In the control flow i dropped a Data flow task and in the Property Expression Editor of DataFlow Task i defined
Property = [DataReader Source].[sqlCommand]
Expression = Variable name.
Now in the DataFlow Task Canvas dropped DataReaderSource.
How can i pass variable value to the SQLCommand ="Select * from table where name = Variable value.
regards
Sufian
This post explains how to do that...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2009522&SiteID=1
|||sorry , i have a diffrent problem.
I need to know how can i pass the variable value to the query supplied in the SQLCommand custom properties in datareader source on execution.
the variable datatype is Int32 and i am getting error when i set the expression property in the expression builder (Cannot convert System.Int32 to System.String).
Regards
Sufian
|||
mohd sufian wrote:
the variable datatype is Int32 and i am getting error when i set the expression property in the expression builder (Cannot convert System.Int32 to System.String).
You can't concatenate a string with an integer. You'll have to cast the integer as a string and THEN concatenate.
The cast operator is:
(DT_STR, <length>, <code_page>) variable_value
Code page will probably be 1252.
-Jamie
No comments:
Post a Comment