Re: SQL Object Transfer Task
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/07/04
- Next message: Paul Ibison: "Re: How can I process each row in result set to access properties on another package object?"
- Previous message: Prabhat: "Re: DTS Error 1st Time"
- In reply to: eguru007: "SQL Object Transfer Task"
- Next in thread: eguru007: "Re: SQL Object Transfer Task"
- Reply: eguru007: "Re: SQL Object Transfer Task"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Jun 2004 08:49:24 +0100
If you create the indices by hand then you will be able to make a DROP
script and a CREATE script. This will allow you to DROP them before moving
the data and then reapply after moving the data. If you are only moving 1 *
table then using the Transfer Objects task may be an overkill. Try a simple
datapump task.
-- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "eguru007" <eguru007@yahoo.com> wrote in message news:A563AE44-DA80-44F3-8D99-2613C0975478@microsoft.com... > Hi people! > > I have a situation where I need to move table data from a variable source server to variable target server. I am using SQL Object Transfer Task and updating the task properties from Dynamic Property Object. It works fine. > > But I need to drop indexes on target tables before copy and recreate after copy. After spening some time I found out that DTSTransfer_ScriptOption Constant property can be used to make this happen. > > I have no clue how to compute this constant, BOL doesn't offer much help. > > Any pointers please. > > Eguru007 >
- Next message: Paul Ibison: "Re: How can I process each row in result set to access properties on another package object?"
- Previous message: Prabhat: "Re: DTS Error 1st Time"
- In reply to: eguru007: "SQL Object Transfer Task"
- Next in thread: eguru007: "Re: SQL Object Transfer Task"
- Reply: eguru007: "Re: SQL Object Transfer Task"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
