|
|
|
|
wanttorun100
Member
|
|
|
Joined: 14 Feb 2005
Posts: 4946
Location: Just to the right of Atilla the Hun!
|
| Back to top
|
|
 Posted: 01/23/06 - 10:49 Post subject: SQL Server question
Is it true that SQL Server cann't import a fixed lenght ( aka Flat ) File?
I'm trying to provide several files to be used by a varierty of applications. If seems to me that a fixed lenght flat file is more or less the least common denominator and any application will be able to read the data in.
The SQL Servers guys tell me they cann't take a flat file. Should I raise the BS flag? I cann't believe a fine Microsloth products cann't read a flat file.
|
|
|
|
|
TriBob
Member
|
|
|
Joined: 29 Aug 2002
Posts: 5771
Location: Lost in Transition
|
| Back to top
|
|
Posted: 01/23/06 - 11:20 Post subject:
You can import a flat file.
DTSBulkInsertTask
This Microsoft® Visual Basic® sample demonstrates how to use Data Transformation Services (DTS) to perform a bulk insert operation from a flat text file. Bulk insert operations are possible from a wide range of OLE DB provider file types.
Default Location
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSBulkInsertTask
Running the Sample
Open the BulkInsertTask.vbp project.
Run the application.
This sample assumes that you have created the pubs2..authors table as a copy of the pubs..authors table.
|
|
|
|
|
j1miller
Puppy Love!
|
|
|
Joined: 07 Jul 2002
Posts: 15447
Location: Lost on trail.
|
| Back to top
|
|
Posted: 01/23/06 - 11:22 Post subject:
I feel MB's presence nearby...... 
|
|
|
|
|
wanttorun100
Member
|
|
|
Joined: 14 Feb 2005
Posts: 4946
Location: Just to the right of Atilla the Hun!
|
| Back to top
|
|
Posted: 01/23/06 - 11:57 Post subject:
HA! Where did I put the BS flag so I can run it up the pole!
|
|
|
|
|
MastrBrewr
Saccharomyces cerevisiae
|
|
|
Joined: 24 Sep 2003
Posts: 6974
Location: outside
|
| Back to top
|
|
Posted: 01/23/06 - 12:30 Post subject:
Sounds like someone wanted to avoid a little work. DTS can take care of it.
|
|
|
|
