I have the Row delimiter as (I have tried just CR or LF as well) Header rows to skip=0 (I have tried 1 as well since there is only one header row) and I have checked Column Names if the first data row.Ok thanks for the quick replyIt works and is a bit less cumbersum then what I had before.I've hit new snagsError: 0xC0047062 at Load IIS Logs, Script Component : .DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer. The last column is a date but I am designating as OutputColumnWidth of 50 and datatype as string. So on that file I edited to have no spaces on the final column. I have spaces in the header names of the origin file. The file itself has a total of 19 rows with the first being the header row. Make sure the header row delimiter and the number of header rows to skip are correct. The error message is only at warning level with the following message: ] Warning: The end of the data file was reached while reading header rows. On the Preview section it only shows the header columns in the flat file connection manager editor. I have a flatfile connection manager which picks up a text file. It connects to a SQL Database and I have checked to see that my connection has been tested. The SSIS package has a Data Flow task with Flat File Source, Data Source Row count, Final Data Set count and OleDb destination tasks. I am creating a SSIS package using MS Visual Studio 2012 Shell with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |