thanks. that worked!!!

There is no error while running kill @spid

i get this

it returns this

SPID 124: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.

But the process is...

getting Error:

 Source: CDO.Message.1

 Description: The transport failed to connect to the server.

I tried but did not work!!

the previous was the Full restore from back up!!

thanks

is it be possible to save it as different name than the file sucha as test_tlog_200605241600.trn

Can i save it as test_log.trn insteade test_tlog_200605241600.trn!!

if then how?

yeah that is true but how can i make it automated for job:

because the log file i want to copy has the format like

test_tlog_200605241600.trn and then next one like test_tlog_200605241630.trn

no the table namce changes in excel file. I mean the sheet name from test to test1130 and dts looks for test and it fails until i set it to...

how about,

coping the file on the name like filename+date!! before overwrite it!!

how can i do that!!

Thanks

does it save it as a task because the package will run everynight! so i want to drop table in excel file first and then recreate it.! what could be...

how can i drop in excel!

thanks

here is the data from the table

000 000000000000000000 0000000 00 1004319 10/25/2005 02 1004319    

102 100431900103200083 0000001 01   121 RUCKS DRIVE     ANGLETON TX 77515  1004319 1000467

102 100431900103200083 0000002 02...

i got that in to one column but how can i query. The info in the table is customer information and i need to query their address and ssn!!

Thanks

what is IFCR how can i do that

thanks

i have the text file but it too big to modify. I even try taking in to different table and then parse it.

thanks