Thank you Koen.

Absolutely logical!!!

But my next thought is, no ordinary user can work with the MS-ACCESS database. its a locked down environment and only the user account has full...

The package is called using a parameterized stored procedure which will execute the DTEXEC utility via XP_CMDSHELL

Note: The user account has full privileges (SYSADMIN) on the PROD server. So permission...

Yes, i use the same dtsconfig file, referred through package configuration option in SSIS menu

Correct. it works fine when open the same package through BIDS.

Hi

Thanks for the reply.

But i think that would not be possible as the database will be constantly referred by other processes during the month. The fact that makes me...

It takes more than 2 hours. I have let the query run completely. I cancelled the query once it crossed the 2 hour duration.

Could you please suggest what I should be doing??

Is SSIS the only way to proceed futher??

Thanks for your suggestion..

But I am focussed on implementing SQLCLR solution rather trying to do this task using SSIS. Could you provide any thoughts on how to implement using the...

Thanks for the reply...

But the requirement wants the solution to be implemented through execution of stored procedure only. And executing a extended stored procedure will enhance the usability in my...

Thanks for the prompt reply...

But i have a question arising from this solution, that is,

going by the logic u have explained, wouldn't the query fetch records having only rollup =...