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.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2007-10-01 : 16:25:41
|
| Hi, all my friends,This is another rookie one. Is there a way in SSIS dev environment that will let you convert/cast data type at desing time?Under data flow mappings, there are so many things you can do, but why I did not find any easy way to convert?I got this validation warning about not supportng converting type DT_STR to DT_I4, or something related. Am I missing something obvious?Thanks! |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-10-02 : 09:41:47
|
| I think I have found the answer. I need to insert a data convertion step in between. That is a lot of work involved for such a simple thing.Another way I can think of is, instead of using table as the source, use sql SELECT, and do the convert in the t-sql. |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-10-08 : 09:21:21
|
As you've discovered, there's a nice transformation specifically for this purpose - no script tasks, etc. required. How much easier do you want it!?  Mark |
|
|
|
phatchico
Starting Member
3 Posts |
Posted - 2007-10-17 : 13:13:41
|
| If you are doing any transformation to the data you can also change it Derived Column, so this might take one extra step out. Just define your transformation, and the data type you want it in when it is done. |
|
|
|
|
|
|
Convert data type in SSIS