PowerHouse QTP (extention .PSD) transfer in SQL

[nads260]

I want to transfer Data from PowerHouse (I create a text file, extention .PSD) to my SQL server. Is it possible to create a link server or a stored proc that will read this text file ???
Is someone can help me ???

 

[JamesLean]

You have several options for importing a text file into SQL Server:

- DTS
- BULK INSERT
- bcp

If it's a straight csv file and each field maps to a colum in your table then BULK INSERT is quickest and easiest. If you need to transform data/scrub it while importing then DTS is often easiest.

--James

 

[nads260]

Thanks for the answer.
I send you a exemple of my flat file... It's not a easy one I think

This is my Flat File:

20+050729RR F930128+930128


This is the difinition of the datas

Element COM-NO Character Size 2 &
Heading "# Cie"

Element CVT-NO Numeric Size 6&
Significance 6 &
Picture "^^^^^^" &
Heading "Commande"

Element CVT-TYPE Character Size 1 &
Heading "Cvt^Type"

Element CVT-NATURE Character Size 1 &
Heading "Nature"

Element CVT-BOOK Character Size 1 &
Heading "booking"

Element CVT-FP Character Size 1 &
Heading "Cvt^Fp"

Element CVT-EXPEDITEUR Character Size 20 &
Heading "Cvt Expediteur"

Element CFO-CODE Character Size 1 &
Heading "Cfo^Code"

Element CVT-DATE-PRIX Date Size 6 &
Separator "/" Format YYMMDD &
Heading "Date Prix"