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.
| Author |
Topic |
|
Rockymarko
Starting Member
6 Posts |
 Posted - 2008-10-27 : 11:52:25
|
| Hi,I am facing some issues with DTS package.After running DTS I am getting below error.EXCECUTE SQL TASK :undefinedThe statement has been terminatedAn invalid datetime value was encountred.Value exceeds the year 9999How I can sole tis issue? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-27 : 11:57:34
|
| moved from script library._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 12:52:15
|
| its because of some bad data. Check for source data to look for value 9999 in date field. Its not a vaild date according to sql server. either remove row itself or correct data with some default value.b/w where does source data come from? table of flat file? |
|
|
|
|
|
|
DTS Problem