Importing Delimited file into sql 2005 table

Question

Importing Delimited file into sql 2005 table

vkres1

SSC Enthusiast

Points: 147
More actions
January 12, 2009 at 12:16 pm

#126599

Hi,
I am trying to import the delimited file into one of the table and i am trying to create a package using BI. when i select the file and assign the properties i am getting the message
"the last row in the sampled data is incomplete the column or the row delimiter may be missing or the text is qualified incorrectly"
any body come across this issue? can some one help on this please
Thx

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

It means there is something wrong with the last row of data in the file. Generally, in a text file, it means it needs a hard-return at the end of the last row (go to the end of the file and hit Enter).

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

vkres1 SSC Enthusiast Points: 147 More actions · Answer 2

Hi,

I tried hitting enter at the end and now i am gettting differnt error

" You do not have permission to use the bulk load statement"

I am the local admin on that server. Any idea? appreciate your help

Thx

GSquared SSC Guru Points: 260824 More actions · Answer 3

You might need to be listed as a sys_admin in SQL security. I don't remember.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

vkres1 SSC Enthusiast Points: 147 More actions · Answer 4

Hi,

When i use the delimited file to export into the table, it is not seperating all the columns by semicolon. it is seperating only first 10 columns and rest of the data it is putting in 13th column. Any idea?

Thx

GSquared SSC Guru Points: 260824 More actions · Answer 5

Tell it to refresh the column list.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

vkres1 SSC Enthusiast Points: 147 More actions · Answer 6

Hi,

when i refresh the colum i am getting the same message again.

"the last row in the sampled data is incomplete the column or the row delimiter may be missing or the text is qualified incorrectly"

any idea?

Thx

GSquared SSC Guru Points: 260824 More actions · Answer 7

I'm going to guess that the file you're trying to import has something wrong with it.

I've seen that kind of error in files where the delimiter was used within the text of one (or more) of the columns.

I've seen it in files where part of the file had more columns than another part of the file.

I've seen it in files where rows weren't properly delimited.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

vkres1 SSC Enthusiast Points: 147 More actions · Answer 8

the same file works perfectly with Sql Server2000. we want to migrate all the dts to sql 2005 and it is giving me lot of issues and ofcourse we are new to this one. i tried migrating the sql 2000 to sql 2005 using the BI still the same issue

GSquared SSC Guru Points: 260824 More actions · Answer 9

Not sure what to suggest you look at next. There's probably something that would be obvious if I were looking at your screen, but I can't think of what it could be.

Would it be possible to provide a table definition for the table you're importing into, and a few sample rows of data from the import file? (You could annonymize the data, of course.)

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

vkres1 SSC Enthusiast Points: 147 More actions · Answer 10

I did migraed the dts package from sql server2000 now it is created as test1.dtsx in Business development visual studio. my question is how to call this package from the ASP.NET ? any idea

Thx