SSIS Data Flow
How do you reference a data source through ODBC?
April 19th, 2011 11:44am

See this topic: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/80ecabce-d009-4f3e-ae4d-6c8a0549e6b4/ Or you are asking how to set up an ODBC DSN?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 11:47am

Use ADO NET Source component in the data flow task and select odbc data provider in the provider to connect to ODBC and choose the data source name whether excel, access ,dbase, visio ..Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
April 19th, 2011 11:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics