Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2014-04-07 : 23:22:10
|
| 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
30421 Posts |
Posted - 2014-04-08 : 08:15:07
|
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 |
 |
|
|
tooba111
Starting Member
22 Posts |
Posted - 2014-04-08 : 12:23:28
|
| Thanks for the reply. I just noticed my flat file data look like sample belowID|FNAME|LNAME|CITY1|Smith|Gram|Los Angles2|James|Erik|3|4|I am not sure, How I can fix this Issue. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-04-08 : 14:42:18
|
You can put a conditional split and remove the empty rows.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
tooba111
Starting Member
22 Posts |
Posted - 2014-04-08 : 14:49:15
|
| Yes I am using Conditional Split to remove Empty Row, but I am still not gettingID|FNAME|LNAME|CITY2|James|Erik|and I can't use any filter on Flat File... |
|
|
|
subbu_mareedu
Starting Member
11 Posts |
Posted - 2014-04-16 : 15:41:49
|
| Hai tooba,your data was came in the wrong formatbecause 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|CITY1|Smith|Gram|Los Angles2|James|Erik|3|||4||| subbu |
|
|
|
|
|
|
|
|
Flat File Source Problem.