Printable View
I have a text file that I'd like to import into a SQL 2005 table. The file is tab delimited, which is easy enough to import, but I'd like the final field broken into multiple fields as well. The final field is space delimited. I've had no luck at being able to get this done. Has anyone done this?
How do you import the text file (DTS/SSIS, Procedure, Linked server...) ???
SSIS is the current method, but I'm open to suggestions.
I am also importing a tab-delimited file with space-delimited values that have to be parsed and inserted into separate tables.
Any suggestions on how to best do this will make me happy.
I am not terribly familiar with the parsing abilities in the new DTS in SQL Server 2005 and am using C# to achieve this...but it is too slooooow. File sizes are up to 200Mb and contain one record per line that has to be parsed and inserted/updated properly.
Thanks!
Possible to use same delimiter in data file?
Not in my case. I'm parsing a syslog. The workaround that I'm going to try is logging directly to a SQL database, querying the column that contains the space delimited text, and then inserting the results into columns in a new table.Quote:
Originally Posted by rmiao