 | |
DTS Package - truncate, drop index and migrate data in same DTSpackage
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Package - truncate, drop index and migrate data in same DTSpackage -
06-09-2008
, 10:22 PM
| Connection 2 |
Prior to executing the above DTS package, I maunally truncate the
table and drop the index on the table located at Connection 2.
I would like to drop the index and truncate table prior to migrating
the data. But I would like to do it in the same DTS package.
Thanks in Advance
#2
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#3
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#4
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#5
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#6
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#7
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#8
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#9
| |||
| |||
|
|
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) Connection 1 | | | Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. But I would like to do it in the same DTS package. Thanks in Advance |
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO
Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).
Sorry for bad english, hope it helps anyway.
Bye,
Matteo
#10
| |||
| |||
|
|
On Jun 10, 5:22 am, research_stuff <learnstu... (AT) ix (DOT) netcom.com> wrote: Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the source server, the transformation and Connection 2, the destination server) * * * * * * *Connection 1 * * * * * * * * * * | * * * * * * * * * * | * * * * * * * * * * | * * * * * * *Connection 2 Prior to executing the above DTS package, I maunally truncate the table and drop the index on the table located at Connection 2. I would like to drop the index and truncate table prior to migrating the data. *But I would like to do it in the same DTS package. Thanks in Advance Hi, you must use the Execute SQL Task. If you want to use only one task, then you must separate each statement with GO. It should be something like this: DROP INDEX... GO TRUNCATE TABLE... GO Alternatively you can use 1 Execute SQL task for each statement and link one task to each other with a OnSuccess constraint (Workflow menu). Sorry for bad english, hope it helps anyway. Bye, Matteo- Hide quoted text - - Show quoted text - |
destination table.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.