Post reply

package variabel as lookup table

  • November 3, 2011 at 3:12 pm

    #390759

    Please let me know, how can I use package variable (populates GUID table), for lookup. I need to check the data in the GUID table and decide the data is new or existing. Thank you.

  • November 4, 2011 at 2:42 am

    #1403103

    You can't.

    The Lookup component can only use an OLE DB connection manager.

    I would stage your GUID table in SQL Server, than use the Lookup component to perform your lookups against that staging table.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 7, 2011 at 6:26 pm

    #1404236

    radb4u (11/3/2011)

    Please let me know, how can I use package variable (populates GUID table), for lookup. I need to check the data in the GUID table and decide the data is new or existing. Thank you.

    If you can use third-party solutions, check the commercial CozyRoc Lookup Plus component. It supports using reference data from package variable.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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