 | |
Need a DTS to run multiple data sources.
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Need a DTS to run multiple data sources. -
09-03-2008
, 05:11 PM
#2
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#3
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#4
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#5
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#6
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#7
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#8
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
#9
| |||
| |||
|
|
I am running SQL Server 2000 SP4. *My problem is I need to run sp_reinitsubscription for multiple publications. *I try setting up a DTS that has multiple data sources and Execute SQL Tasks, but my execute seems to fail. All my publications are in 1 instances, but spread out among the databases. Any ideas on how I can do this? -- Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200809/1 |
i don't know much about Publications and Replica... but i've read
(http://technet.microsoft.com/en-us/l.../ms189469.aspx) that you
must have sysadmin role permission to run this sp. Have you used a
sysadmin role login in every connection (data source) in your package?
What's the result of the execution in a query analyzer window?
What's the error message you get?
M.
|
« 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.