Jump to content

calling musugu_veerudu & others [SQL doubt]

charygaru

By charygaru
in Old Discussions

 Share

Recommended Posts

Nenunnanu Jr Artist

Nenunnanu

Posted
Posted

Boss!!! Stay cool .....In columns tab try changing the column delimiter......Make sure you are in the ragged right mode..but i don't think you are in
Ragged right mode because the column delimiter should be disabled in ragged right mode... but i see it is enabled in your case.


R u with Fannie Mae?

  • Replies 70
  • Created
  • Last Reply

Top Posters In This Topic

  • charygaru

    26

  • tom bhayya

    13

  • Nenunnanu

    5

  • Herndon- VA

    5

Popular Days

Top Posters In This Topic

Popular Days

charygaru LEGEND

charygaru

Posted
  • Author
Posted

[quote author=tom bhayya link=topic=217792.msg2681225#msg2681225 date=1311917065]
[url=http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/33d5a763-f6c2-4ca6-80c6-ffd4c44c38ad]http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/33d5a763-f6c2-4ca6-80c6-ffd4c44c38ad[/url]
[/quote]

Yes, simply typing the space as column delimiter should work. [size=2em]Make sure, though, that all columns are separated with a single space.[/size] Multiple spaces would generate multiple columns.


sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il

tom bhayya VIP

tom bhayya

Posted
Posted

[quote author=charygaru link=topic=217792.msg2681252#msg2681252 date=1311917333]
Yes, simply typing the space as column delimiter should work. [size=2em]Make sure, though, that all columns are separated with a single space.[/size] Multiple spaces would generate multiple columns.


sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il
[/quote]
1. Take one Dataflow Task Control from ToolBox.

  2. Inside Dataflow Task take FlatFile Source control and select your file as input file.

  3. Then use the REPLACE() function inside a Derived Column after FlatFile Source component to replace spaces with nothing.
      Use this expression inside expression builder of Derived Column. DataType should be String(DT_STR) and length 255.

  REPLACE([column_name], " ", "")

tom bhayya VIP

tom bhayya

Posted
Posted

[quote author=tom bhayya link=topic=217792.msg2681259#msg2681259 date=1311917452]
1. Take one Dataflow Task Control from ToolBox.

  2. Inside Dataflow Task take FlatFile Source control and select your file as input file.

  3. Then use the REPLACE() function inside a Derived Column after FlatFile Source component to [b]replace spaces with colon[/b].
      Use this expression inside expression builder of Derived Column. DataType should be String(DT_STR) and length 255.

  REPLACE([column_name], " ", "")
[/quote]
do this if you have columns with more than one space.

charygaru LEGEND

charygaru

Posted
  • Author
Posted

[quote author=Nenunnanu link=topic=217792.msg2681246#msg2681246 date=1311917240]
Boss!!! Stay cool .....In columns tab try changing the column delimiter......Make sure you are in the ragged right mode..but i don't think you are in
Ragged right mode because the column delimiter should be disabled in ragged right mode... but i see it is enabled in your case.


R u with Fannie Mae?
[/quote]

i tried ragged right and looked like everything fell in place and everything was fine. i went into columns tab and created 282 colums each one for the 282 exixiting columsn in the exisiting table!! but then when i was drawing the lines or in this case arraning the columns i was dumbstruck when i had to draw a column in between the data thats when i came to know something is stil going wrong.
no i am not with fannie mae i am with state of maryland

charygaru LEGEND

charygaru

Posted
  • Author
Posted

[quote author=tom bhayya link=topic=217792.msg2681259#msg2681259 date=1311917452]
1. Take one Dataflow Task Control from ToolBox.

  2. Inside Dataflow Task take FlatFile Source control and select your file as input file.

  3. Then use the REPLACE() function inside a Derived Column after FlatFile Source component to replace spaces with nothing.
      Use this expression inside expression builder of Derived Column. DataType should be String(DT_STR) and length 255.

  REPLACE([column_name], " ", "")
[/quote]

[img]http://i52.tinypic.com/fao18m.jpg[/img]

Nenunnanu Jr Artist

Nenunnanu

Posted
Posted

Yeah you did it right but what i feel is if the file was loaded in Fixed width format then while reading in ragged right format then it should arrange itself.In your case it is not so the file may be corrupt.Try using word Pad/Text pad to open the file and visually confirm before escalating the issue.

charygaru LEGEND

charygaru

Posted
  • Author
Posted

[quote author=Nenunnanu link=topic=217792.msg2681277#msg2681277 date=1311917898]
Yeah you did it right but what i feel is if the file was loaded in Fixed width format then while reading in ragged right format then it should arrange itself.In your case it is not so the file may be corrupt.T ry using word Pad/Text pad to open the file and visually confirm before escalatin g the issue.
[/quote]

fixed length is close to 2000 character s so it is highly impossibl e for me to check visually and do somethign about it i guess like you said the file must be corrupt , thanks for the inputs brother PM me your details  H&*() H&*() H&*()

tom bhayya VIP

tom bhayya

Posted
Posted

[quote author=charygaru link=topic=217792.msg2681273#msg2681273 date=1311917782]
[img]http://i52.tinypic.com/fao18m.jpg[/img]
[/quote]
enti chary garu manam SSIS asalu idea ledhaa?[img width=96 height=96]http://www.desigifs.com/sites/default/files/imagecache/144x144/bemmi.sarle_.gif[/img]

charygaru LEGEND

charygaru

Posted
  • Author
Posted

[quote author=tom bhayya link=topic=217792.msg2681283#msg2681283 date=1311918135]
enti chary garu manam SSIS asalu idea ledhaa?[img]http://www.desigifs.com/sites/default/files/imagecache/144x144/bemmi.sarle_.gif[/img]
[/quote]

nuvvu SSIS daaka poyinava mama nenu edo import export wizard toh pani kaanichhedam anukuntunte

tom bhayya VIP

tom bhayya

Posted
Posted

[quote author=charygaru link=topic=217792.msg2681286#msg2681286 date=1311918310]
nuvvu SSIS daaka poyinava mama nenu edo import export wizard toh pani kaanichhedam anukuntunte
[/quote]
SSIS mee file ni baagu cheyadaaniki.. if it has multiple spaces..

charygaru LEGEND

charygaru

Posted
  • Author
Posted



[quote author=tom bhayya link=topic=217792.msg2681288#msg2681288 date=1311918407]
SSIS mee file ni baagu cheyadaan iki.. if it has multiple spaces..
[/quote]

neku naa file sample chupistha aagu mama


150100001 2        82NJOHNSO N DANA L                                                      JOHNSON DANA L          13870 MASSEY RD                                            GALENA                MD2163519 21    LOT 0.73 AC        32920 MARYLAND LINE ROADE OF MASSEY            32920  MARYLAND LINE        RD  MASSEY                216500000      EHP001650 300            0000000                  0024 0001D0027            C          0        000008012 0000020 0010    005900000 000840370 TERRY, VICTOR JOE                EHP001360 006            1 062919840 00019000 000000000      000000000 000000000              820272A T G CORPORATI ON                    000000000            1 062419820 00015000 000000000      000000000 000000000              000000                                    000000000            0 000000000 00000000 000000000      000000000 000000000              000000000 000.00000 000000000 0.0000000 00000000. 000000000 000.00000 0000000.0 000000000 00.000000 066000000 019300000 000000000 000000092 008092008 150400011 890000000 000000000 000000011 950000001 620000000 000000000 000009200 809200815 040001357 000001357 000000000 000000000 000000000 000000000 000000000 000000000 000000000 000000000 00                          000000000 000000000 000000000 000000000  0000                                        000000000 000000000 000000000 00000000 000000000 000000000 000000000 000000000 000000000 000000000  000000000 000000000 000000000  000000000 000000000 000000000 000000000 000000000 00.00 000000000 000000000 000000000 000000000 0000.00 000000000 0000000  000000000 0000000        000000000 0000000      0  000000001 00000 000000000 000000031 799.000S0 0000.0000 000.00201 100013570 000013570 000000000 000000000 000000000 000000000 00000.000 000.00000 0.00R0713 20




i am not sure if this is one column data or more than one column data  !q# !q# !q# !q#
geeni83 Hero

geeni83

Posted
Posted

[quote author=charygaru link=topic=217792.msg2681295#msg2681295 date=1311918662]


neku naa file sample chupistha aagu mama


150100001 2        82NJOHNSO N DANA L                                                      JOHNSON DANA L          13870 MASSEY RD                                            GALENA                MD2163519 21    LOT 0.73 AC        32920 MARYLAND LINE ROADE OF MASSEY            32920  MARYLAND LINE        RD  MASSEY                216500000      EHP001650 300            0000000                  0024 0001D0027            C          0        000008012 0000020 0010    005900000 000840370 TERRY, VICTOR JOE                EHP001360 006            1 062919840 00019000 000000000      000000000 000000000              820272A T G CORPORATI ON                    000000000            1 062419820 00015000 000000000      000000000 000000000              000000                                    000000000            0 000000000 00000000 000000000      000000000 000000000              000000000 000.00000 000000000 0.0000000 00000000. 000000000 000.00000 0000000.0 000000000 00.000000 066000000 019300000 000000000 000000092 008092008 150400011 890000000 000000000 000000011 950000001 620000000 000000000 000009200 809200815 040001357 000001357 000000000 000000000 000000000 000000000 000000000 000000000 000000000 000000000 00                          000000000 000000000 000000000 000000000  0000                                        000000000 000000000 000000000 00000000 000000000 000000000 000000000 000000000 000000000 000000000  000000000 000000000 000000000  000000000 000000000 000000000 000000000 000000000 00.00 000000000 000000000 000000000 000000000 0000.00 000000000 0000000  000000000 0000000        000000000 0000000      0  000000001 00000 000000000 000000031 799.000S0 0000.0000 000.00201 100013570 000013570 000000000 000000000 000000000 000000000 00000.000 000.00000 0.00R0713 20




i am not sure if this is one column data or more than one column data  !q# !q# !q# !q#
[/quote]

chary baa ela unnav baa...

charygaru LEGEND

charygaru

Posted
  • Author
Posted

[quote author=JAINTR link=topic=217792.msg2681298#msg2681298 date=1311918815]
chary baa ela unnav baa...
[/quote]

darling loooooooong time wass up !!! igo chsinav kada naa badha itla unna wazz up with u ??

tom bhayya VIP

tom bhayya

Posted
Posted

adhey chary garu mee file delimiter space aa file anthey vuntundhi.. 2005 import tool lo delimiter space ledhu antunnaru kabatti.... so meeru nenu cheppinattu proceed ayipondi..
1. Take one Dataflow Task Control from ToolBox.

  2. Inside Dataflow Task take FlatFile Source control and select your file as input file. use FlatFile Destination as  'Fixed width with row delimiters' instead of 'Fixed width' option.

  3. Then use the REPLACE() function inside a Derived Column after FlatFile Source component to replace spaces with colon.
      Use this expression inside expression builder of Derived Column. DataType should be String(DT_STR) and length 255.

  REPLACE([column_name], " ", "")


adhi chesthey u will get a new text file with delimiter colon.. so now you can easily import using import/export wizard..

 Share
Go to topic listing
×
×
  • Create New...