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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why it keeps telling me syntax error?

Status
Not open for further replies.
mariayx

mariayx

Programmer
May 18, 2001
17
US
Hi,
I have the following line in my ActiveX script in a DTS package, it keeps giving me compilation error. Can anyone tell me why?
MyStringPosition = InStr( 1 , v_fullfilename , 'ABC' , 1 )
Thanks,
mariayx
 
Sort by date Sort by votes
Hi,

Put the sought string in double quotes: "ABC"

Cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kristal9
  • Locked
  • Question
DTS Excel File Load Error 1
Replies
1
Views
79
drlex
drlex
BradF
  • Locked
  • Question
Bulk Import w/Format File and Text Fields - Why is it not working?
Replies
0
Views
54
BradF
BradF
gquint
  • Locked
  • Question
DTS Error Handling with Muliphase Data Pump
Replies
0
Views
55
gquint
gquint
Aluminum
  • Locked
  • Question
DTS Raiserror messages suddenly stopped displaying
Replies
0
Views
75
Aluminum
Aluminum
RonMck
  • Locked
  • Question
Received Error "Cannot Find Column -1" when exporting
Replies
1
Views
76
RonMck
RonMck

Part and Inventory Search

Sponsor

Back
Top