DTS ActiveX task: a better editor

DTS ActiveX task: a better editor

Post by Allan Mitc » Fri, 02 Jul 2004 16:21:07


No. You cannot choose to use a different editor.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.yqcomputer.com/


task inside DTSs?
 
 
 

1. setting sql query of Transform Data Task with ActiveX Script Task inside DTS package?

2. DTS: Transform Data Task with ActiveX

I trying to write out comment records in 40 byte chunks from a much longer
field(see below) but I can't find any way of writing out the records inside
the loop. The code below works (and the loop is being executed) but nothing
turns up in the output. Does anyone have any thoughts?

'***********************************************************
' Visual Basic Transformation Script
'***********************************************************

' Copy each source column to the destination column
dim Comment
dim CommentOut
dim CommentSub


Function Main()

if DTSSource("OrderID") <> DTSGlobalVariables("OrderID") then
' Process Comments

Comment = DTSGlobalVariables("Comment")

Do While len(Comment) > 0
if len(Comment) > 40 then
CommentOut = left(Comment,40)
CommentSub = mid(Comment,41,len(Comment)-40)
Comment = CommentSub
else
CommentOut = Comment
comment = ""
end if

DTSDestination("OrderID") = DTSGlobalVariables("OrderID")
DTSDestination("LineNumber") = DTSGlobalVariables("LineNumber")
DTSDestination("Comment") = CommentOut

Main = DTSTransformStat_OK

Loop

' Store Comment from the record causing the control break
DTSGlobalVariables("OrderID") = DTSSource("OrderID")
DTSGlobalVariables("Comment") = DTSSource("PackingNote")

end if

Main = DTSTransformStat_OK


End Function

3. How to call an .exe from DTS ActiveX task?

4. DTS - Task ActiveX Error

5. Creating a DTS ActiveX Task

6. DTS activex task to query soap web service ?

7. DTS Package ActiveX Script Task For XML

8. CopyFile in DTS ActiveX Script Task

9. Bizarre run time error from DTS ActiveX Task

10. DTS Designer for ActiveX Script Tasks Loses Script Pane???

11. DTS problem: ActiveX Script Task Properties dialog box

12. Timeout expired error in DTS with an ActiveX Script task

13. DTS : How to "Execute Process Task" from an Activex ?

14. Code DTS Event handlers in an ActiveX Script in the DTS Package

15. Is there a better (free) wysiwyg text editor than the built in Content editor web part?