MSDE and DTS

Hi,
I have a DTS package that I would like to execute from an application
that uses MSDE as it's back end. Is it possible to 'attach' a DTS
package to an MSDE database and execute it from Say example VB.Net.
Any info will be appreciated.
Thanks,
VaughnIf you save a DTS package as VBScript, you should be able to run that
package from a .NET application.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<vaughn.haybittle@.gmail.com> wrote in message
news:1157129984.437055.7530@.e3g2000cwe.googlegroups.com...
> Hi,
> I have a DTS package that I would like to execute from an application
> that uses MSDE as it's back end. Is it possible to 'attach' a DTS
> package to an MSDE database and execute it from Say example VB.Net.
> Any info will be appreciated.
> Thanks,
> Vaughn
>

MSDE 7.0 and SQL2000

Can you install SQL2000 on a server with an application
that is using MSDE 7.0 which was installed with the
software ?
If you can, what is the best way to do so without it
affecting the previous installation of MSDE 7.0 ?Yes you can. BE aware, though, that MDAC on the machine will be upgraded to
2.6 (if not or higher
already), so make sure you test the app for that MDAC version.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Valencia" <vahorda@.hotmail.com> wrote in message news:a86f01c3ebb2$9d88f350$a401280a@.phx.gbl...[Q
UOTE]
> Can you install SQL2000 on a server with an application
> that is using MSDE 7.0 which was installed with the
> software ?
> If you can, what is the best way to do so without it
> affecting the previous installation of MSDE 7.0 ?
>[/QUOTE]|||Thank you Tibor. I checked the version of MDAC and it is
2.5.
>--Original Message--
>Yes you can. BE aware, though, that MDAC on the machine
will be upgraded to 2.6 (if not or higher
>already), so make sure you test the app for that MDAC
version.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Valencia" <vahorda@.hotmail.com> wrote in message
news:a86f01c3ebb2$9d88f350$a401280a@.phx.gbl...
>
>.
>