Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: coolaid808
- Order by date
-
Insert Error..Data Overflow
What I mean with: > So I changed the definition in SQL Server from SmallDatetime to DateTime and the import succeeds. Is that I changed the datatype of the 'EndDate' Column in the table design of the table where the import fails (by means of the SQL Enterprise Mgr). You can also use the...- coolaid808
- Post #7
- Forum: Microsoft SQL Server: Data Transformation Services
-
Insert Error..Data Overflow
Hello Millzy, I had the same problem with valid dates (2099-12-31). The Import Export Wizard in SQL Server automatically creates a table when the table does not exist when importing. In Access (my source) the datetime field is created in SQL Server (my destination) as a SmallDatetime field...- coolaid808
- Post #6
- Forum: Microsoft SQL Server: Data Transformation Services
