Post reply

SSIS Importing from Access with Parameters

  • July 21, 2005 at 2:27 pm

    #186703

    I'm trying to import from an Access database using

    Integration Services from the June CTP. The way to do this

    is to use a SQL Command instead of a table or view in the

    data source. The '?' is used as a place holder according

    to BOL. I also set up a variable and assigned a value. I

    have a command something like:

      select * from category where categoryId = ?

    I click the Parameter button and see two parameters

    listed. I would think I should see just one. I match up

    one or both of the parameters to the variable. Either way,

    when I run the package it says the parameter is empty.

    Is this something that doesn't quite work correctly, or am

    I just missing something?

    Thanks for any help you can provide,

    Kathi

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • July 22, 2005 at 1:00 am

    #576314

    Sorry Kathi, I haven't seen this. Will you please open a bug and attach the package that's giving you the problem? Thanks, K

  • July 23, 2005 at 10:40 am

    #576610

    I installed the April CTP Hands On Labs VPC from the DVD and have it working with one parameter.

    I have submitted a bug report about the June CTP. In the June CTP, the only way this runs (but with incorrect results) is by naming one parameter "category_id" and the other one "?".  Since I'm only using one parameter, I should only need one of them.

    In the April CTP, I see only one parameter in the list, which is what I would expect. I have to set the name of the paramter to "?" and it works as expected.

    Now that I have one parameter working with the April CTP, how do I add a second parameter? The only thing I have found is to use "?" as the place holder. But then how do you map different "?" to different parameters?

    select * from customers where customer_id = ? or customerName = ?

     

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • July 24, 2005 at 1:31 pm

    #576633

    Finally got this one working, use Parameter0 and Parameter1 in the statement instead of the "?".

     

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 4 posts - 1 through 3 (of 3 total)

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