Learn how to a build a cloud-first strategyRegister Now


Convert SQL 2K DTS to SQL 2005 SSIS

Posted on 2006-04-05
Medium Priority
Last Modified: 2012-06-21
How do i convert this script for it to be compatible with SSIS.

Function Main()

      dim pkg
      dim cus
      dim strCmdLine
      set pkg = DTSGlobalVariables.Parent

      set cus = pkg.Tasks("DTSTask_DTSCreateProcessTask_1").Customtask
      'Build the commandline string      
      strCmdLine = "D:\Inetpub\wwwroot\files\output\Archive\Reset.BAT " & DTSGlobalVariables("Account_Number").Value & ".mdb " & DTSGlobalVariables("Account_Number").Value & ".zip"

      'Assign it to the ProcessCommandline property
      cus.ProcessCommandLine = strCmdLine

      'Clean up
      set pkg = nothing

      Main = DTSTaskExecResult_Success

End Function
Question by:karthikram
  • 2
  • 2

Author Comment

ID: 16387209
I am using this script as part of a Task . Account number is given as an input.

Error when i try to run the project
Started:  5:00:35 PM
Error: 2006-04-05 17:00:39.89
   Code: 0xC0048006
   Source: Set Command Lines ActiveX Script Task
   Description: Retrieving the file name for a component failed with error code
End Error

LVL 29

Expert Comment

ID: 16387731
Check out this URL.
It deals with migrating DTS to SSIS and particularly with the error you are getting


Author Comment

ID: 16395982
yes that was usefull but how do i convert the DTSGlodblaVariables ?

Quote " For example, ActiveX script references via the DTSGlobalVariables Parent property are no longer valid. Since Dynamic Property Tasks refer to the absent parts of the old object model, these too will require attention"

I just need the equivalents in SSIS
LVL 29

Accepted Solution

QPR earned 1500 total points
ID: 16396088
From what I can tell... you have to rewrite them :(
I've Googled for you but all I can find is this:


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question