How do I convert number to string and pass it as argument to Execute Process Task

Question

I am using Execute Process task in SSIS 2008 R2  I have a variable idVar which is of data type Int32  I need to pass this variable to property Arguments of the task so the process executable can take this variable as argument  I use expression to assign  idVar to Arguments   Now the system says I need to convert Int to String so I used the following expression in the expression builder   DT STR  10  1252    User  IdVar     It gives the following error    Expression cannot be evaluated   Additional information  The expression   DT STR  10  1252    User IdVar   has a result type of  DT STR    which cannot be converted to a supported type    Microsoft DataTransformationServices Controls    What is the correct way to type cast the number to string

User · Answer

Expression   Total Count       DT WSTR  11   User  int32Value   for Int32 --  -2 147 483 648 to 2 147 483 647

User · Answer

Cause of the issue  Arguments property in Execute Process Task available on the Control Flow tab is expecting a value of data type DT WSTR and not DT STR  SSIS 2008 R2 package illustrating the issue and fix  Create an SSIS package in Business Intelligence Development Studio  BIDS  2008 R2 and name it as SO 13177007 dtsx  Create a package variable with the following information  Name   Scope        Data Type  Value ------ ------------ ---------- ----- IdVar  SO 13177007  Int32      123   Drag and drop an Execute Process Task onto the Control Flow tab and name it as Pass arguments  Double-click the Execute Process Task to open the Execute Process Task Editor  Click Expressions page and then click the Ellipsis button against the Expressions property to view the Property Expression Editor   On the Property Expression Editor  select the property Arguments and click the Ellipsis button against the property to open the Expression Builder   On the Expression Builder  enter the following expression and click Evaluate Expression  This expression tries to convert the integer value in the variable IdVar to string data type   DT STR  10  1252    User  IdVar    Clicking Evaluate Expression will display the following error message because the Arguments property on Execute Process Task expects a value of data type DT WSTR   To fix the issue  update the expression as shown below to convert the integer value to data type DT WSTR  Clicking Evaluate Expression will display the value in the Evaluated value text area   DT WSTR  10    User  IdVar    References  To understand the differences between the data types DT STR and DT WSTR in SSIS  read the documentation Integration Services Data Types on MSDN  Here are the quotes from the documentation about these two string data types  DT STR A null-terminated ANSI MBCS character string with a maximum length of 8000 characters   If a column value contains additional null terminators  the string will be truncated at the occurrence of the first null   DT WSTR A null-terminated Unicode character string with a maximum length of 4000 characters   If a column value contains additional null terminators  the string will be truncated at the occurrence of the first null

User · Answer

Expression   Total Count       DT WSTR  5   User  Cnt

[ssis] How do I convert number to string and pass it as argument to Execute Process Task?

The answer is

Examples related to ssis

Tags