Help in DTS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help in DTS

Author

Topic

Sunilkumar81
Starting Member

2 Posts

Posted - 2007-06-18 : 12:47:17

Hi,

i'm tryingt to run:
{
DTSDestination("ACCOUNT") = substring('00' + DTSSource("Account") + 'CC',1,5);
return(DTSTransformStat_OK);
}
in activeX trans. properties.

i can succesful run the '+' (concatenation) but when try to put substring function, it error out saying object required.

Please advice

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-18 : 13:02:48

SUBSTRING is not a C# function, it's SQL function.
Try MID as function name.

Peter Larsson
Helsingborg, Sweden

Sunilkumar81
Starting Member

2 Posts

Posted - 2007-06-18 : 13:12:28

even using MID, it's giving the same error of "object require"
i'm using enterprise manager sql sever 2000.

please advice

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources