*sql Help* Converting Dts Packages To Stored Procedures

[kiraaaak]

[quote name='ChampakDas' timestamp='1345040191' post='1302313110']

[/quote]
emaindi ba atta kottavadthivi talayak ni

[shivashankara]

Enduku tala kotukuntunav bhayya
Nenu em aina tappu chepina?

[bongulocritic]

Bhayya, andaru cheptunnaru adey....open the dtsx package and copy the code and modify accordingly compatible to sproc code. Ddtsx package ela read cheyalo ethuku online lo bocchedul info dorukutundi

[ChampakDas]

antha chepintharuvatha kuda nuvu malla I need to convert dts package to sp antey kastam
only two ways..
1. motham logic copy chesi oka sp lo padeyi
2. oka sp rasi dantlo dts package nee call cheyi..

1st is more optimized.
[quote name='shivashankara' timestamp='1345041342' post='1302313221']
Enduku tala kotukuntunav bhayya
Nenu em aina tappu chepina?
[/quote]

[shivashankara]

[quote name='ChampakDas' timestamp='1345041988' post='1302313291']
antha chepintharuvatha kuda nuvu malla I need to convert dts package to sp antey kastam
only two ways..
1. motham logic copy chesi oka sp lo padeyi
2. oka sp rasi dantlo dts package nee call cheyi..

1st is more optimized.
[/quote]

Nenu rasina package lo challa tasks unnayi
Prati task ki oka SP rasina
Ipudu maa team pedda em antundu antay anni SP's ni oka SP lo rayamantundu.

[shivashankara]

Nenu rasina SP's correct ahaa kada ani avaraina check chestaraa?
Naku koncham doubt undi andukay adugutunna

[ChampakDas]

super..inkenti problem
[quote name='shivashankara' timestamp='1345043832' post='1302313544']
Nenu rasina package lo challa tasks unnayi
Prati task ki oka SP rasina
Ipudu maa team pedda em antundu antay anni SP's ni oka SP lo rayamantundu.
[/quote]

[ChampakDas]

structure ekada padeyi...if not me someone can comment
[quote name='shivashankara' timestamp='1345043870' post='1302313551']
Nenu rasina SP's correct ahaa kada ani avaraina check chestaraa?
Naku koncham doubt undi andukay adugutunna
[/quote]

[shivashankara]

[quote name='ChampakDas' timestamp='1345043965' post='1302313565']
super..inkenti problem
[/quote]
Individual ga rasina kani anni kalipi oka dantlo rayamantundu
Ela rayaloo telavadu
Single ga rayamantay ok but anni kalipi rayamantundu
Aday ela rayalaa ani chustunna

[cherlapalli_jailer]

[quote name='shivashankara' timestamp='1345044141' post='1302313586']
Individual ga rasina kani anni kalipi oka dantlo rayamantundu
Ela rayaloo telavadu
Single ga rayamantay ok but anni kalipi rayamantundu
Aday ela rayalaa ani chustunna
[/quote]


Post cheyyi maama

We will try our level best

Neenu Chaala Raasanu like that

From Oracle to SqlServer

Hope it may be useful

[shivashankara]

[quote name='cherlapalli_jailer' timestamp='1345044236' post='1302313594']



Post cheyyi maama

We will try our level best

Neenu Chaala Raasanu like that

From Oracle to SqlServer

Hope it may be useful
[/quote]

Bhayya mee mail id istaraa
Endukantay nenu mbile nunchi afdb access chestuna. So, nenu ikkada post cheyalenu
Mee mail id istay nenu frwd chesta....

[ChampakDas]

This is the basic structure

CREATE PROC SOMENAME
AS
BEGIN

EXECUTE PROC1 'your parameters go here'
example
EXECUTE PROC @parameter1 OUTPUT(if it has a return parameter)

EXECUTE PROC2

...so on

END

Hope this helps.
[quote name='shivashankara' timestamp='1345044141' post='1302313586']
Individual ga rasina kani anni kalipi oka dantlo rayamantundu
Ela rayaloo telavadu
Single ga rayamantay ok but anni kalipi rayamantundu
Aday ela rayalaa ani chustunna
[/quote]

[JUJUBI_JULABI]

[quote name='shivashankara' timestamp='1345039999' post='1302313101']
naa code SSIS lo ledu bhayya
nadi DTS lo undi dani nenu SP lo ki covert cheyali.
[/quote]
dude SSIS DTS edi unna first ade em chesthundo ardam chesko .. ade logic nuvvu convert cheyali into SP .. pina chepadu kada lookup = join ala anamata ... pm cheyy naku .. time unnapudu chustha

[cherlapalli_jailer]

Pl check ur PM Shivashankara

[cherlapalli_jailer]

[color=#282828][font=helvetica, arial, sans-serif]Pl check ur PM Shivashankara again[/font][/color]