Post reply

SSIS: trouble parameterising SQL

  • October 28, 2008 at 8:45 am

    #124116

    hi

    i have a large bit of sql and i thought "i shall parameterise this" created my variable and stuck my "=?" in the SQL, went for the parameter button and got

    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 onwards! to create a variable that can be evaluated, created a new variable..."evaluate as expression" and stick my SQL in the expression

    now..the properties thing...it's only one line! am i going mad and missing something obvious? or is this Bill Gates ruining my day again?

    and if it is a flaw...can i still get it done in vb.net (of which i know nothing yet!)

  • October 28, 2008 at 9:04 am

    #890699

    if you click the elipses button at the right of the expression property field for the variable, the expression builder will open up and you can use that to build your expression.

    tom

    Life: it twists and turns like a twisty turny thing

  • October 28, 2008 at 9:22 am

    #890721

    on the Expression property of a variable?

    there is no ellipsis

    ?!

  • October 28, 2008 at 10:05 am

    #890759

    i get the following in the properties tab when i click on a variable:

    if you click on that button the expression builder should open up

    Life: it twists and turns like a twisty turny thing

  • October 28, 2008 at 10:11 am

    #890768

    no piccy?

    i haven't got one..perhaps i'm on an early service pack or something...

  • October 28, 2008 at 10:25 am

    #890780

    hmm, perhaps your company blocks flickr?

    if you send me your email address (you can pm if you'd rather) then I can send the picture as an attachment.

    Tom

    Life: it twists and turns like a twisty turny thing

  • October 28, 2008 at 10:34 am

    #890787

    oh yeah it is blocked, will look at it out of work

    many thanks

  • October 28, 2008 at 10:38 am

    #890790

    i have added the pic as an attachment here

    Life: it twists and turns like a twisty turny thing

  • October 28, 2008 at 10:47 am

    #890795

    aha

    as suspected...it's just me 😀

  • October 28, 2008 at 10:54 am

    #890801

    are you on bids sp1?

    http://www.windows-tech.info/15/6014868d7d02fe0a.php

    Life: it twists and turns like a twisty turny thing

  • October 29, 2008 at 7:54 am

    #891230

    aha

    bingo, i think you have it. i have instructed the powers that be to get me that SP...will let you know how i get on

    many many thanks, good to see it was Bill Gates's fault and not my ignorance 🙂

    and for anyone as new as i am to SSIS who googles and gets this thread: to see what SP you have installed go help>about visual studio>SQL server Integrated Services

    these are the appropriate version numbers

    No service pack is 9.00.1399.00

    SP1 is 9.0.2047.00

    SP2 is 9.0.3042.00

  • October 31, 2008 at 7:59 am

    #892346

    got it!

    sp2 solved it and my ellipsis is there

    many thanks hodgy

Viewing 12 posts - 1 through 11 (of 11 total)

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