text file comes with default date 1/1/1900 . I tried in derived column before converting in to date as [column1] =="1/1/1900" ? Null or

[column1] =="1/1/1900" ? "" before data...

Replacing the space with a null did not work either

the end data type is smalldate , reading from text file.

thanks

Hi,

can you please provide a sample code for that ?

thanks

madhu

Hi , thanks for the help but when I ran the command

EXEC msdb.dbo.sp_get_sqlagent_properties I got the resule as :-

auto_startmsx_server_namesqlagent_typestartup_accountsqlserver_restartjobhistory_max_rowsjobhistory_max_rows_per_joberrorlog_fileerrorlogging_levelerror_recipientmonitor_autostartlocal_host_serverjob_shutdown_timeoutcmdexec_accountregular_connectionshost_login_namehost_login_passwordlogin_timeoutidle_cpu_percentidle_cpu_durationoem_errorlogsysadmin_onlyemail_profileemail_save_in_sent_foldercpu_poller_enabledalert_replace_runtime_tokens

1NULL1BISQLuser@ROUNDPOINT.LOCAL110000100C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT3NULL1NULL15NULL0NULLNULL30106000NULLNULL100

But when I navigated to C:\Program Files\Microsoft SQL...