Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Convert SQL 2K DTS to SQL 2005 SSIS

Posted on 2006-04-05
4
Medium Priority
?
1,503 Views
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
0
Comment
Question by:karthikram
  • 2
  • 2
4 Comments
 

Author Comment

by:karthikram
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
0x04A46A84.
End Error

0
 
LVL 29

Expert Comment

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

http://www.simple-talk.com/2005/11/18/dts-to-ssis-migration/
0
 

Author Comment

by:karthikram
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
0
 
LVL 29

Accepted Solution

by:
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:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/dtsfss05df.asp

0

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