Hi - thanks for the reply. We resolved this issue in the end by amending the security permissions the account running the report to have modify permissions to C:\Windows\Temp...

hi nice article.

I have a issue which this looks like it may be about to solve. What I need to do in my lookup dataset though is group on...

ronan, Here is a demo package i put together - I've put some annotation notes inside the package.

It's all very basic, but will show you what you need to...

I'll try and create an example for you

yeah, you make a good point about how they may want a question answered.

Sounds like it's worth doing some reading then.

Thanks.

You would probably need to have the SQL task logging the error as an OnError event handler task at package level (or a suitable executable below that).

Hi ronan

I can see you problem now and probably why it's not been. Lear to others.

Your using a SQL task but have put in ssis expressions. They are very different...

Just to add to that, you will need to escape the singal quote, with a single quote.

e.g.

declare @statement varchar(100)

set @statement = 'select ''DAY NO.: '' + CAST(DATEPART(DAY,getdate()) AS VARCHAR(2))'

execUTE( @statement)

where...

Thanks Koen.

I don't think you can if its not already a shared data set. I think no what how you change it you would still be hitting every report in...

ok - so thats all under one data flow.

my data flow is slightly different. I have 1 OLE DB Source, but use mutli cast and splits the data to...

No probs - glad you got it working

stick a breakpoint on the WMI task and check the variable value pre wmi query execution and check the value is ok

Also on the wmi_conn connection manage review the...

Doh. 2008 is what I meant! 🙂

Thanks for the resource guide though and also the suggested solution for multiple files.

excellent and comprehensive article.

I only have a couple of questions..

first - if you where required to process multiple files per day, would you adapt this process, or would you use...