Given a STRING column with a value as "1/13/2017 2:40:18 PM" I get error can't convert
Is it possible in ETL?
Is anyone able to help out with this request?
@AshfordLC That message generally means that the ETL is not encountering the format that it's expecting. One thing to double check is that you are setting the "What format is the date in?" to "Month first". From the example value you provided, it looks like that should be the one.