Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Call DTS using parameter inStored Procedure

Author  Topic 

yyogesh
Starting Member

5 Posts

Posted - 2014-07-18 : 07:32:47
I have created a DTS package which stores file data into Database table.
I want to pass file name dynamically to stored procedue from which DTS retrive data and store it in table.


Request all to help with proper guidance.

Regards,

Yogesh

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-18 : 09:15:58
See here: http://www.codeproject.com/Articles/27156/How-to-Call-SSIS-Package-from-the-Stored-Procedure
Go to Top of Page

yyogesh
Starting Member

5 Posts

Posted - 2014-07-22 : 03:06:57
Thanks gbritton..

We are using MS SQL server 2000, in which we have explored calling dtsrun.exe from Runtime class in java.
But it is not suggested way to call dts, as error handling will be difficult.

I guess DTS can be called in VB using DTS.package, through which error handling is easy.
In similar ways, does Microsoft provide any java api which can call dts?

Thanks & regards,
Yogesh
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-22 : 07:59:13
Huh? You asked about calling a DTS from a stored proc. The reference I listed shows you how. 'xp_cmdshell' exists in Sql Server 2000. However, if you want to know about Java APIs, you'll need to post the question in a Java forum. I did find this article on my first try: https://stackoverflow.com/questions/283679/how-can-i-call-net-code-from-java

Perhaps that will help get you started
Go to Top of Page
   

- Advertisement -