dbTalk Databases Forums  

Help needed

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Help needed in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter Newman
 
Posts: n/a

Default Help needed - 05-11-2004 , 05:26 AM






I had asked this question earlier earlier without adding much info. I compiles a vb6 AxticeX dll which i have used the Register Custom Task to be able to use it in my DTS. There are three parameters for the tas

Description String Feil
OrigionalFileName String Feil
NewOutputFileName String Feil

I can manuall insert the values in the DTS and it completes the task fine, however im trying to set the values from an Active x task and failing with various errors stating that the object was not fount to the object doesnt support this method
Can anybody suggest a way to set to resolve this. in this instabce if i look on the workflow properties for my task its shown a
DTSStep_ConvertFileForSQL.ClsConvert_1

Actice X cod
Function Main(
' select type of file and enable the tasks as require

dim Pk
dim stpAru
set pkg = DTSGlobalVariables.Paren
set stpAruc = pkg.steps("DTSStep_ConvertFileForSQL.ClsConvert_1" ).customtas

' ensure all steps are disable
stpAruc.DisableStep = True

' Set the required Values
stpAruc.Description = "Test File Convertor
stpAruc.OrigionalFileName = DTSGlobalVariables("gv_FileFullName").Valu
stpAruc.NewOutputFileName = "d:\temp\NEWFILE.TXT

Main = Main = DTSTaskExecResult_Succes
end function

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.