Calling Ssis Experts..!

[Darling999]

Nenu oka Flat file Load chestunna SQl Table ki, 2 fields unnayi

Field 1 | Field 2
12345 Name

Nenu table loki Load chesaaka '12345' ' 12345' ani vastundi. 2 spaces add avtunayi. Evarikainaa idea untey cehppandi very urgent/.

[Darling999]

ltt

[tom bhayya]

naaku ssis raadhu but trim function use chesaavaa?

[Doola]

google cheste idi dorikindi baa help ayyida emina


You have to create a flat file connection manager and point it to your .txt file.
Then follow my above post to set up it.
If you want to remove space from the column (the one with oz) then use Derived Column transformation and TRIM the column.
After that use any destination to dump the data.

------------------
[color=#000000]


This example removes leading and trailing spaces from a string literal. The return result is "New York".







TRIM(" New York ")

This example removes leading and trailing spaces from the result of concatenating the [b]FirstName[/b] and [b]LastName[/b] columns. The empty string between [b]FirstName [/b]and [b]LastName[/b] is not removed.







TRIM(FirstName + " "+ LastName)
[/color][color=#000000]

[url=""%20style="][color=#3F529C][size=1][b]See Also[/b][/size][/color][/url]

[b] Reference[/b]

[url="http://msdn.microsoft.com/en-us/library/ms141781.aspx"]LTRIM (SSIS Expression)[/url]
[url="http://msdn.microsoft.com/en-us/library/ms140025.aspx"]RTRIM (SSIS Expression)[/url][/color]

[Darling999]

[quote name='Alexander' timestamp='1352136644' post='1302746662']
naaku ssis raadhu but trim function use chesaavaa?
[/quote]
Flat File nunchi Pull CHesey appudu Trim ela chestaam??

[Darling999]

[quote name='Doola' timestamp='1352136875' post='1302746711']
google cheste idi dorikindi baa help ayyida emina


You have to create a flat file connection manager and point it to your .txt file.
Then follow my above post to set up it.
If you want to remove space from the column (the one with oz) then use Derived Column transformation and TRIM the column.
After that use any destination to dump the data.

------------------



[color=#000000]This example removes leading and trailing spaces from a string literal. The return result is "New York".







TRIM(" New York ")

This example removes leading and trailing spaces from the result of concatenating the [b]FirstName[/b] and [b]LastName[/b] columns. The empty string between [b]FirstName [/b]and [b]LastName[/b] is not removed.







TRIM(FirstName + " "+ LastName)[/color]


[color=#000000][color=#3F529C][size=1][b]See Also[/b][/size][/color]

[b] Reference[/b]

[url="http://msdn.microsoft.com/en-us/library/ms141781.aspx"]LTRIM (SSIS Expression)[/url]
[url="http://msdn.microsoft.com/en-us/library/ms140025.aspx"]RTRIM (SSIS Expression)[/url][/color]
[/quote]

idi Use chesinaa alaney vastundi danemma

[karna11]

calling mktr

[chelsea]

u can use Transformation derived column or copy column and use trim function in it

[techguru]

use RTRIM during the load or issue update after the load

[papacha]

konchem clear ga cheybuthara enduku edhi trim problem kaadhu

[Doola]

[quote name='DARLING...' timestamp='1352137921' post='1302746904']

idi Use chesinaa alaney vastundi danemma
[/quote]

aa column ni to_char ki maarchi rtrim function cheyyachu anukuntunaa.

[chelsea]

Derived transformation use cheyyi danilo expression lo R[font=Consolas, Menlo, Monaco,]TRIM[/font][background=transparent][font=Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, serif][color=#000000](column name[/color][/font][/background][font=Consolas, Menlo, Monaco,])or use Replace use cheyyi according to your Requirement [/font]

[mtkr]

LTRIM.....RTRIM.....

using derived column transformation

[mtkr]

[quote name='karna11' timestamp='1352138068' post='1302746934']
calling mktr
[/quote]

[mtkr]

[quote name='papacha' timestamp='1352138556' post='1302747017']
konchem clear ga cheybuthara enduku edhi trim problem kaadhu
[/quote]
like source vallu fixed length file pampisthunnaremooo.....