call run or execute a DTS package from an APS (aspx) page

how do i
call run or execute a DTS package from an APS (aspx) page?


platform
win2k
iis (the one that comes with win2k)
sql server 2000 - with a test dts package ready to be called
..NET framework 1.1 installed and working correctly
web matrix is being used to create the files.

would prefer some example code in VB.NET but anything which works would be
fine

what libraries need to be referenced - how can i search for them?

and surely i don't have to carry out everything in the

cookbook at sqldev.net

i have been trying to sort this for over a day and i have to say that it has
just turned into the usual MS mess.

kev

Re: call run or execute a DTS package from an APS (aspx) page

kevin bailey wrote:
> how do i
> call run or execute a DTS package from an APS (aspx) page?
>
>
Check out www.sqldts.com
There's a faq that covers this

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: call run or execute a DTS package from an APS (aspx) page

kevin bailey wrote:
> how do i
> call run or execute a DTS package from an APS (aspx) page?
>
PS. There was no way for you to know it, but this is a classic asp
newsgroup.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a newsgroup where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: call run or execute a DTS package from an APS (aspx) page

Bob Barrows [MVP] wrote:

> kevin bailey wrote:
>> how do i
>> call run or execute a DTS package from an APS (aspx) page?
>>
> PS. There was no way for you to know it, but this is a classic asp
> newsgroup.
> While you may be lucky enough to find a dotnet-savvy person here who can
> answer your question, you can eliminate the luck factor by posting your
> question to a newsgroup where the dotnet-savvy people hang out. I suggest
> microsoft.public.dotnet.framework.aspnet.

sorry bob - i thought ASP.NET was just the latest version of ASP - now
realise there are more differences.

i'll check out the other NG,

cheers - kev

Re: call run or execute a DTS package from an APS (aspx) page

Bob Barrows [MVP] wrote:

> kevin bailey wrote:
>> how do i
>> call run or execute a DTS package from an APS (aspx) page?
>>
>>
> Check out www.sqldts.com
> There's a faq that covers this
>

there's a mad cookbook thing which says how to get sql DTS 2000 working with
VB.NET but not aspx pages - is that what you are referring to?

are we syaing that dts package stuff does not exist within the .NET
framework?

thanks - kev

Re: call run or execute a DTS package from an APS (aspx) page

kevin bailey wrote:
> Bob Barrows [MVP] wrote:
>
>> kevin bailey wrote:
>>> how do i
>>> call run or execute a DTS package from an APS (aspx) page?
>>>
>>>
>> Check out www.sqldts.com
>> There's a faq that covers this
>>
>
> there's a mad cookbook thing which says how to get sql DTS 2000
> working with VB.NET but not aspx pages - is that what you are
> referring to?
>
> are we syaing that dts package stuff does not exist within the .NET
> framework?
>

Right. It's an external library (SQLDMO). Why would you expect it to exist
within the framework?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.