Hi

I see the following, its a bit more involved and I dont know how its going to perform with my half a billion records but its worth a try

Old post but here is what I ran into and this is the answer to all the problems. I tried everything in this post and thought let me give one...

Also remember I have to automate this report via the SQL Server agent, Im not sure what sort of credential I should use there as well.

Many thanks

Many thanks, I'll look into this a little later during the week.

I've grown so accustomed to the fact thats on the file system that it didnt even occur to...

Something I totally forgot to add is that the SSIS packages are stored in a file directory on the server and not in the SQL Server SSIS instance. Maybe not...

Hi PB_BI

Thanks for the response, at least you have given me some real world suggestions that I can have a look at.

Im not sure how to check the start_execution...

Hi Thom A

You hit the nail right on the head. I personally use chrome as well to view the reports but it seems that the user has a outdated version...

Hi

The users can't actually enter the data, they are forced to select from either a calendar or from list which contains only the year month. For all other users its...

Thanks for sorting out...

Just a update, maybe someone will be able to help with this problem

I still get the following error from Job Agent :

Message

Executed as user: licloader. Microsoft (R) SQL Server Execute...

Hi

Yes, I did a rebuild of the scripts in this package as I had a few problems with some of the script taks in other packages. However the rebuild didn't...

Hi Mike, I just tried it and still...