SQL Server Performance

SQLTask ResultSet =?(Full Result), write Result TO DataFlow Task OLEDB Destination

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Aug 15, 2007.

  1. Ismailc New Member

    Hi, I've been strugling to set a parameter in Microsoft DB2 OLE DB Provider & tried setting SQLvariable but can't pass another SQL source variable as a parameter within the SQLvariable.
    So i'm trying something different.
    SQL Task
    , Expression (sqlstatement source)
    Expr: "SELECT sicust from b610clivF.SIH WHERE SIINVD = " + [User::DateFrom]
    It executes but can't set the ResultSet to:? (Full Result Set)
    in order to create a Data Flow Task and write the Result to a OLEDB Destination.
    Is this in anyway possible or any other way, can anyone please help?
    Regards, Ismail
  2. satya Moderator

  3. Ismailc New Member

    Thanks but I added a global variable to the package, then in the properties of the variable insert the query then on OLEDB source query from variable.

Share This Page