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.
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 |
|
|
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 |
|
|
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-javaPerhaps that will help get you started |
|
|
|
|
|