The reason for SSIS pacakge to track the status of the data insert and morover it's reliabled and you can track the log file if incase it's failure. The SSIS...

Always the compouted column addition takes N number of hours and utilize more transaction log file. As part of one table which had 2 billion records took 35 hours to...

I didnt setup any specific definitation as heap or clustered or fill factor of the index. The data type for persisted computed column is INT.

I will be posting the...

I am just adding the not null column and it was failed after 6 days

I didnt apply the start and end transaction when it was failed. But now in the latest script added the begin and commit transaction in between alter table.

Not sure...

Thanks for youe quick response.

The requirement to run the process from two servers and each server has multiple tables with different sets of data. But only one table may...

my server is having only .net frame work 1.1 and moreover i will not able to upgrade due to other application which is running on the server using .net frame...

thank you so much!!!