Re: Import and Schedule DTS on MSDE

You can also open a package on the originating server and save as file, copy file, open file on dest
server and save to msdb.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"ngaya" <ngaya.1pm9u1@xxxxxxxxxxxx> wrote in message news:ngaya.1pm9u1@xxxxxxxxxxxxxxx
>
> Thanks...I got it at last...I took a backup of msdb database and
> restored in MSDE, and tried
> exec msdb..sp_enum_dtspackages
> go
> to see the list and it was there.
> I was able to run the pacakge successfully using dtsrun.
> Phew!...this took a lot of my timelah!... If i had known the simple
> thing that dts packages are stored in msdb database...this would have
> been over long back...thanks for that info..
>
> ngaya
>
>
>
> --
> ngaya
> ------------------------------------------------------------------------
> Posted via http://www.mcse.ms
> ------------------------------------------------------------------------
> View this thread: http://www.mcse.ms/message1244207.html
>


.

Relevant Pages

  • Re: Saving SSIS Packages
    ... I tried using the import wizard, importing a file based package and migrating ... Is DTC required for importing into msdb? ... When using the import wizard in SQL Server Management Studio, ... Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, ...
    (microsoft.public.sqlserver.dts)
  • Re: Error:EXECUTE permission denied on sp_add_dtspackage, database msdb, owner dbo
    ... remote server where I did not have access on msdb database.I changed ... the destination to save in the local server. ... I am trying to schedule a DTS package which imports data from a remote ... EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS packages in SQL 2000 slow to open
    ... Are there many versions of the package in MSDB? ... Now try to open this package on the now remote server which was ... This way if it opens quickly you can say ... Also all the msdb tables open up quickly in the remote EM. ...
    (microsoft.public.sqlserver.dts)
  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)