importing .dat file in SQL SERVER 2005

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

importing .dat file in SQL SERVER 2005

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-05 : 07:27:52

Ahmad writes "importing .dat file with varing columns in each row of file

Hi fellows ,
I am facing a problem in importing dat file. A .dat looks like below

"1","2","3","4","1"
"1","2","3","4","2"
"1","2","3","4","3"
"1","2","3","4","4"
"1","2","3","4","5"
"1","2","3","4"
"1","2","3","4","7"
"1","2","3","4"
Sql Server 2005 import wizard report a warning that there are some rows with less number of columns or with incomplete data rows. It also merges the row with less number of columns to previous one with full number of columns.

I never fond this error whenever i worked import wizard of Sql Server 2000.

Can any one can guide me to overcome on this problem."

nr
SQLTeam MVY

12543 Posts

Posted - 2006-12-05 : 07:57:12

I would bulk insert that into a single column table then manipulate from there.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources