Results 1 to 4 of 4

Thread: DTS question

  1. #1
    Join Date
    Jan 2004

    Unanswered: DTS question

    How do I use a global rowset variable in a SQL statement where a value should be IN ( ? )

    where ? is mapped to the global rowset variable

  2. #2
    Join Date
    Jan 2004

    Let me add some detail

    I have two different data sources.

    I need to pull from source (1) to Souce (2).

    The data pulled from souce(1) needs to be based on values in a table in source(2).

    Select fields
    from source(1)
    where field1 in ( Table in source 2)

    Is this possible with DTS?

  3. #3
    Join Date
    Feb 2004
    San Antonio, TX
    try this link
    [BOL] Using Global Variables with DTS Packages

    [BOL] Execute SQL Task look lower into the doc for "Populating a Single Global Variable with an Entire Rowset"

  4. #4
    Join Date
    Jan 2004
    I have the global variable (rowset) populated, but how do I use it in my where condition?

    where field in ( ? ) I get an error when I map the parm to the global rowset variable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts