Ive asked the DBA to recreate the job Stored Procedure set at the job level. (Adding this IS package 6 times for each year) BUT Ive got some time between...

tried absoloutely tonens of things now including only using one parameter and Unfortunately Ive not gotten anywhere.

Really dissapointing but it looks like Im going to have to come up...

I think I have done it (Hopefully)

I just ran the test and obviously it failed.

Im getting errors such as Error: The type of the value being assigned to variable...

Im just trying to copy and paste the bits out from one to another, Its gone a bit wrong so Ill need to do a bit of fixing

Ill have a...

I dont know how to do that unfortunately. Also if Im thinking correctly the package is really big. Ive got lots of stuff in there so Id have to create...

Well Its going a lot better so far but Ive got confused at the variable mapping section.

Ive updated my blog with the story so far on this one with...

Right....

Im going in!!!

Ill work through what you have just sent me and let you know.

Thanks loads for this BTW!

Martin Schoombee (11/21/2011)

---

You don't need a separate variable for each field in the returned resultset. It can all be contained with the same object variable, and then used in the...

Martin Schoombee (11/21/2011)

---

Debbie Edwards (11/21/2011)

---

Which part are you struggling with?

You will need:

1. An execute SQL task, with the query to select all the data you need. The results of this...

Its kind of there but it doesnt use a table to populate the variables. it seems to be focused on the Filename variable again, It seems to be missing the...

John Mitchell-245523 (11/18/2011)

---

Debbie

Create a table in your database that holds the years you are going to use as parameters. In your package, select from this table into an Object...

It is possible, but a little different to what you envision. Child packages can be set up (through the configuration settings) to receive parameter values from a parent package. But...

Create a table in your database that holds the years you are going to use as parameters. In your package, select from this table into an Object variable. Then loop...

I like the sound of that.

I already have a SELECT DISTINCT AC_YEAR FROM dim.Date_Time

Ill have a good old think. That sounds good!

I had thought about that but couldnt find where to do it in the job.

So is the above not possible? Setting the parameters at the top level for each lower...