Lowell,

I forgot to mention that I tried running your version of my script (copied form your post) and got this error.

"Unkown argument on command line 'nul'"

Thank you for your reply Lowell.

I was trying to create a format file that I could later edit... to handle importing a CSV with bad records back into the...

Thanks for the input William.

The data in the CSV files looks Ok in Excel. However that was a great idea I had not considered. All the data being stuffed into...

Thanks for your reply yasub,

Yes, ANSI_WARNINGS are set to False on both SQL Server databases.

I am running the SQL import from the Access linked server via VB.NET CLR. Therefore Danny's...

@michael-2,

Thanks so much for the code syntax. It has saved me some time for sure. I have already incorporated it into the import and it seems to work...

Thanks for that information.

Where I have a problem is that I have customers that run SQL 2000 and SQL2005 and I need to include those dates in the older versions...

Here is the code for a stored procedure that I use to write to text files on disk. I "borrowed" the code from another forum post.

-----------------------

CREATE PROCEDURE PC_AppendToFile(@FileName varchar(255), @Text1...

Awesome! Thanks so much for that lead.

My import progam is a VB.NET console app that also has a User Interface component option should a human decide to run it manually...

Thanks Phil,

Yes I can see how changing the column delimiter would indeed be the easiest solution. I suppose if Excel, Access and SQL 2000 DTS can handle that, there must...

Thank you for your response. The data supplier and the data supplied is the same supplier and data that I have been using for 4 years. They are changing the...

Well it looks like I am answering my own question. Even SSIS in SQL Server 2008 with SP1 is just not capable of a simple import from a CSV file,...

Well I see that I am not the only one with this problem. It seems that the Flat File import has problems with commas imbedded into a text field delimited...

Thanks Eliot,

Yes I see that now.

I guess it now comes down to tracking the reason for the error:

"Variable User::xmlRecords does not contain a valid object."

I think that object was supposed...

Excellent article. I liked it so much I just ordered your not-yet published book. You have demonstrated a rare but important trait in technical writing...the ability to express technical concepts...

Thanks to both Joe and Billy. We are currently trying to optimize a fairly large production DB, and adding clustered indexes is part of the plan. The database gets steady...