Is it possible to backup a DTS package in SQL Server
2000?
It's possible to manually backup data and log files but I
can't find a reference to backing up the DTS packages.
Can anyone help?
Thans in advance, Matt
by Matt » Tue, 02 Jul 2002 22:36:31
Can anyone help?
Thans in advance, Matt
by Andrew J. Kell » Tue, 02 Jul 2002 22:41:05
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
Quote:> Is it possible to backup a DTS package in SQL Server
> 2000?
> It's possible to manually backup data and log files but I
> can't find a reference to backing up the DTS packages.
> Can anyone help?
> Thans in advance, Matt
by yan wang [M » Fri, 05 Jul 2002 22:01:21
Regards,
Yan
***This posting is provided 'AS IS' with no warranties, and confers no
rights.*****
by RogerioPaiv » Sun, 07 Jul 2002 09:26:46
Sub DTS_Backup()
Dim myPack As New DTS.Package2
myPack.LoadFromSQLServer "myServerName", "myUserName", "myP
assWrd", , , , , "myPackName"
myPack.SaveToStorageFile "c:\myPackName.dts"
End Sub
Tha problem is that the pack is saved with a totally
different layout (with an automatic layout).
Is that possible to save it holding the original package
layout?
Is there an automatic way of bacing up DTS packages?
by Allan Mitche » Sun, 07 Jul 2002 18:52:17
There is a problem when saving the package as a VB bas module and
expecting the format to remain.
Allan Mitchell
www.sqldts.com
On Fri, 5 Jul 2002 17:26:46 -0700, "RogerioPaiva"
>Sub DTS_Backup()
>Dim myPack As New DTS.Package2
>myPack.LoadFromSQLServer "myServerName", "myUserName", "myP
>assWrd", , , , , "myPackName"
>myPack.SaveToStorageFile "c:\myPackName.dts"
>End Sub
>Tha problem is that the pack is saved with a totally
>different layout (with an automatic layout).
>Is that possible to save it holding the original package
>layout?
>Is there an automatic way of bacing up DTS packages?
by Darren Gree » Mon, 08 Jul 2002 19:26:20
It will work when using the designer because it knows all about layoutQuote:>What version of SQL Server are you using and what service pack level.
>I have just saved a SQL Server stored DTS package to a .dts file and
>then opened it back up in DTS Designer and the layout was exactly the
>same.
There is no workaround when using the object model I'm afraid.
My DTSBackup 2000 tool has it's own methods which do persist the layout
information, but this format is only available for local packages.
DTSBackup 2000
http://www.sqldts.com/main.asp?nav=1,6,242,0
More information about backing up packages-
Backing Up Packages
http://www.sqldts.com/main.asp?nav=1,6,202,0
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
by Allan Mitche » Tue, 09 Jul 2002 04:19:54
Think I must have misread. Was the original poster saying they
created the package itself in VB or just that they opened it in VB
LoadFromSQLServer and the saved to Storage File SaveToStorageFile.?
Makes the wold of difference.
Allan
www.SQLDTS.com
On Sun, 7 Jul 2002 11:26:20 +0100, Darren Green
>It will work when using the designer because it knows all about layout
>information. When using the object model, as in the sample code, there
>is no knowledge of the designer information, layout and annotations, and
>it is lost.
>There is no workaround when using the object model I'm afraid.
>My DTSBackup 2000 tool has it's own methods which do persist the layout
>information, but this format is only available for local packages.
>DTSBackup 2000
>http://www.sqldts.com/main.asp?nav=1,6,242,0
>More information about backing up packages-
>Backing Up Packages
>http://www.sqldts.com/main.asp?nav=1,6,202,0
>--
>Darren Green (SQL Server MVP)
>DTS - http://www.sqldts.com
by Rogério Tinoco de Paiv » Thu, 18 Jul 2002 00:59:39
Thanks for your attention.
>Think I must have misread. Was the original poster
saying they
>created the package itself in VB or just that they opened
it in VB
>LoadFromSQLServer and the saved to Storage File
SaveToStorageFile.?
>Makes the wold of difference.
>Allan
>www.SQLDTS.com
>On Sun, 7 Jul 2002 11:26:20 +0100, Darren Green
Mitchell
>>>What version of SQL Server are you using and what
service pack level.
>>>I have just saved a SQL Server stored DTS package to
a .dts file and
>>>then opened it back up in DTS Designer and the layout
was exactly the
>>>same.
>>It will work when using the designer because it knows
all about layout
>>information. When using the object model, as in the
sample code, there
>>is no knowledge of the designer information, layout and
annotations, and
>>it is lost.
>>There is no workaround when using the object model I'm
afraid.
>>My DTSBackup 2000 tool has it's own methods which do
persist the layout
>>information, but this format is only available for local
packages.
>>DTSBackup 2000
>>http://www.sqldts.com/main.asp?nav=1,6,242,0
>>More information about backing up packages-
>>Backing Up Packages
>>http://www.sqldts.com/main.asp?nav=1,6,202,0
>>--
>>Darren Green (SQL Server MVP)
>>DTS - http://www.sqldts.com
>.
How do I back up a DTS package? I don't where it is stored. I looked
in msdb but I don't see it.
thanks
3. How to roll back a failed DTS package
4. Using Access: How to copy text from field above? Please help!
6. question about OCI driver / java think client
8. Multilingual VB-Application
9. Backing up and restoring a dts package
11. Backing up / Restoring a DTS package
13. Getting A Return Code From A DTS Package Back To The O.S. Errorlevel