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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-04-21 : 07:32:30
|
| Hello ,I have a Notes server on which data needs to be pumped to SQL Server 2000 . The steps are pretty simple with first truncate the table on SQL and then push the data from Notes . But the first step executes successfully . The second step fails where the data cannot be pumped to SQL Server . Further , the process completes without any error . So we tried the reverse way i.e pull the data from Notes Server to SQL by creating a scheduled job which runs under an sa account. But that too fails . Then the last option we tried is that we created a DTS package for data import . When the package is executed manually it runs but when we try to schedule it it fails . What i wanted to know is that is there any authentication issue between SQL and Notes ? As SQL uses sa account and notes uses .id files for authentication. How do they both interact and validate any user ? Any thoughts in this regard ? I have tried my best to get help on this , but in vain. Thanks admin001 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-21 : 07:44:29
|
| HiThe only thing I can think of off the top of my head, when you executed it manually, did you do that from a different machine to the server ?When you execute a DTS package, it runs on your machine. When you schedule it, it runs on the server.So, what I am thinking (and this is often a winner) is that on your server you are missing a notes driver or client library that is present on your dev machine.Does that spark any ideas ?Damian |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-04-22 : 02:17:20
|
| Hi Damian ,Thanks for your reply . Actually I am executing from my system where SQL EM manager is installed . I have only the client tools installed . What is the difference between executing DTS manually and scheduling a DTS . Can you clarify your second statement a bit please . I also have a NotesSQL driver installed on my system as i had to execute the DTS manually . Similarly it is installed on another system also where the DTS is executed manually . Thanks once again . |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-22 : 08:04:10
|
| Sorry, I'll try to be clearer.When you manually execute a DTS package, the execution takes place on your computer (i.e. the one you are sitting at when you hit execute). So if you have some client libraries installed on your machine that the package needs, it will work OK.When you schedule the package and it runs unattended, it runs on the server machine. If that is a different machine from the one with the client tools, you may not have some of the dependencies.Does that make more sense ?Damian |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-04-22 : 22:01:43
|
| Hi Damian ,Thanks a lot . That clarifies my doubt on DTS . Admin001. |
|
|
|
|
|
|
|
|
Notes to SQL import .