So even though I am asking it to skip the header row, Bulk Insert still requires that the omitted row have the same number of delimiters? Interesting.

If you could find...

Thanks, Jason. That was just what I needed.

MarkC (10/30/2007)

---

with CTE1 as

(select EmpID, LocationID,

count(*) over(partition by EmpID,LocationID) as cn,

sum(Amount) over(partition by EmpID)...

We want to take a daily summary pf payments collected for each employee. Some employees take payments at multiple locations. When we do our summary (grouping) we need to have...

In the actual SP, the data is coming from a text file which I am importing into a temp table, doing some processing and inserting into the final table. Bad...

I ended up moving my error trapping out of the SP and into my calling application (MS Access). The ADO error object has a NativeError property that returns the SQL...

Unfortunately, I am using 2000. Try...Catch is not an option.