DTS is working, but it is not running in schedule?
DTS is working, but it is not running in schedule?
(OP)
Hi,
I have a DTS in SQL Server 2000 that truncated the table in SQL 2000 and Select * from a table in Access then import into the table. It works no problem in the DTS section. However, when I schedule the DTS that run every night, it had an error and said it couldn't find the Access table. When I checked the DTS itself, it works no problem. Any ideas to solve this problem?
Thank you very much.
I have a DTS in SQL Server 2000 that truncated the table in SQL 2000 and Select * from a table in Access then import into the table. It works no problem in the DTS section. However, when I schedule the DTS that run every night, it had an error and said it couldn't find the Access table. When I checked the DTS itself, it works no problem. Any ideas to solve this problem?
Thank you very much.
RE: DTS is working, but it is not running in schedule?
Hope this helps,
Alex
----signature below----
Majority rule don't work in mental institutions
My Crummy Web Page
RE: DTS is working, but it is not running in schedule?
I tried to write the store procedure instead of using the DTS. I have an error on it and it keeps saying the connection erro. Can anyone helps?
Create Procedure [dbo],[spXX] As
truncate table [DatabaseName].[dbo].[TableName]
insert into [DatabaseName].[dbo].[TableName]
Select
Convert (Char(10),GetDate(),101) as as_of,
Field1,
Field2,
Field3
From OpenDataSource
('SQLOLEDB','Provider=Microsoft.Jet.OLEDB.4.0;Data Source = S:\FolderName\database\databaseName')
Go
Thanks.
RE: DTS is working, but it is not running in schedule?
RE: DTS is working, but it is not running in schedule?
From OpenDataSource
('SQLOLEDB','Provider=Microsoft.Jet.OLEDB.4.0;DataSource=UNCpath')
Thanks.
RE: DTS is working, but it is not running in schedule?
RE: DTS is working, but it is not running in schedule?
RE: DTS is working, but it is not running in schedule?
I tested it by copying the entire database from the Novell Network to the Local C Drive and schedule to run it again, it works great.
I think my solution is either ask the Network guy to help me or create a step to copy the S drive Access.mdb to the C drive. Before I bug the Network guy, I am wondering can I write a step to copy the S drive Access.mdb ot the C drive? Is it workable? If so, can anyone guilde me how to do this?
Thanks a lot.