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!

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

Active X Script (IF Then)

Status
Not open for further replies.
NotSQL

NotSQL

Technical User
May 17, 2005
205
GB
Hi,

Can any one tell me why this might not be working?

If DTSDestination("2Number") = DTSSource("PNo")then

DTSDestination("PDescription") = DTSSource("Description")

End If

Cheers
 
Sort by date Sort by votes
You need a space between your ".. = DTSSource("PNo") THEN" but that could just be a typo here and not in your code.

Try putting "Main = DTSTransformStat_OK" after the END IF

Journeyman -- The Order of the Seekers of Truth and Penitence
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

betachristopher
  • Locked
  • Question
Use IF/ELSE in Query 1
Replies
3
Views
185
drlex
drlex
smedvid
  • Locked
  • Question
VB Script to Dynamically Copy File?
Replies
1
Views
54
smedvid
smedvid
awolff02
  • Locked
  • Question
Determine if Package failed or success
Replies
1
Views
69
mkal
mkal
S1002
  • Locked
  • Question
SQL Server 2000 DTS Package Active X Help
Replies
5
Views
51
S1002
S1002
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
76
mutley1
mutley1

Part and Inventory Search

Sponsor

Back
Top