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]

Re: MSDE and ODBC Tables

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" <fbishop@viper. com> wrote in message
news:4204f6e5$1 _2@127.0.0.1...[color=blue]
>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![/color]

[Frank Bishop]

Re: MSDE and ODBC Tables


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]

Re: MSDE and ODBC Tables

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_addlinkedser ver
and use the OPENQUERY or to use OPENROWSET.

John


"Frank Bishop" <fbishop@viper. com> wrote in message
news:420637fb$1 _2@127.0.0.1...[color=blue]
>
> 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![/color]

[Ansti]

Re: MSDE and ODBC Tables

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" <fbishop@viper. com> wrote in message
news:420637fb$1 _2@127.0.0.1...[color=blue]
>
> 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![/color]