SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Flat File Source Problem.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tooba
Posting Yak Master

165 Posts

Posted - 04/07/2014 :  23:22:10  Show Profile  Reply with Quote
Hi,

Is any one have/had problem.
I have very simple SSIS Package. Flat file source and SQL Destination. No other transformation. Somehow I am missing few data from source. For E.g my flat file source has 987 rows, but I am getting in SQL Table 687 rows. I am not sure where I am missing those data. Is Anyone help would be great appreciate. Please let me know if my question is not clear or need more information.

Thank You,

SwePeso
Patron Saint of Lost Yaks

Sweden
30242 Posts

Posted - 04/08/2014 :  08:15:07  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Check field terminator and line terminator characters.
Does some fields have CR or LF within them?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

tooba111
Starting Member

USA
16 Posts

Posted - 04/08/2014 :  12:23:28  Show Profile  Reply with Quote
Thanks for the reply.
I just noticed my flat file data look like sample below

ID|FNAME|LNAME|CITY
1|Smith|Gram|Los Angles
2|James|Erik|
3|
4|

I am not sure, How I can fix this Issue.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30242 Posts

Posted - 04/08/2014 :  14:42:18  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You can put a conditional split and remove the empty rows.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

tooba111
Starting Member

USA
16 Posts

Posted - 04/08/2014 :  14:49:15  Show Profile  Reply with Quote
Yes I am using Conditional Split to remove Empty Row, but I am still not getting

ID|FNAME|LNAME|CITY
2|James|Erik|

and I can't use any filter on Flat File...
Go to Top of Page

subbu_mareedu
Starting Member

India
10 Posts

Posted - 04/16/2014 :  15:41:49  Show Profile  Reply with Quote
Hai tooba,

your data was came in the wrong format

because some columns was not separated pipe(|)symbol.

if u have any doubt u will try with this data.u get correct solution.

ID|FNAME|LNAME|CITY
1|Smith|Gram|Los Angles
2|James|Erik|
3|||
4|||








subbu
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000