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 02, 2013 3:53 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 2:02 PM
Points: 109, Visits: 363
i had sent u an e-mail via private message..

shaun..
Post #1500950
Posted Wednesday, October 02, 2013 11:23 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:55 AM
Points: 571, Visits: 3,729
bad form. just post it.

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

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

Group: General Forum Members
Last Login: Monday, March 24, 2014 8:12 AM
Points: 117, Visits: 226
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 03, 2013 7:02 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 2:02 PM
Points: 109, Visits: 363
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 03, 2013 11:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:41 PM
Points: 12,201, Visits: 9,156
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 03, 2013 12:57 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 2:02 PM
Points: 109, Visits: 363
Thank you koen.. so muuch for helping me out...

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

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

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 2:02 PM
Points: 109, Visits: 363
thank you ishanan.

Regards
Shaun
Post #1501323
Posted Friday, October 04, 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 07, 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