October 18, 2013 at 3:23 pm
Is there a way to cast an input data automatically to the destination column type ?
October 18, 2013 at 4:24 pm
You can do a derived column that performs the conversion.
October 18, 2013 at 11:19 pm
blasto_max (10/18/2013)
Is there a way to cast an input data automatically to the destination column type ?
No.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 19, 2013 at 12:04 pm
Phil Parkin (10/18/2013)
blasto_max (10/18/2013)
Is there a way to cast an input data automatically to the destination column type ?No.
Okay. So, it there a set of scripts that can convert data from one data type to another ?
October 20, 2013 at 10:40 pm
Use the Derived Column Transformation (as mentioned earlier in the thread).
Rob
October 20, 2013 at 11:12 pm
robert.gerald.taylor (10/20/2013)
Use the Derived Column Transformation (as mentioned earlier in the thread).Rob
Won't work in my case. Its a pretty complicated situation. The derived column itself would have to be generated dynamically and then mapped to a dynamically generated destination column !!! I gave up on that one. Using another approach now.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply