Re: Delete DTS Package in code

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 17:19:10 +0000

In message <5FF7D3BD-6A7F-4139-9A2C-45CADFAA88C7@microsoft.com>, Adam
Cain <AdamCain@discussions.microsoft.com> writes
>Darren, you defintely got my attention. How can I run a package
>asynchronously without saving it to run it through a stored procedure?
>

Ok, I missed the bit about the stored proc call. Sorry. That will be a
bit of a problem as you are breaking the create and execute across VB
and SQL. Stick with the save, execute and delete. Use unique names for
the packages each time they are created I guess would aoid the clash of
concurrent users.

Sorry about that, it's possible I'm sure, but I think the effort would
far outweigh any benefit as there are workarounds for your current
issues.

Cheers

Darren 

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Relevant Pages

  • RE: exec sp_help_job user account rights
    ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
    (microsoft.public.sqlserver.security)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... It looks like it is not going to be an easy job getting it to work on the SQL Server 2005 and Express:(. ... 'Then you can execute the command and then retrieve the ID ... I am 100% sure this code works against any version of SQL Server, as long as the connection is OK and the SP has two parameters @varCompany as Input and @Return_Value as Output. ... I do not think your problem is due to difference of SQL Server2000 and SQL Server2005, unless your stored procedure has some thing that only works in SQL Server2000, not SQL Server 2005. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DTS Error EXCEPTION_ACCESS_VIOLATION
    ... >>We have some DTS jobs that runs every night called via a ... >>Package ... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Scheduled DTS package doesnt run
    ... I created a DTS package wich runs a standard Stored Procedure in the master ... I call the stored procedure by an Execute SQL Task object with all necesarry ... When I log on as administrator on the server and run the package manually it ... Error string: SQL Web Assistant: Could not execute the SQL statement. ...
    (microsoft.public.sqlserver.dts)
  • Re: ETL rejects records intermittently
    ... The data source is the SQL SERVER 2005 table. ... We first dump the data from ... When I execute the SSIS package ...
    (microsoft.public.sqlserver.dts)