i can't find out where does the sql server save my DTS packages. i have seen that there is something in the msdb DATABASE about DTS but i couldn't find my
DTS package over there.
any ideas?
RE: Recover SQL files & DST packages from server backup ... Move Databases Between Computers That Are Running SQL Server... In order to backup and restore the DTS Packages, it depends on how they are ...Microsoft CSS Online Newsgroup Support... This newsgroup only focuses on SBS technical issues. ... (microsoft.public.windows.server.sbs)
RE: Recover SQL files & DST packages from server backup ... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database.... (microsoft.public.windows.server.sbs)
RE: DTS Designer problems after upgrade to SQL Server 2008 ...SQL Server 2000 DTS Designer components are required to edit DTS packages.... "SQL Server 2000 DTS Designer Components"... No resolution was achieved. ... (microsoft.public.sqlserver.dts)
RE: DTS in SQL Server 2005 ... To run SQL Server 2000 DTS packages in SQL Server 2005, ... that SQL Server 2005 Integration Services (SSIS) has been installed. ... you select Integration Services for installation,... (microsoft.public.sqlserver.dts)
Re: Audits ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs.... > My apologies for my first submission going in twice (Igot an error mess. ... > Is there a method to record the data you send in your DTS packages, for viewing at a later date, most of my packages are empty, but when i send data I would like to see what I've sent and if it is OK then delete the data, and check it again the next day...and so on! ... (microsoft.public.sqlserver.dts)
