****NEED SSIS JOB***********

[Ranga_The_Donga]

Need to export data in txt file to a specific folder....

Videos emaina vunte post cheyandii..............!!!! CITI#H@ CITI#H@ CITI#H@ CITI#H@

[Ranga_The_Donga]

sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[C Nation]

[url=http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/]http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/[/url]


video ledhu kaani. clear ga undhi content. hope it helps u

[Ranga_The_Donga]

[quote author=C Nation link=topic=202225.msg2466558#msg2466558 date=1307931209]
[url=http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/]http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/[/url]


video ledhu kaani. clear ga undhi content. hope it helps u
[/quote] thankyou thankyou thankyou earlier i gt this ba....

but video helps me alot........ S%Hi S%Hi S%Hi S%Hi S%Hi

[Ranga_The_Donga]

ltt...

[C Nation]

[quote author=INFATUATION link=topic=202225.msg2466574#msg2466574 date=1307931529]
thankyou thankyou thankyou earlier i gt this ba....

but video helps me alot........ S%Hi S%Hi S%Hi S%Hi S%Hi
[/quote]ilanti vaadiki videos vethakadam kastham baaa.
ssis from db to db videos easy ga dorukuthayi. nuvvu textfile adigav kada.
paina unna article lo clear ganey undhi kada step to step. edaina error vasthunda?  sCo_^Y sCo_^Y sCo_^Y

[Ranga_The_Donga]

[quote author=C Nation link=topic=202225.msg2466605#msg2466605 date=1307932662]
ilanti vaadiki videos vethakadam kastham baaa.
ssis from db to db videos easy ga dorukuthayi. nuvvu textfile adigav kada.
paina unna article lo clear ganey undhi kada step to step. edaina error vasthunda?  sCo_^Y sCo_^Y sCo_^Y
[/quote]

declaring file location variable.....

[C Nation]

[quote author=INFATUATION link=topic=202225.msg2466612#msg2466612 date=1307932891]
declaring file location variable.....
[/quote]static location kakunda, change avuthu untunda?

[Ranga_The_Donga]

[quote author=C Nation link=topic=202225.msg2466615#msg2466615 date=1307933021]
static location kakunda, change avuthu untunda?
[/quote]

ledu ba statis e......hw can i declare file location in a variable....!!!

[C Nation]

[quote author=INFATUATION link=topic=202225.msg2466628#msg2466628 date=1307933295]
ledu ba statis e......hw can i declare file location in a variable....!!!
[/quote]
variable lo enduku store chesukodam.
file connection manager lo ivvochu kada
[url=http://bi-polar23.blogspot.com/2008/02/dynamic-flat-file-destinations.html]http://bi-polar23.blogspot.com/2008/02/dynamic-flat-file-destinations.html[/url]
[url=http://lh6.ggpht.com/matthewmct/R7zmDwyub9I/AAAAAAAAATE/wWAGA9edbAc/05+-+Flat+File+Conenction+Expression%5B3%5D]http://lh6.ggpht.com/matthewmct/R7zmDwyub9I/AAAAAAAAATE/wWAGA9edbAc/05+-+Flat+File+Conenction+Expression%5B3%5D[/url]

[Ranga_The_Donga]

[quote author=C Nation link=topic=202225.msg2466640#msg2466640 date=1307933517]
variable lo enduku store chesukodam.
file connection manager lo ivvochu kada
[url=http://bi-polar23.blogspot.com/2008/02/dynamic-flat-file-destinations.html]http://bi-polar23.blogspot.com/2008/02/dynamic-flat-file-destinations.html[/url]
[url=http://lh6.ggpht.com/matthewmct/R7zmDwyub9I/AAAAAAAAATE/wWAGA9edbAc/05+-+Flat+File+Conenction+Expression%5B3%5D]http://lh6.ggpht.com/matthewmct/R7zmDwyub9I/AAAAAAAAATE/wWAGA9edbAc/05+-+Flat+File+Conenction+Expression%5B3%5D[/url]
[/quote]

flat file connection ante....input txt file isthamga.....

kani naku destination txt file kavali....

[C Nation]

[quote author=INFATUATION link=topic=202225.msg2466649#msg2466649 date=1307933857]
flat file connection ante....input txt file isthamga.....

kani naku destination txt file kavali....
[/quote]

ee article lo output text file baaa
[url=http://lh4.ggpht.com/matthewmct/R7zmZQyucLI/AAAAAAAAAU0/9lVAH-oTbJU/12+-+Data+Flow%5B3%5D]http://lh4.ggpht.com/matthewmct/R7zmZQyucLI/AAAAAAAAAU0/9lVAH-oTbJU/12+-+Data+Flow%5B3%5D[/url]

paina image choodu.

[Ranga_The_Donga]

[quote author=C Nation link=topic=202225.msg2466654#msg2466654 date=1307934158]
ee article lo output text file baaa
[url=http://lh4.ggpht.com/matthewmct/R7zmZQyucLI/AAAAAAAAAU0/9lVAH-oTbJU/12+-+Data+Flow%5B3%5D]http://lh4.ggpht.com/matthewmct/R7zmZQyucLI/AAAAAAAAAU0/9lVAH-oTbJU/12+-+Data+Flow%5B3%5D[/url]

paina image choodu.
[/quote]

gt u ba....open chesi choosthe gani ardham kala...

text file destination ga rakhamundhu......madhyalo...i need to edit SQL command nd get selected columns as result set..

so OLEDB source ki.....Flat file destination ki madhyalo...em container add cheyali....?  sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[C Nation]

[quote author=INFATUATION link=topic=202225.msg2466665#msg2466665 date=1307934516]
gt u ba....open chesi choosthe gani ardham kala...

text file destination ga rakhamundhu......madhyalo...i need to edit SQL command nd get selected columns as result set..

so OLEDB source ki.....Flat file destination ki madhyalo...em container add cheyali....?  sCo_^Y sCo_^Y sCo_^Y sCo_^Y
[/quote]
[url=http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/]http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/[/url]

ee article lo 3.2 Configuring the Destination in the Data Flow task: 
hope this helps u

[Ranga_The_Donga]

[quote author=C Nation link=topic=202225.msg2466670#msg2466670 date=1307934683]
[url=http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/]http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/[/url]

ee article lo 3.2 Configuring the Destination in the Data Flow task: 
hope this helps u
[/quote]

still it explains the same thing......OLEDB---->flat file...

nenu ekkado SQL execute task choosanu.....kani ah container tool box lo kanapadatam ledhuu.....