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

DTS - Execute Package Task

At which version/SP level  does the Execute Package Task get introduced to DTS?
I just noticed it's not available on a SQL 7 server, and I was hoping to get this
feature without converting to SQL 2000 just yet.
0
vd
Asked:
vd
  • 4
  • 4
  • 3
  • +2
1 Solution
 
racostaCommented:
It is available on sqlserver 7
0
 
racostaCommented:
with dtsrun from DOS
0
 
SYASSINCommented:
I dont believe the execute package task is available in SQL Server 7.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
i couldn't verify, but if it is available in SQL Server 7, then only from SP3 on, which has some options related to SQL 2000...

Listening & Learning
0
 
racostaCommented:
If you type from DOS : dtsrun, you will be able to specify the package that you want to run connecting to the server.
   If it doesn't work find it in ..\mssql7\binn
0
 
SYASSINCommented:
I dont think this is what vd is asking.  Please clarify vd -
1) do you want to know how to execute a dts in sql server 7 from the command prompt?

2) to know if you can execute processes normally done at the command prompt as part of a dts in sql server 7?

- sy
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
SYASSIN, in SQL 2000 you can execute a single step from a DTS package, even if the package contains several steps.

The question is really if this is a functionality that is available in SQL 7 SPx or not...

CHeers
0
 
racostaCommented:
Of course...I use it on SQLServer 7...With Enterprise Manager you can create a package with several steps and task, save and execute it immediate, or scchedule it.
0
 
vdAuthor Commented:
Thanks for the comments!
Clarification: The Execute Package Task is available from the Toolbox in DTS
on 2000. It allows one to execute an already created package from the current
package.  It is not available in SQL 7 sp1.
I was hoping someone knew if this task is available in one of the SQL 7 SP's
(or have an alternate suggestion), so that I don't have to install SQL 2000
on the server just yet!
0
 
curtis591Commented:
If you want to run a dts package on 7 you can create a vb script task and do the following

Set dts_package = CreateObject("DTS.package")
dts_package.LoadFromSQLServer "SERVER", "USER", "PASSWORD", , , , , "PACKAGE"    

dts_package.execute()
   
0
 
vdAuthor Commented:
The vb script task sounds great.
I don't see a vb script task though...do you mean the Active Script task, or
something else?
0
 
curtis591Commented:
Yep that is it.
0
 
vdAuthor Commented:
I tried the vb script. It didn't work ( a syntax error).
Could you explain/expand  the example somewhat?
0
 
curtis591Commented:
I have taken this code and substituted the server name, user name , password and package name and tested it on my server and I seemed to work ok.   Let me know how you make out.  
'**********************************************************************
'  Visual Basic ActiveX Script
'************************************************************************

Function Main()
  Dim fso, opackage, oconn, file_list, dts_package, status

   Set dts_package = CreateObject("DTS.package")
   dts_package.LoadFromSQLServer "MYSERVER", "MY USER", "MY PASSWORD", , , , , "MY PACKAGE"    

  dts_package.execute()
   
      'Check DTS Errors if some are found then an email is sent
      found_error = check_dts_errors (dts_package)

      dts_package.UnInitialize
      Set dts_package = Nothing

     Main = DTSTaskExecResult_Success
End Function

function check_dts_errors (dts_package)
 Dim errsource, errdescription, lperrorcode

 check_dts_errors = "0"
 For i = 1 To dts_package.Steps.Count
   If dts_package.Steps(i).ExecutionResult = DTSStepExecResult_Failure Then
      check_dts_errors = "1"
   End If
 Next
end function
0
 
vdAuthor Commented:
Thanks, this is an excellent work around!

Angeliii   : Thanks, indeed SP3 does not have the Execute Package object available.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 4
  • 4
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now