so im trying to connect to an odbc source and use ado.net to pass some sql queries and then write back into this odbc connection. i am aware that ssis does not have direct capabilities to do this, but i wanted to see if anyone knew of generic help docs/url's that show how to do this? i am new to ssis, and am just trying to get general information.
See Douglas post here:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=70469&SiteID=1
The code is also in SQL Books Online.|||
to be honest with you, i did see that thread you mention above, probably the only thread with realistic information. I am looking for something specifically in C#.
I am also wondering if there is any way to not have the SQL Command line filled for the ODBC connection source and use ODBC and a combination of ADO.net? Anyone have success with this?
I did search books online for the particualar phrase mentioned in the above thread..not too helpful.
Just wondering if anyone has had success writing C# ado.net to read and write using ODBC as a source?
thanks!
|||If that's what you are after then I would try a dev forum if I were you: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=12&SiteID=1
-Jamie
sql
No comments:
Post a Comment