SQL Server Performance

Assign a single column query value to SSIS variable

Discussion in 'SQL Server 2005 Integration Services' started by JKAU, Dec 6, 2008.

  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

  2. satya Moderator

Share This Page