*sql Help* Converting Dts Packages To Stored Procedures

[shivashankara]

Hi,

I have DTS packages and i need to convert those DTS packages to Stored Procedures in SQL Server 2008 R2.
Some one please help me...how to do this process.


DTS Packages ni Stored procedure lo convert cheyali in 2008 R2

[shivashankara]

ltt

[chelsea]

HELP

[ChampakDas]

I dont think we can convert DTS package to stored procedures automatically. I may be wrong. I dont know.
But i think you can do it manually by putting the logic in a proc.

[shivashankara]

[quote name='ChampakDas' timestamp='1344994430' post='1302311524']
I dont think we can convert DTS package to stored procedures automatically. I may be wrong. I dont know.
But i think you can do it manually by putting the logic in a proc.
[/quote]

Actual ga nenu online lo search chesina but exact process dorakaledu naku like steps wise
so, andukay ikada post chesina...avaraina process help chestaremoo ani

Automatic ga cheyalemu anav kada, mari manual ga ela cheyali bhayya?
do u know process?

[badboy7]

msdn lo adugu bhaya

[andrafun]

Dosthu direct ga ee process ledu convert cheyaniki.. nuvu dts packages lo step by step logic tesukoni own ga stored procedure rayali its not an automatic process....

[ChampakDas]

I never did and heard bhayya..
manual ga ante may be create a procedure and run the package in that procedure...

CREATE PROC
BEGIN
runyour package (because I know we can run the packages explicitly)
END

Just a thought. I am not sure if it works but try.

[quote name='shivashankara' timestamp='1344994635' post='1302311539']
Actual ga nenu online lo search chesina but exact process dorakaledu naku like steps wise
so, andukay ikada post chesina...avaraina process help chestaremoo ani

Automatic ga cheyalemu anav kada, mari manual ga ela cheyali bhayya?
do u know process?
[/quote]

[Silver_mani]

[qualityposter]

[quote name='shivashankara' timestamp='1344994635' post='1302311539']
Actual ga nenu online lo search chesina but exact process dorakaledu naku like steps wise
so, andukay ikada post chesina...avaraina process help chestaremoo ani

Automatic ga cheyalemu anav kada, mari manual ga ela cheyali bhayya?
do u know process?
[/quote]
ssis package lo unna code antha oka sp lo vey ,raw ga cheppalante.

Dataflow undanuko--Change into insert
Lookup component undhanuko---use joins in sp
execute sql task aithe just copy the chunks of code and paste it in sp

[ChampakDas]

As I said, you can manually copy the logic and put in a proc. If you are not comfortable in doing that you can call the dts package within the stored procedure as said in my previous post.

[qualityposter]

[quote name='ChampakDas' timestamp='1344995422' post='1302311614']
As I said, you can manually copy the logic and put in a proc. If you are not comfortable in doing that you can call the dts package within the stored procedure as said in my previous post.
[/quote]
agreed
dts to ssis ante conveters untay gani dts to ssis ante purely logic ni ardham chesukuni marchadame

[shivashankara]

[quote name='andrafun' timestamp='1344994895' post='1302311556']
Dosthu direct ga ee process ledu convert cheyaniki.. nuvu dts packages lo step by step logic tesukoni own ga stored procedure rayali its not an automatic process....
[/quote]

yaa andaru iday antunaru bhayya.
any way thanks for the reply.

[shivashankara]

[quote name='qualityposter' timestamp='1344995241' post='1302311596']
ssis package lo unna code antha oka sp lo vey ,raw ga cheppalante.

Dataflow undanuko--Change into insert
Lookup component undhanuko---use joins in sp
execute sql task aithe just copy the chunks of code and paste it in sp
[/quote]

naa code SSIS lo ledu bhayya
nadi DTS lo undi dani nenu SP lo ki covert cheyali.

[ChampakDas]