Post reply

connection proerty in Execute SQL TASK

  • April 18, 2008 at 11:48 pm

    #121154

    Hi,

    I have set the variables(uid,pwd,server and DB) in SSIS for my SQL Connection which will dynamically changes. I want know how to set these varaibles in the property expression builder with the connection property.

    I new to this SSIS, so pls provide or explain with steps or send me the link. Help Urgent!!!

  • April 21, 2008 at 12:49 pm

    #805153

    When u click the propert expression square eclipse on the right, an expression builder opens, where u can bulid the expression and also u can evaluate it before u press ok.

    ur variables are quite confusing. and also what is that u trying to makre dynamic? connecting string , name, ? u see list of the events that u can map to ur variable or build expressions for that events.

    Kumar

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply