469,913 Members | 2,588 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,913 developers. It's quick & easy.

Syntax Error on a DTS Package script

I created a DTS package. I am trying to use the DTS package to remove leading zeros from one of the fields (Number). Below is the script that I have so far. I get a syntax error when I run the pacakage.

Function Main()
DTSDestination("Action") = "NEW"
if DTSSource("OwnerAccountID") like '0%' then DTSDestination("Number") = substring (Number,2,len (Number)) else DTSDestination("Number") = DTSSource("OwnerAccountID") end if
Main = DTSTransformStat_OK
End Function

SQL Server 2000
Sep 11 '07 #1
1 1247
debasisdas
8,127 Expert 4TB
As you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Markus Doering | last post: by
1 post views Thread by Ricky_newbie | last post: by
9 posts views Thread by Tin Gherdanarra | last post: by
12 posts views Thread by Brad Baker | last post: by
2 posts views Thread by Sean Hammond | last post: by
3 posts views Thread by PaulLFC | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.