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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Date Conversion

Author  Topic 

stevenbe1
Starting Member

2 Posts

Posted - 2010-12-16 : 10:34:26
Using an ssis package I am passing a date variable %TIME_DIM% which has a format of 2010.dec. I want to use this variable as part of a sql where clause.

I am looking for a way to convert the 2010.dec to 201012%. The where clause s/b 'where time like %TIME_DIM%' Can anyone suggest a way to accomplish this?
   

- Advertisement -