• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

Exec SPS that has DTS but waiting for the DTS to finish?

I need to execute 4 SPS

SP_NIVELMP
SP_EXISTENCIASMP (tiene dts)
SP_DISPONMP
SP_INVPROV

but the second one for example has a DTS. The third one must not execute if the DTS has not finished.  Any recommendations about it.
0
djhex
Asked:
djhex
  • 6
  • 5
1 Solution
 
praneethaCommented:
http://www.eggheadcafe.com/forums/ForumPost.asp?ID=19282&INTID=9

see how they have the ExecutionResult =

may be that is what u r looking for...
0
 
djhexAuthor Commented:
ok.

CAn u please tell me how to make a progress bar while those sps are executing?
0
 
djhexAuthor Commented:
IT uses an IMPORTS DTS

Where is it??
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
praneethaCommented:
http://www.experts-exchange.com/Databases/Q_20847825.html

here is the link how to call a DTS from stored procedure...and i guess u just call the sp from asp.net like any otehr SQL...

hmm and then http://www.c-sharpcorner.com/Code/2003/Jan/DTSCustTask.asp

link to call DTS directly from asp.net

well i am sorry i don't have muc knowsledge anout this...

Good Luck
0
 
praneethaCommented:
i guess in the first link(the egg cafe one..the one u asked about )   there were talking about the DTS.DLL ..they mentioned here
http://www.c-sharpcorner.com/Code/2003/Jan/DTSCustTask.asp
0
 
djhexAuthor Commented:
I cant understand this line


        pkg.LoadFromSQLServer(AppSettings("Server"), AppSettings("user"), AppSettings("pwd"), DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "", "", "pruebaCdr1")
 
0
 
djhexAuthor Commented:
   pkg.LoadFromSQLServer("MED20NT", "sa", "xxx", DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "", "", NombreDTS, "")


Its strange that there is no parameter specifying the default catalog or database
0
 
djhexAuthor Commented:
I get this error with the line above

      Message      "Excepci├│n de HRESULT: 0x80040E14."      String
0
 
djhexAuthor Commented:
Sorry I was sending a bad name of DTS. Forget the last comment
0
 
praneethaCommented:
oh ok cool
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now