Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Flat file extraction error Expand / Collapse
Posted Tuesday, October 22, 2013 1:55 PM



Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 15,501, Visits: 13,163
rockstar283 (10/22/2013)
Data viewer on the Green pipeline is showing me all the records before that particular erroneous record

Sure? It might also show all the records loaded into the first buffer loaded when the error occurs.
SSIS doesn't load data row by row.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1507345
Posted Tuesday, October 22, 2013 2:22 PM


Group: General Forum Members
Last Login: Tuesday, April 12, 2016 5:59 PM
Points: 130, Visits: 669
ok..I tried almost everything..but the derived columns seems to be giving I have resorted to this:

I am creating a temp table..dumping the flat file as it is into it..and then using CONVERT in execute_sql task..I move the records over to the final destination table..
I agree that it is one more extra step and will take some extra time..but it is getting the job done for now
Post #1507363
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse