May 31, 2011 at 4:22 pm
I do not have the ado.net source listed in my dataflow toolbox for some reason. I tried adding ..dts..pipeline..\Microsoft.SqlServer.ADONETSrc.dll to the toolbox in BIDS and
it gives me an error about loading the library.
I am on windows server 2003, sql server 2005.
Everything else seems to work, but not this.
May 31, 2011 at 4:27 pm
oops meant to put this in sql 2005 ssis forum sorry
June 17, 2011 at 9:57 am
I am also interested in hearing a response to this. I do not have ADO.NET objects under Data Flow Sources or Data Flow Destinations. I am using CS 2005 Premiere Partner Edition with SSIS Designer v. 9.0. Any help or suggestions would be appreciated.
June 17, 2011 at 1:41 pm
From what I have been reading, the ADO.Net components are only available in SSIS 2008. I used the process in the following article and have successfully moved data into a mySQL destination using SSIS 2005.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply