ragged right file data not coming correctly

Question

ragged right file data not coming correctly

coool_sweet

SSCommitted

Points: 1892
More actions
April 8, 2015 at 6:21 am

#302831

hi
i have flat file where all data coming correctly except some 2.
where to look into ssis package

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply

PB_BI SSCoach Points: 17463 More actions · Answer 1

Very informative thread there. I'd say you probably need to look at your flat file connection manager to see what's going on. As for any specific errors, you don't mention any so it's hard to tell. Good luck.

I'm on LinkedIn

ManicStar SSCoach Points: 17992 More actions · Answer 2

Inside of it. Based on what you gave us, that's the best I can do right now.

coool_sweet SSCommitted Points: 1892 More actions · Answer 3

i am not able to paste screen shot here.

here is example of my file

1 krut galaxy

2 rtgh erfg

3 rfgg efgh

here , 2 and 3 records should be in line of records 1, 1 space is coming ahead.

i see my flat file connection manager ,

for record 2 and 3 , in column section, rtgh and erfg coming together. for record 1 , krut then there is line

and then galaxy.

but for all other records its coming correctly

coool_sweet SSCommitted Points: 1892 More actions · Answer 4

coool_sweet

SSCommitted

Points: 1892

April 8, 2015 at 11:05 am

#1789624

PB_BI SSCoach Points: 17463 More actions · Answer 5

Seems as if you probably have the row and column delimiters set incorrectly for that file. Have a look at the file in a text editor that allows you to see the invisible characters and verify that you have the correct settings in the flat file connection manager.

I'm on LinkedIn

ManicStar SSCoach Points: 17992 More actions · Answer 6

When you 'preview' from the datasource, does it look correct? If not, do you have embedded carriage returns or some other control chars in the source that might be causing a line split where you are not expecting it?

coool_sweet SSCommitted Points: 1892 More actions · Answer 7

but its coming correctly for all the records except 2.

my stored proc return it correctly

PB_BI SSCoach Points: 17463 More actions · Answer 8

coool_sweet (4/8/2015)
but its coming correctly for all the records except 2.
my stored proc return it correctly

Before simply dismissing what has been suggested, at least try it out. What's so difficult about opening up a text file and examining it for carriage returns, tabs etc.???

I'm on LinkedIn

ManicStar SSCoach Points: 17992 More actions · Answer 9

look at your source file in notepad++ or its ilk and turn on visible control characters.

coool_sweet SSCommitted Points: 1892 More actions · Answer 10

ok

i did see my file in notepad++.

for the correct records there is LF at the end of last column.

for the record which are not coming properly they have LF in middle and also at the end of the last column.

i think LF should not come in the middle ,it should only come at the end of the last record.

how to remove it from ssis/stored proc?

coool_sweet SSCommitted Points: 1892 More actions · Answer 11

even if i remove LF from the middle its not coming correctly.

a bv 0923 e

b dfg 0456 e

c efg 3456 e

here b and c are not coming in proper way

ManicStar SSCoach Points: 17992 More actions · Answer 12

If the source file is bad, make whoever sent it to you fix it.

coool_sweet SSCommitted Points: 1892 More actions · Answer 13

there is no source file

my data is coming from stored proc and i am creating flat file

ManicStar SSCoach Points: 17992 More actions · Answer 14

Well you know where the problem is then. If its your code creating the file and you haven't accounted for malformed rows due to embedded control data, then fix that code, which will fix your file and your import package will work then.