locked
Oledb Source using Parameter with String Variable using "not in ?" RRS feed

  • Question

  • Good day,

    I have a simple query with a string variable: test = ('001','002')

    but i cant seem to add the parameter in OLEDB Source

    select * from table where col = ?

    but this dont work: select * from table where col NOT IN ?

    Not really keen on inserting query in Variable as i have a few of these similar queries or must i insert query in variable?

    Regards

    Thursday, January 6, 2011 1:07 PM

Answers

  • Why you dont try a different approach inside SSIS in spite of use SQL statment with parameters?

    This stament works select * from table where col = ?

    You can use after the OLEDB Source a lookup component to lookup the '001' and '002' stored in another location...

    Ahwt you think?

    regards,

    Pedro



    Visit My Business Intelligence Blog - If your question is answered, please mark as answered.
    • Marked as answer by Ismailc Thursday, January 6, 2011 2:44 PM
    Thursday, January 6, 2011 1:55 PM

All replies

  • Why you dont try a different approach inside SSIS in spite of use SQL statment with parameters?

    This stament works select * from table where col = ?

    You can use after the OLEDB Source a lookup component to lookup the '001' and '002' stored in another location...

    Ahwt you think?

    regards,

    Pedro



    Visit My Business Intelligence Blog - If your question is answered, please mark as answered.
    • Marked as answer by Ismailc Thursday, January 6, 2011 2:44 PM
    Thursday, January 6, 2011 1:55 PM
  • For Not in to work u need to use SQl command variable


    Cheers , Varun

    Thursday, January 6, 2011 2:33 PM
  • Thank You, i do not want to use a variable.

    But found a different way by simply, suning union & conditional split

     

    Thank You.

    Thursday, January 6, 2011 2:44 PM