Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    50

    Lightbulb Unanswered: SSIS data flow parameterize query

    Hi,

    I am using SSIS in SQL Server 2005 and want to have a query like this in my data flow task

    Select a.*
    from abc as a
    inner join (Select max(b.id) as ID from xyz as b inner join pqr as c on b.id = c.id and b.id > ?) as t1
    on t1.id = a.id


    SSIS fails to detect the parameter (?) for the inner query and gives message.

    "
    Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.", so assuming this is your problem, then you can workaround.

    "


    The idea is to parameterize the inner query ,,,
    (so if the above query doesnt make sense ignore it )

  2. #2
    Join Date
    Jun 2005
    Posts
    50
    a colleague of mine got a reply from the SQL team saying "this feature is not supported.."

    i wud rather say its a BUG !

Posting Permissions

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