MSDE and ODBC Tables

[Frank Bishop]

I have a MSDE database and I need to delete the contents of the exiting
tables and then import new data on a scheduled basis from an ODBC data
source (preferable through a system DSN). This was easy to do in SQL
2000 Enterprise given the DTS tools and then just scheduling a job thru
the agent.

Is there an example of how I could do this just using scripts and MSDE
(like a stored proc)? It looks like I have the agent still in MSDE to
use.

Help appreciated.
Thanks,
Frank

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Bell]

Hi

I am not sure what you are having an issue with, but this may help
http://www.sqldts.com/default.aspx?204.

John

"Frank Bishop" <fb*****@viper.com> wrote in message
news:42**********@127.0.0.1...

I have a MSDE database and I need to delete the contents of the exiting
tables and then import new data on a scheduled basis from an ODBC data
source (preferable through a system DSN). This was easy to do in SQL
2000 Enterprise given the DTS tools and then just scheduling a job thru
the agent.

Is there an example of how I could do this just using scripts and MSDE
(like a stored proc)? It looks like I have the agent still in MSDE to
use.

Help appreciated.
Thanks,
Frank

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Frank Bishop]

Thanks, but this wont help. I don't have SQL tools (e.g. Enterprise
Manager or DTS) anymore. I just have MSDE (SQL desktop).

I trying to find out some script examples of how to Transfer data
between an ODBC database and MSDE.

Thanks,
Frank
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Bell]

Hi

It may be worth investing in the developer edition at $50! Other ETL tools
will do a similar task http://www.sqldts.com/default.aspx?401

An alternative approach is to either add a linked server sp_addlinkedserver
and use the OPENQUERY or to use OPENROWSET.

John
"Frank Bishop" <fb*****@viper.com> wrote in message
news:42**********@127.0.0.1...

Thanks, but this wont help. I don't have SQL tools (e.g. Enterprise
Manager or DTS) anymore. I just have MSDE (SQL desktop).

I trying to find out some script examples of how to Transfer data
between an ODBC database and MSDE.

Thanks,
Frank
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ansti]

You could use MS Access or somthing else that can connect to database tables
with ODBC. There you can make INSERT or SELECT INTO queries.

"Frank Bishop" <fb*****@viper.com> wrote in message
news:42**********@127.0.0.1...

Thanks, but this wont help. I don't have SQL tools (e.g. Enterprise
Manager or DTS) anymore. I just have MSDE (SQL desktop).

I trying to find out some script examples of how to Transfer data
between an ODBC database and MSDE.

Thanks,
Frank
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!