• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • 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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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