Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-13 : 08:10:01
|
| Kuhan writes "I've cereated 2 DTS Packages both using 2 different SQL servers.but both DTS are on one SQL Server.When I 'm trying to schedule one DTS package which is using the Source DB on the local SQL server it's working fine but when I'm trying to schedule the other DTS package which is using the Sourse DB from the other SQL Server is giving Errors.Eg:SQL Server1;SQL Server2 (Two Different SQL Servers)SQL Server1:DTs package1,DTS package2 (both DTSs are on SQL Server 1)SQL Server1:DTS1:Source Table,DestinationTable(DTS1 using source and destination on the same SQL Server)SQL Sserver1:DTS2:Source Table(onSQL Server2):Destination(SQL Server1)When I'm scheduling DTS1 it is working fine on SQL Server1.but DTS2 is not be able to schedule on SQL Server1.Could you please advise me on this Many ThanksKuhan" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-13 : 08:25:44
|
| What's the error? It always helps when you acutally include the error so we can figure out what's going on. You probably just have permissions issue here.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
DTS Package Scheduling Problem