We have a DTS package doing some transformation in Trasactional Replication.
Now, I want to add a new table as a part of the replication without shutting
down replication. I can add it through sp_addaarticle and sp_addsubscription.
However the DTS can't be modified as one of the component in DTS is not
available in DTS designer.
This is the package that SQL Server creates automatically for you when you
specify DTS as a media for data transformation. Since, I dont have this
table's data driven task in DTS, I am getting following error in Distribution
DB.
Cannot find the Data Driven Query task in the DTS package that matches
command.
Thank you very much.
create a new publication for this article and add it.
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:F9F5749E-7B78-4398-A23F-DEE4FB9E74C2@.microsoft.com...
> We have a DTS package doing some transformation in Trasactional
> Replication.
> Now, I want to add a new table as a part of the replication without
> shutting
> down replication. I can add it through sp_addaarticle and
> sp_addsubscription.
> However the DTS can't be modified as one of the component in DTS is not
> available in DTS designer.
> This is the package that SQL Server creates automatically for you when you
> specify DTS as a media for data transformation. Since, I dont have this
> table's data driven task in DTS, I am getting following error in
> Distribution
> DB.
> Cannot find the Data Driven Query task in the DTS package that matches
> command.
> Thank you very much.
>
Sunday, March 11, 2012
DTS Package Error in the Transactional Replication
Labels:
database,
dts,
error,
microsoft,
mysql,
oracle,
package,
replication,
server,
sql,
table,
transactional,
transformation,
trasactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment