dbTalk Databases Forums  

Scheduled DTS date format problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Scheduled DTS date format problem in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Diana
 
Posts: n/a

Default Scheduled DTS date format problem - 07-16-2003 , 08:27 AM






Hi,
I use DTS packages to import data from downloaded files
(.csv) to the SQL server. The date format for both the
download and the tables is dd/mm/yy.
When I scheduled the packages to run as jobs, the date
formats transpose to mm/dd/yy, but when I run them
manually, the date formats are dd/mm/yy.
Could this have something to do with the default language,
or the regional settings?
Thanks for your assistance,
Diana



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.