question

Victor 1 avatar image
Victor 1 asked

How to import a .dat file to Sql server 2000 DB.

i have a program that sends a .dat files to a location. and another program takes the files and processes them and send them back to the same file path.

I want to flag my database based on the response from the feedbacks i get....the feedback file header looks like this

1,5603145,B,1,437143,2,119.00,20100708,A,Batch Accepted

i want field to copy only the date field (20100708) and also flag a column in my table to 1 .

I will be glad if somebody can help me here thnaks.

standby-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.