Hi,

Can you check what error you are getting in sql error logs. Most probably your logshipping is failing because of below mentioned reasons:-

1. Network folder is not accessible from destination...

Try this

http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

Hi,

U can check the services 'MSSQLSERVER'. U can check the log on tab. If you have access to start the services... start it.

DJ 

You can implement Log shipping or Replication for Upto date Database. Pls. Check SQL Server Book Online for Log shipping and Replication.

Hi Everyone,

Thanks for your suggestiona...I have have no other option then inserting Data in Child Table first and then Parent. Otherwise, It may be a problem for Application.

What to do...

Thanks kenneth and Everyone for support.

No Phill....No Idea of that..

I am not very good in DTS... For as soon as i will create separete text file for each table... i may able to handle.

Pls. give me help for transfering into...

According to you,

1st i need to break down the Flat files into smaller-smaller tables. Then i need to execute separte-separate DTS to transfer the same into db.

Thanks

Yes Phill, I think u r right.. it will increase performance... but in that also you will read file ... you will generate insert statement like this

insert Table1 values('666','AAAA','08','03','k004','5300001702','FFFF','99991231','20040107','0000339130')

Here i...

Thanks Frank,

I have taken help from the website and changed my code like

Begin 

      select @statement1='insert ' + @Tablename + ' values('+@column+ ')'

      print '2nd'

      exec @m_err = sp_executesql...

Hi Phill,

Yes its related with same with few changes... The file is having around 50000 record or can be more than that. In few cases table column position is not matching from source...

Thanks Phillcart,

The error is as bellow.

Server: Msg 241, Level 16, State 1, Line 1

Syntax error converting datetime from character string.

But i want to Process all the Item in loop. I...

Hi Kenneth & PW,

Thanks for uor suggestion.

Kenneth,

I am not too much about 'semaphore-file'  and How to use this. Thanks if you can help me out. I was not thinking on...

Thanks Kenneth, Jonathan Stokes and PW.

Thanks for uor Valuable suggestion.... The problem here is i don't know when the File is going to arrive.... Because its totally different system (legacy system...