Re: DTS Permissions

From: Olu Adedeji (anonymous_at_email.com)
Date: 02/24/04

  • Next message: Adam Machanic: "Re: Preventing unauthorized access" 
    Date: Tue, 24 Feb 2004 22:26:23 -0000

    try sp_reassign_dtspackageowner 

    --
Olu Adedeji
"Peter Cwik" <anonymous@discussions.microsoft.com> wrote in message
news:155bb01c3fa49$ecf965f0$a601280a@phx.gbl...
> Assuming you can open the package, simply click on
> package in the upper left and save as...
> >-----Original Message-----
> >We have a DTS package that was created and saved by
> >someone who is no longer with the company.  How can we
> >convert this DTS package to a valid ID?  Thanks
> >.
> >
  • Next message: Adam Machanic: "Re: Preventing unauthorized access"

    Relevant Pages

    • Re: importing xls file - different attempt - one result....
      ... Why not use the wizard to create the exact DTS package you need to import XLS files? ... Dim oConnection as DTS.Connection2 ... Dim oColumn As DTS.Column ...
      (microsoft.public.sqlserver.dts)
    • DTS Package remotely in batch file
      ... the package on the server. ... ECHO The execution of the DTS package has succeeded. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
      (microsoft.public.sqlserver.dts)
    • Re: DTSRun and Batch file
      ... >>refreshed via DTS package, including an Analysis Services task to ... Analysis Services on the client machine. ... So the DTS package is running ... suggesting about implementing a web form or Win form. ...
      (microsoft.public.sqlserver.dts)
    • Re: DTSRun and Batch file
      ... >>refreshed via DTS package, including an Analysis Services task to ... Analysis Services on the client machine. ... So the DTS package is running ... suggesting about implementing a web form or Win form. ...
      (microsoft.public.sqlserver.dts)
    • RE: Resuming a failed DTS package - Proper ETL design with DTS package
      ... Somehow I'm supposed to be able to rollback and entire DTS package if it ... You use database transactions to bind multiple updates into a single atomic ...
      (microsoft.public.sqlserver.dts)