Re: executing dts files from asp.net



Where is the file that has the package? Security?
The box from which you are executing has the DTS dlls?


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Daniel Patiño" <Daniel.Patino@xxxxxxx> wrote in message
news:11ajhlhgsmg6047@xxxxxxxxxxxxxxxxxxxxx
> Hi everyone:
>
> Could you help me, I'm trying to execute dts in file format from an
> asp.net
> application. I tired using the guide from "DotNETCookBook", the process
> is
> not successful, there aren't any error code nether action!.
>
> I can't use DTS stored in the SQL, and I can't use xp_cmdshell for
> security
> issues.
>
> thanks a lot.
> ________________
> Daniel P.
>
>


.



Relevant Pages

  • Re: DTS Package not running
    ... Under the jobs it says executing and it can run for hours. ... When I run the job through DTSRUNUI it runs but when I schedule the ... The DTS does not period. ... >>> can run the jobs that does not have DTS package but if the job is DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: dtsrun.exe hangs before complete
    ... there fore it would need to be whereever the package is executing. ... www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun OnStart: Create table TABLE1 step ... > DTSRun OnFinish: Create table TABLE1 step ...
    (microsoft.public.sqlserver.dts)
  • Re: Unzip file using DTS
    ... Hello Jim, ... DTS with change of my directory name. ... And after executing DTS it says ... >> so that i can create activex task in DTS and test. ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to execute a DTS with scheduled job
    ... Also remember that DTS is a client application and as such runs on the box that says "go". ... This means you executing a package on ServerA from your Wkstn is very different from you executing a package on ServerA from the server itself. ... Why I read:Cannot open database '', ...
    (microsoft.public.sqlserver.dts)
  • ASP.NET and DTS: problems with CreateObject
    ... we are facing a serious issue about executing DTS packages from ... use LoadFromSQLServer method to run DTS within ASP.NET ... SQL Server is in mixed mode authentication ... cannot use xp_cmdshell for security issues ...
    (microsoft.public.sqlserver.dts)