1. JKAU New Member

   Hi
   I have created the following;
   OLEDB Connection to the database
   variable --> user::GetName (string type)
   Exec SQL Task --> Select Top 1 contactname from contacts where contactname like 's%'
   How do I assign this select query single row value that is Contactname to the variable User::GetName.
   Thanks
   
   

   JKAU, Dec 6, 2008

   #2
2. satya Moderator

   One of the best reference on the web : http://www.simple-talk.com/sql/sql-tools/passing-variables-to-and-from-an-ssis-task/ about how to do it?
   

   satya, Dec 7, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in