Sorry it DTS Package

I will,

Thanks

hello,

The Rollback just stays at 0% and does not move at all, I beleive I am left with no option,

Please Advice,

Thanks,

Dev

Thanks Greg,

I will try that, another request,

Is there any way to transfer all the packages at 1 shot from one server to another,

Please Advice,

Thanks,

Dev

They are DTS Packages, they are stored on the server itself,

Thanks,

Dev

Thanks,

It is ATA, I think I should go for internal,

regards,

Dev

Hello,

I will upgrade the memory to 2GB,

but for the drive money is the issue, I am looking to spend somewhere around 400 dollors

Please Advice

hello,

actually I am sending the script here, if I am not wrong isn't the uesr ics\cnsuser here, and should be providing enough permission to this account, please advice,

'// sConnStringSQL =...

Yes ics\sqlsrvr is the SQL Sever Service account, it is account which is local admin too, and I have all the tasks with this account

job owner is ics\sqlsrvr, package is run by ics\rluu, can I change the name in package

Please advice,

thanks,

Dev

Hello,

I have the same user as the owner of the job, which is ICS\sqlsrvr,

Please Advice,

Thanks,

Devinder Sohal

Thanks Deepak,

regards,

Devinder Sohal

Thanks Guys I will try,

Dev

the detail error message is as,

Executed as user: ICS\sqlsrvr. ...n OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount...

It is DTS package