tag:blogger.com,1999:blog-5892883484418619512.post4689578637899834201..comments2023-09-14T02:29:20.720-05:00Comments on SQL Servings: What I learned today – importing mixed data types from Exceljaypehttp://www.blogger.com/profile/09643701158012749143noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5892883484418619512.post-66987305528439713932010-07-27T10:31:18.147-05:002010-07-27T10:31:18.147-05:00This behaviour is the bane of the Excel provider&#...This behaviour is the bane of the Excel provider's existence - and therefore a PITA for anyone who deals with it. Here's another link for you that will blow your mind with the length and breadth of issues that can arise with the Excel provider, and how you can (mostly) deal with them in SSIS: <a href="http://dougbert.com/blogs/tags/Excel/default.aspx" rel="nofollow">Dougbert's blog posts on Excel and SSIS</a>.Todd McDermidhttps://www.blogger.com/profile/10444379572904639267noreply@blogger.comtag:blogger.com,1999:blog-5892883484418619512.post-92099052962724638182010-07-21T16:24:43.671-05:002010-07-21T16:24:43.671-05:00You're welcome Piotr, hope it helped. I hadn&#...You're welcome Piotr, hope it helped. I hadn't heard of it before I wrote about it either.jaypehttps://www.blogger.com/profile/09643701158012749143noreply@blogger.comtag:blogger.com,1999:blog-5892883484418619512.post-79662423728992592072010-07-21T14:24:16.698-05:002010-07-21T14:24:16.698-05:00That's funny John, I was asked for help with t...That's funny John, I was asked for help with the exactly same issue today. Thanks for this post :)Piotr Rodakhttp://usepubs.blogspot.comnoreply@blogger.com