Hi all

I got is sussed out... All i had to do was - change the title of the report slightly, re-deploy the report and it worked fine

Thanks

Hi all

Thanks for your help... I have figured it out...

Cheers

Vani

Hi all

Thanks for your help. I got it now and its working fine...

Thanks again

Cheers

Hi Jordan

I had to do this using a loop before - i.e. copy a file between a current folder to an archive folder and rename the file... I have documented...

Hi there

You could create a template excel wkbook and store it in a template folder... Each time before the package runs - copy the file over to the working folder...

sorry i guess i followed on with the post before...

Hi Deepthy

Just got your message... Glad to help...

Cheers

Vani

Hi

I had to do similar things recently and have documented the process... Please find attached are some docs that may be off help to you...

Cheers

vani

Hi Deepthy

I had to do a similar thing each time - I have used the following -

a For each loop container

Execute SQL task and

Variables

Please find attached is a...

Hi

What I usually do is change the package protection - Encrypt sensitive with password and provide a custom password...

then in the job when configuring the package - i enter...

Hi Melissa

Can you please check the protection level of the package... I had similar errors, will post a doc when i get to work which might help

Cheers

vani

Hi all

Thanks for the help... I will start working on this shortly... just a bit busy with other thing at the moment

thanks again

vani

Hi

I have changed the workings of this - in an attempt to improvise the whole query -

SELECT distinct staffno, s.items, identity(int, 1, 1) as Cnt

into TempStaffno

FROM Tablename cross...

We have a requirement of finding data that has been entered incorrectly into the database by staff members and sending an email to them every fortnight with an attachment indicating...

Hi all

Thanks for all your help in the Forum 🙂

I got it figured out and its working now... If any one needs it in case here is what i...