Text file import
From: nh (reply_at_thegroup.com)
Date: 11/30/04
- Next message: Reg Besseling: "Transfer DTS packages between servers"
- Previous message: Santosh: "R0625 Virtual Function call error when Creating dts Package using C#"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 10:42:39 -0000
I have a DTS package which imports thousands of text files into a database.
Because the number of columns varies significantly throughout each file, the
only way I can import them is to add a row of 50 or so commas into the
beginning of each file before importing.
With SQL 7.0 this was no problem as in the DTS package I could set it to
start the import at row 2 of each file. With the 'First Row' option on the
'Options' tab of 'Transform Data Task Properties'.
Since I have upgraded to 2000, whenever I set the first row to 2, I get a
message saying 'Make sure the last row is equal or greater than the first
row'
I don't want to set a 'last row' as it will vary...I just want it to start
at row 2 and keep going until it gets to the end of the file...
Is there a way around this?
Thanks
Nick
- Next message: Reg Besseling: "Transfer DTS packages between servers"
- Previous message: Santosh: "R0625 Virtual Function call error when Creating dts Package using C#"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
