Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-07 : 18:03:17
|
srinivasa writes "I have invoices raised every day in the text format. looks like this
To: GERMANY COMPANY
ADDRESS1
ADDRESS2
ADDRESS3
FROM: UK COMPANY INVOICE NUMBER: N10001
ADDRESS1 CREDIT NOTE
ADDRESS2 DATE:02/02/2001
ADDRESS3
---------------------------------------------------------
DATE DESCRIPTION QUANTITY UNIT PRICE VALUE USD VAT
---------------------------------------------------------
AJFJSDAALJDJF
ASDFKK'LFAKDK;LFKDAS;K;KSDKSKD
____________________________________________________
TOTAL = 7624366438
My task is to read tinvoice date , invoice num , invoice type, to whome it has been raised, total amount in to the daabase table and create dts package which can run every day as scheduled.
Can any one suggests how to read data from non uniform text files like this?" |
|
|
|
|
|
importing from text file