January 14, 2015 at 7:00 am
Hi All,
I need some help. I have Visual Studio 2008 setup on my machine and I just recently got my admin to setup an ODBC connection for me so I can start to access some data from a third parties database. I tested the connection in the connection manager and everything works. I created a new package, dragged over a data flow task, opened the task and was ready to begin creating my ODBC source. Then I realized in the toolbox there is no option for ODBC source!
Is there a work around for this? I searched the internet for help and see that 2012 and 2014 versions do have an ODBC source in the toolbox.
Can anyone please help me out so I can use this ODBC connection as my source so I can start building my mappings?
Thanks
January 14, 2015 at 7:21 am
You need to use the ADO.NET connection manager instead of the ODBC connection manager (yeah, obvious right? :-D)
In the ADO.NET connection manager you can select the ".NET providers\ODBC Data provider" provider.
Then you can use the ADO.NET source/destination to get your data.
An article with a lot of screenshots:
Using ODBC and ADO.Net to Connect SSIS to DB2
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 7:26 am
Ugh, that wasn't too bad 😀 Thank you for your help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply