none
SSIS Lookup - Set values programmatically

    Question

  • For the SQL 2008 R2  SSIS Lookup Transformation, how do I get the 'Modify the SQL statement' checkbox to be selected programmatically? I can change it through the front end, but I can't find the property to change it programmatically.

    As I set the properties:

    .SetComponentProperty("SqlCommand", "SELECT [Lookup_Code], [Product_I] FROM [vSource]")
    
    .SetComponentProperty("SqlCommandParam", "SELECT * FROM (SELECT [Lookup_Code], [Product_I] FROM [vSource]) [refTable] WHERE [refTable].[SUB_SYNM_C] = ? OR (SUBSTRING([refTable].[Lookup_Code], 1, 3) >= ? AND SUBSTRING([refTable].[Lookup_Code], 1, 3) <= ? AND SUBSTRING([refTable].[Lookup_Code], 4, 3) = 'XXX')")

    As I need to use <= and >= comparisons.

    But the checkbox is never ticked, can anyone please tell me what I need to do to tick the check box?

    Kind Regards 

    Rambabu.S


    Tuesday, August 20, 2013 1:02 PM

Answers

All replies