Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 13,252, Visits: 10,135
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 LessThanDot.

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:00 PM
Points: 111, Visits: 501
ok..I tried almost everything..but the derived columns seems to be giving problem..so 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