Using parameters in a OLE DB source SQL scipt

  • Thank you in advance. I have defined two parameters. Just a simple SELECT. It works fine if I execute the task but it does not work when I execute the entire package. I importing data from one database to another. Using SSIS 2008 and Visual Studio 2008.

  • goaziz 51438 (3/17/2015)


    Thank you in advance. I have defined two parameters. Just a simple SELECT. It works fine if I execute the task but it does not work when I execute the entire package. I importing data from one database to another. Using SSIS 2008 and Visual Studio 2008.

    Saying that something "does not work" does not provide us with sufficient information to help you.

    What error do you receive?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • When I execute the whole package it runs ok. No error. But no rows are transferred. This task has parameters. This task also works fine if I just run it by itself. It is transferring data. But other task without parameters are working and data are being transferred.

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

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