wala.be
SSC Rookie
Points: 29
More actions
March 28, 2008 at 3:14 am
#180435
Hi all,
I would like to know if there is a way to convert data type in SSIS by using SQL script?
In the Data flow Task I found only the possibilty to use Data conversion from Tools. But I need to set the data types by using script.
Many Thanks,
April 1, 2008 at 1:10 am
#796320
Any one can help?
thx
xanthos
SSCrazy
Points: 2510
April 2, 2008 at 4:29 am
#797086
Use the cast or convert function in you SQL query.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply