Date continued

When you have the DateID as an int that represents a real date it can be good to be able to use SSIS to convert datetime to int in an easy way.

In this blog post by Mike Davis shows a very easy to do it. You can find his code below

(year(@[User::dtStartDate]) * 10000)+(month( @[User::dtStartDate]) * 100)+Day( @[User::dtStartDate])

This entry was posted in BI, SSIS and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>