error 0xc0202055...while import data from csv file

I receiveed the error:

Error 0xc0202055: Data Flow Task: The column delimiter for column "Column x" was not found.

I would like to have the import continue., even the error occur. I have the error output to ignore, but doesn't seem to be working. Any suggestion on what to do next, or how to skip the row that create the problem.

thanks

We'll need a little more information - is the .csv file in a valid format? Does it have an inconsistent number of columns? If so, you should check out these posts - one for a workaround, the other for another workaround and some background info.

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/07/handling-flat-files-with-varying-numbers-of-columns.aspx

http://blogs.conchango.com/jamiethomson/archive/2007/05/15/SSIS_3A00_--Flat-File-Connection-Manager-issues.aspx

Error 0xC0047012 trying to import flat file in SSIS

I'm trying to do a simple flat file import of a .csv file. The task keeps failing on me and I get the following error

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039

I looked up the error codes and the only information I can find is that a thread is failing. What would cause this and how can I fix it? I can open the same file in Excel without any problems. I'd really appreciate any insight that anyone has to offer.

Does your package do anything else than importing the flat file?

Could you try nail down a piece of data in your file that is causing this? You can do it by splitting the file in two and keeping the failing part until you get the minimal amount of data causing this failure.

If your data is not sensitive I would like to do some testing with your file as well.

Thanks.

|||

Bob,

Thank you for the tip. I've been working on it all day and finally started coming to the same place you mentioned. I was finally able to get rid of the error by modifying the column data types in the Flat File connection.

Error - Analysis Services Processing Task

We have an Integration services package that executes a few TSQL tasks, then processes an Analsys Services database. This has been in production for about three weeks now and twice the package has failed with this error from the event log:

Event Type: Error

Event Source: MSSQLServerOLAPService

Event Category: (289)

Event ID: 3

Date: 7/11/2007

Time: 1:48:59 AM

User: N/A

Computer:

Description:

OLE DB error: OLE DB or ODBC error: An error has occurred while establishing a connection to the server.

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server

does not allow remote connections.; 08001;

Communication link failure; 08S01;

TCP Provider: An existing connection was forcibly closed by the remote host.

; 08S01.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I don't think that this error is accurate because the package and Analysis Services are on the same server.

Also, this does not happen in our development environment. Any help is appreciated.

Thanks,

Brian

Sorry to side track a bit, but processing cube using SSIS is not the most effiecent way of prcoessing a cube. Can't remember the specifics, but if you can I would get the sql agent to process the cube.

Cheers

Matt