SQL Server Performance Forum – Threads Archive

Converting to smalldatetime

Hi, I am using SSIS to migrate from a flat file source to a database. In the source file there is timestamp but the source column expects a smalldatetime, is there a way to covert between these two types? Thanks

---

Can you post the sample timestamp value and your expected datetime value? Madhivanan Failing to plan is Planning to fail

---

If your timestamp is valid datetime column you don’t need to explicitely convert it…
Mohammed U.

---

SmallDateTime accuracy is the minute, if you need better accuracy use dateTime (3.33 miliseconds).

---

]]>