Using parameters in a OLE DB source SQL scipt

• goaziz 51438

  SSC Rookie

  Points: 26

  More actions

  March 17, 2015 at 9:37 am

  #295966

  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.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  March 17, 2015 at 9:40 am

  #1784538

  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?

  ---

• goaziz 51438

  SSC Rookie

  Points: 26

  More actions

  March 17, 2015 at 10:21 am

  #1784548

  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.