Dear Friends,
I have a doubt relation when converting a field…
I ‘m converting a string to datetime inside a SQL command in an OLE DB Source using this:
convert(datetime,[Maturity],103) As MaturityDate
It’s better to use inside the OLE DB Source or is better to convert it with data conversion transformation?
Regards!!
Thanks
Probably just a matter of opinion. SSIS can do datatype conversions, but has to create a new column in the pipeline to hold the new type, which is a little bit inefficient. I generally don't like things "hidden" in the OLE DB Source, but in this case I think that's what I'd do.|||
But witch of these options is more fast?!
Regards!
|||
PedroCGD wrote:
But witch of these options is more fast?!
Regards!
I think SQL would be faster. And because I hate being wrong, I tested it before I said that. I averaged the times for three runs of 20,000 rows and SQL appears 12% faster than SSIS.
|||
PedroCGD wrote:
But witch of these options is more fast?!
Regards!
Why don't you try it and tell us. You're in the best position to judge because its your data.
-Jamie
|||I'm agree with you jamie!! :-)
What a question I made... eheheh... I can see the time in the logs of the cube!!!
Sorry...
Tomorrow I will give you the response!! thanks both!!
|||Someone help me?!|||
PedroCGD wrote:
Someone help me?!
Umm, with what? Call 911? |||
sorry was teh wrong post!!
And relating to this post, the better choice is converting the date in OLE DB SOurce.
Thanks!
|||
PedroCGD wrote:
sorry was teh wrong post!!
And relating to this post, the better choice is converting the date in OLE DB SOurce.
Thanks!
Good to knw (and as expected). Thanks Pedro.
No comments:
Post a Comment