did you find a resolution? i am having same issue and cannot find

ANYTHING to help!

I feel your AS400 pain 🙂

I use the OLEDB for DB2 provider to retireive the data off our AS400, runs faster than an ODBC connection.

You'll want to, among...

I may be in over my head here, and I certainly dont have the

hardware knowledge that the rest of you do but...

I had to prove to mgmt the reasons why...

Package configurations are a godsend.

I actually made a pkg template so all my connections and pkg config, variables and logging settings will be consistent across all pkgs. So if...

Anyone?

Also, the other problem with doing this is that I would store the ID from the junk

dimension, which effectively means that the AS400 sent me a valueof 1...

hey thanks for the new SSIS component!

Not sure if this is what you are talking about, but...

I store my pkgs in msdb. I use package configurations to ease

in deploying to diff environments. Then we...

Are you running the pkg manually in BIDS? If so,

did you right-click the pkg in the solution explorer and then select "Execute" ?

I've not had any luck with this either, aside from

creating say, 2 stored procs...1 for the dataset and 1

for the several values.

I"d love to know if this is possible...

I too would love to know how this could be done

I am using SSRS 2008.

Sure!

Add a new parm and for the property it is a Global (like the userid global), make sure

it is a hidden parm.

Then, in your stored proc, pass in the...

I have always trained people that when using SSRS, if you make ANY change

to a stored proc to always then open rpt, go to data tab, select the dataset

that the...

Ive also handled this sort of situation by adding a script

componenet and creating a new output to redirect the

entire row for my error handling. Just a thought 🙂

This error msg sounds like one Ive seen before. SSRS sometimes is not the best at telling

you what's really wrong and in the right order.

But I digress...

If you have...

Dont know if this will help but...

I had a sales rpt from our CRM that basically everyone in the company needed to see, but it

was imperative that it be restricted...