Clever Geek Handbook

How do I go about transferring data from ODBC application to SQL on an hourly basis?

I am trying to get data from an ODBC application to SQL2005 (dev ed) DB on an hourly basis. When I start SSIS, the option to import all tables and views is grayed out and forces you to write a query. How do I configure SSIS to update ALL 250 tables on an hourly basis.

+1


source to share


3 answers


Which database does your ODBC data source point to? SSIS may not give you a GUI to select tables / views for all DB types.



+1


source


Perhaps you could rephrase your question a little, I'm not 100% sure what you are asking here. Are you trying to get data in SQL Server from an application via SSIS with a Data Transform task using an ODBC connection to the application?

Anyhoo, the simple answer to the MS Access part of your question is "hell no". MS Access has never been the answer to anything ;-)



I would be inclined to figure out why tables and views are greyed out and fix this issue. (not enough information in this question to determine why they are gray)

0


source


You may be better off using the Import and Export Wizard. Go to SQL Server Management Studio, right-click on the database you want to import data into and select Tasks โ†’ Import Data. It will launch a wizard that guides you through defining the import process.

At the end of the wizard, you can import and even save it as an SSIS package, which you can customize later.

0


source






More articles:


All Articles