Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB Script in Integration Manager

Status
Not open for further replies.

CanadaMarkham

IS-IT--Management
Aug 9, 2010
1
CA
Hi

I wrote following VB script in integration manager, it is working fine with
one integration but for some reason it is not working for other integration:
(Only difference b/w two integrations is Column name)

Dim DocNO, fso, fw
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Set DocNO = SourceFields ("COFHeader.F2")
DocNO = "FAILED ***" & (DocNO) & Chr(10) & Chr(13)
Set fso = CreateObject("Scripting.FileSystemObject")
Set fw = fso_OpenTextFile("D:\COF\FailLog\Fail.txt", ForAppending, True)
fw.Write DocNO
fw.Close

I am getting this result in file:
FAILED ***

For some reason "DocNO" is missing.

Any help will be appreciated. I am not developer.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top