Hi all

Please find attached is a document that might be of help

Cheers

Vani

Hi Mark

Is that working for you now... Pls let me know if i do know then i will try and help you out

Cheers

Hi Mark

I am so sorry for belated reply. I had not checked my emails..

What I did was as follows -

Saved a copy of the package with the default security...

Hi

Not sure if this helps, but when I had to schedule the job earlier i had same errors but mine was related to the Encryption and security in the...

Hi all

I have it figured out and please find attached is the document if any one is interested for future

Cheers

Vani

[font="Comic Sans MS"]Hi Isha

Is that cell by cell import from a table in a database to Excel via ssis... If it is then you are able to use the SSIS...

Hi

Thanks for your reply. Yes So far I have checked that and got it to work till the bit of accepting all programs and providing information for all programs...

Hi

You might already know this but the one thing I recently learned is that we can do this by querying the Report Server Database that has pretty much all...

hi there

being a newbie to this myself - try doing it either one by one either using SSIS or Importing data from SQL SERVER in itself. or this can be...

Hi all

Its working now...

if any one needs it below is the code

select staffno, sum(camins), sum(cagrpmins) from Tablename groupby staffno

cheers

Vani

Hi

I recently had the same issue with query taking about 3 mins or so... I then decided to slice the query and put it into Temp Tables which made...

Hi

Can you please try putting nothing in the columns just do a standard export to excel and see what it does from there. i.e.

In the Excel Destination Editor...

Hi all

If any one needs it, here is the complete solution on how to export data into excel when the excel file format is specified.

Thanks

Vani

Hi All

I have figured out how to do this and its now working fine. In case if someone needs to know how to for future all I did...

Hi all

If any one is interested this is how I fixed my own while loop... It might not be the best way but it works out ... please find...