Thanks For Your Reply Gail,

My backup file is close to 500 GB so let me get that space on testing server, will let you know once done.

Thanks

Puneet

you can do it like the way i did in one of my SSIS,

1. Take Execute SQl task to excute your SP and put the data in two tables.

2. Take...

Do you need it in one excel or two excel file?

Hey,

i tried both the method but creating a table and inserting it seems a little better but still not an easy one as i am having a table with 15...

Thanks Alot for this,

can you please tell me a another way through which i can alter all this column as this will take hours to complete.

Yes i know all those column which needs to be converted to Not Null

Currently i m using a SP setwebtask to get the data in two files but i want it in one single file in two different tabs.

Need your expertise on this

Thanks...

It would be great help for me if you can guide me step to step to perform this task.