Convert SQL 2K DTS to SQL 2005 SSIS

Posted on 2006-04-05
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

    Author Comment

    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

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

    Author Comment

    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

    From what I can tell... you have to rewrite them :(
    I've Googled for you but all I can find is this:


    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now