none
SSIS Data Type Conversion RRS feed

  • Question

  • HI,

    Let's say you have a column in source file (.csv for example) where you set the datatype of that column to money. Somewhere down the process, you convert that datatype from money to money (from/to same datatype). Would it cause any issue at that step?

    Thank you

    Friday, July 26, 2013 3:33 PM

Answers

  • it will not cause issue, but is there any necessity ?

    Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by B3nt3n Friday, July 26, 2013 3:50 PM
    Friday, July 26, 2013 3:44 PM

All replies

  • it will not cause issue, but is there any necessity ?

    Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by B3nt3n Friday, July 26, 2013 3:50 PM
    Friday, July 26, 2013 3:44 PM
  • Nice, thanks.

    Yeah, there is a pkg already made where in source datatype is DT_WSTR and I want to change that to money and I am sure that it is being converted to Money somewhere in the process...don't want to go hunt for this as the pkg is kind of complex. So I was just wondering if changing from wstr to money at the source would cause any issue where it's being converted from wstr to money by using data conversion. 

    Thanks!

    Friday, July 26, 2013 3:50 PM