Ssis Help

[Ranga_The_Donga]

Flat file destination lo

text file generate chesinappudu... text file lo extra column shd be added and no.'s shd be auto generated...


ela cheyochu???

[LoveGuru]

[quote name='Jeedeelu' timestamp='1336776049' post='1301781067']
Flat file destination lo

text file generate chesinappudu... text file lo extra column shd be added and [b]no.'s shd be auto generated[/b]...


ela cheyochu???
[/quote]

idhi koncham elaborate chey,extra column ki aithe derived column transformation vadtharu

[erragulabi]

[quote name='Jeedeelu' timestamp='1336776049' post='1301781067']
Flat file destination lo

text file generate chesinappudu... text file lo extra column shd be added and no.'s shd be auto generated...


ela cheyochu???
[/quote]

ardam kaale dude...........malli koncham detailed ga cheppu............

sql table to flat file destination aaa generating aa

[Ranga_The_Donga]

sql table to flat file destination....as .txt file..

am exporting two columns... to output file

but naku output file lo inko col kavali..and tht col shd have row numbers like 1 2 3 4 5 6

[lolliguru]

case 1. define column as Recordcount, properties lo column mapping chesedappudu dnt map it to destination column..oka cinna c# script or expression rayochu for auto generation
basedon what u told and can picturre
if u r loading into a destination table
case 2:u need not define any column in source..destination table lo ne oka identity column define cheyyi if its not there .when u load data automatic ga record count peruguddi like u want

[Ranga_The_Donga]

[quote name='lolliguru' timestamp='1336778161' post='1301781241']
case 1. define column as Recordcount, properties lo column mapping chesedappudu dnt map it to destination column..oka cinna c# script or expression rayochu for auto generation
basedon what u told and can picturre
if u r loading into a destination table
case 2:u need not define any column in source..destination table lo ne oka identity column define cheyyi if its not there .when u load data automatic ga record count peruguddi like u want
[/quote]


case 2 kadhu nadhi....


case 1 cheyochu..... is there any other method to do without using script component...

[LoveGuru]

[quote name='Jeedeelu' timestamp='1336776932' post='1301781124']
sql table to flat file destination....as .txt file..

am exporting two columns... to output file

but naku output file lo inko col kavali..and tht col shd have row numbers like 1 2 3 4 5 6
[/quote]

derived column transformation lo row_number() use chesi dynamic ga row number create chey