how to use SSIS Variables in ADO.NET Connection manager RRS feed

  • Question

  • Hello All want to know how to use SSIS Variables in ADO.net Connection Manager?

    Is there any other way to use it. I was trying to use it using expression in ADO.net but it show me length 0010 does not match with length 0014.

    Please guys help me out.

    Wednesday, November 2, 2011 11:10 AM


  • what do you want to set the connection string with variable?

    if yes, you can click on connection manager, then go to properties pane, and in the expression property set the ConnectionString with the variable.

    but if you mean anything else, explain more...

    • Proposed as answer by Eileen Zhao Monday, November 7, 2011 8:37 AM
    • Marked as answer by Eileen Zhao Wednesday, November 9, 2011 6:17 AM
    Wednesday, November 2, 2011 12:56 PM