Post reply

SSIS 2008, how can I use parameterized query in OLEDB source of Data Flow task?

  • June 27, 2016 at 2:11 pm

    #327405

    How can I use parameterized query (Select statement Where Col1= 'U') in OLEDB source of Data Flow task?

    Attached is a test project that has three data flow taks:

    1 - regular select statement in OLEDB source of Data Flow (WORKS)

    2 - select statement in Variable (WORKS, too)

    3 - variable is used as ? in sq statement as param -- DOES NOT WORK

    3 a even if I use statement as COMMAND in OLEDB source and use ? inside statement and pap parameter in the task, still does not work.

    How can I proceed?

    Thanks a lot in advance

    Likes to play Chess

  • June 27, 2016 at 2:29 pm

    #1887139

    Duplicate post.

    Answers in here: http://www.sqlservercentral.com/Forums/Topic1797738-364-1.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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