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 not moving all data Expand / Collapse
Author
Message
Posted Wednesday, October 2, 2013 3:53 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:45 AM
Points: 134, Visits: 419
i had sent u an e-mail via private message..

shaun..
Post #1500950
Posted Wednesday, October 2, 2013 11:23 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:29 PM
Points: 811, Visits: 5,155
bad form. just post it.

the more eyes on your problem, the faster you get an answer.
Post #1500986
Posted Thursday, October 3, 2013 5:48 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, September 25, 2014 5:42 AM
Points: 136, Visits: 252
I've run into this when there is an extra CR/LF at the end of the file: In other words, your last actual line of data has a CR/LF and there is another CR/LF immediately following.

I've never had to do this, but I've read others have corrected the problem by setting the TextQualified property of the flat file connection manager to false or adding a text qualifier somewhere in the data. See here and here.

There's also a known bug when using fixed-width flat files although that applies to SSIS 2005.


____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Post #1501134
Posted Thursday, October 3, 2013 7:02 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:45 AM
Points: 134, Visits: 419
I am getting all the data, in my text qualifier i had "_x003C_none_x003E_" which i removed it but can anyone tell what does do..in the text quliafier
"_x003C_none_x003E_".

regards
Shaun
Post #1501168
Posted Thursday, October 3, 2013 11:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Shaun2012 (10/3/2013)
I am getting all the data, in my text qualifier i had "_x003C_none_x003E_" which i removed it but can anyone tell what does do..in the text quliafier
"_x003C_none_x003E_".

regards
Shaun


For some reason SSIS puts _x003C_none_x003E_ instead of <none>.

More information.




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 #1501294
Posted Thursday, October 3, 2013 12:57 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:45 AM
Points: 134, Visits: 419
Thank you koen.. so muuch for helping me out...

regards
Shaun
Post #1501322
Posted Thursday, October 3, 2013 12:59 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:45 AM
Points: 134, Visits: 419
thank you ishanan.

Regards
Shaun
Post #1501323
Posted Friday, October 4, 2013 4:43 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 7, 2014 11:41 AM
Points: 703, Visits: 4,519
ah, yes. The first time I encountered the hex encoded delimiters it drove me NUTS!! I guess it has something to do with the way the dtsx file is stored - I think it's actually XML. Anyway, I've seen it a couple of times since usually when adding a package to a project. It also converts the double-quote to _x022_ if I remember correctly.
Post #1501786
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse