sql server dts: In brief:

We have an older, DOS-based billing system with the tables
stored as .dbf files. We are currently building it's
replacement with a VB6 front on a SQL database. The table
structure has been completely changed for the new
database; every night our server backs up the .dbf files
and we have a number of DTS packages that copy the back-up
files (so we never touch the live data) into the SQL
database and then parse the data out into the appropriate
tables.

My problem is this:

We've bundled the packages together into one DTS package
that runs them all and scheduled it to run early in the
morning, after the .dbf files are backed up. It does run,
without error, but it's not grabbing the current .dbf
files. Even odder is that if I go into the Enterprise
Manager and manually execute the package, it runs fine and
pulls the correct data.

We have verified that the .dbf files do back up hours
before the DTS runs, so it isn't a timing issue.

Has anyone had similar problems? And does anyone have any
suggestions?

Thanks in advance!

I have accasional problems with files as sources. Odd in that we have
to open the package and step through the properties/format (not changing
anything). We then save it and it works perfectly. We have to go in
now an then when a pump stops working and just touch the properties and
go back out. Then all is fine. Looks to me like a bug in DTS since we
haven't opened the DTS package in designer in quite some time.

--

If the job runs manually but doesnt work on the scheduler, it could be that the SQL server services account (probably named like SQLSVC) doesnt have permissions on the files. When you run it manually, it is running under your account which I am assuming has file permissions. Hope this helps.

From http://www.developmentnow.com/g/103_2003_7_0_0_393166/Scheduled-DTS-Doesnt-Run-Properly.htm

Posted via DevelopmentNow.com Groups