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 strongm 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: 6fingeredman
- Order by date
-
DTS DATE PROBLEMS YYYY-MM-DD
OK We totally simplified this but have one burning question, the code below works fine but if we use a 4 digit year it fails ! The error we get is data overflow invalid cast etc, we are SQL2000 So what I am saying is that if I change iyear = right(DTSSource("clindate"),2) to iyear =...- 6fingeredman
- Post #2
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTS DATE PROBLEMS YYYY-MM-DD
Hi, My Source table contains a varhcar(20) field which holds dates in the format YYYY-MM-DD, I am trying to convert the dates but am having problems. Ive attached 2 examples of how I have been trying. Please could someone give me some tips on where I am going wrong? I get the following error...- 6fingeredman
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
