drari (8/6/2008)

---

what I do not understand is when I use an oledb drive to read the file in a datase

he gives a totalrows = 7

Maybe there is a way to...

Yep... And I looked at that file... it's just like I said... the header record and the trailer record both have a different number of columns than the body of...

Um... ok... a bit out of the ordinary...

Click on my name above my avatar to the left and send me an email with the file attached.

Folks, if I find something,...

From the description of things, it sounds like you have some code somewhere that makes tomorrow's database today... maybe, in more than one spot. I'm thinking that all you...

Only one thing left to do, then. Attach the create script for the target table, the BCP format file, and, if there's no private information in it, the file...

There are a huge number of rules for the partitioning column and the partitioned table in Books Online... my recommendation would be to make a checklist of what needs to...

The WHILE condition doesn't make sense for the code you posted... it will run forever because something will always exist in the table.

Also, you're trying to insert into the same...

Thanks for the feedback, Jim.

The header must have exactly the same delimiters as the 2nd row which must match all the other rows, or BCP will give you that error and the 2nd row...

Amit Chaudhary (8/5/2008)

---

Hello,

I think I am asking this question in the right forum.

THe configuration on my server is TCPIP Enabled, Named Pipes Enabled. The order of SQL Native CLient Protocols...

How many rows are you talking about copying? I'm thinking that you don't actually need the WHILE loop because of the explicit transaction you've declared. Use set based...

Gareth (7/31/2008)

---

I'm a complete newbie to table partitioning, so this question may be silly.

I was asked to investigate the possibility of table partitioning by a developer.

I used a 7 gig...

And, if you don't mind, tell us why it has to be a dynamic column name. 😉

Index... maybe a partitioned table, to boot.

Or... you can beat the crud out of a string anyway you like... 🙂 CREATE FUNCTION dbo.udf_Extract

/*******************************************************************************

Purpose:

========

Removes unwanted characters from a string.

Notes:

======

Possible inclusive values...