Trying to set a Constant of "N" or "Y"

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

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Trying to set a Constant of "N" or "Y"

Author

Topic

scottjohniec
Starting Member

7 Posts

Posted - 2007-04-05 : 09:05:05

I'm trying to set a Constant of "N" or "Y" into a Data Field when reading a file in from a AS400 utilizing DTS and VBScript. It seems to work OK when I manually run the Step 2. My DTS Package is made up of 6 steps. If I fire off the Main Function ( 1- 6) it doesn't set the Y or N. If I Fire off each step it works... If I schedule the Package to run at a certain time, it doesn't set the values either. Does anybody have any ideas??

AS400- 2 Character Field CHAR
SQL Server- 2 Character Field VARCAR

*********************************************************************
' Visual Basic Transformation Script
'************************************************************************

' Copy each source column to the destination column
Function Main()
DTSDestination("DELCOP") = "N"
Main = DTSTransformStat_OK
End Function

scottjohniec
Starting Member

7 Posts

Posted - 2007-04-09 : 12:14:18

I setup each job to run independent in DTS.. I scheduled them 15 Minutes apart from each other.. It runs GREAT... Still can't find an answer why scheduling 1 job to pass all 6 steps upon successful completion for each step isn't working... STRANGE !!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources