DTS vs Job Problem for 2 Digit Date format

From: Norm (nbrault_at_sympatico.ca)
Date: 04/01/04 

Date: Wed, 31 Mar 2004 22:40:06 -0800

I've create a DTS package to load a text Document to a
existing table into SQL ,one of the field is a datetime
field,went i execute the package manually i get a date of
2049 for a 2 digit year of 01/01/49 but went i execute the
same DTS thru a Job i get a date of 01/01/1949 .

Does anyone experience the same problem?
Any idea how this can be fix ?

Thanks

Relevant Pages

  • Priviledges problem with "execute master..xp_logevent&q
    ... Here is what I experienced when trying to get the logging into SQL ... If I execute the DTS package from Enterprise Manager using a SQL ... If I create a SQL job from the DTS package and run that sql job using ...
    (microsoft.public.sqlserver.dts)
  • SQL output in DTS SQL Execute Task
    ... When you run a DTS package with a simple "Execute ... Where does that, or ANY output, from the SQL go??? ... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 ...
    (microsoft.public.sqlserver.server)
  • flow in dts sql task
    ... in a sql step of a dts package the code is ... otherwise the failure part to execute. ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored Procedures
    ... In the Exec SQL Task just type in the code to execute the procedure, ... > I created DTS package, added a SQL connection and added an Execute SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Opinions on approach, please...
    ... Create a data layer program per table, ... number of bind variable tokens in your dynamic SQL. ... then simply EXECUTE that without passing it any parameters? ... Hard code WHERE clauses. ...
    (comp.lang.cobol)