Hi,
I have a SSIS package
In my source "data flow" task I have a stored procedure (sp_GetTrafficData)
which gets the data and populates the table in the destination task.

The stored procedure sp_GetTrafficData executes another stored procedure the
code is as follows:,

------Calculate the start and the end date
EXEC sp_GetTrafficData @affiliate_ID, @weekSpan

I have tried this also:
EXEC sp_GetTrafficData( @affiliate_ID, @weekSpan)

When I run the SSIS package it gives this error: VS_NEEDNEWMETADATA

I am banging my head aganist the wall, there is no joy so far

Please help

Kind Regards
Swordfish8 (AT) hotmail (DOT) com

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Hello;

Do you have two Variables in your Package that hold the values for the two
input parameters?

Set up your Source adapter and put in your command as :

sp_GetTrafficDate ? ?

Then hit the Parameters button. Map the two input parameters to the two
variables as appropriate. (Note: the Parse button WILL return an error but it
should run OK)

--
Todd C

"praveen" wrote:

Thanks Todd, A stored procedure UPDW_UpdateTraffic_DataMart runs in the SSIS
dataflow task, the parameters required for this procedure are provided by

------Calculate the start and the end date
EXEC sp_GetTrafficData @affiliate_ID, @weekSpan


sp_GetTrafficData is executed in UPDW_UpdateTraffic_DataMart stored
procedure and this is causing problems, if I comment Calculate the start and
the end date
code the SSIS Task Flow works fine.

Thanks
Sword



--
praveen.kumar (AT) aut (DOT) ac.nz


"Todd C" wrote: