I have set up a small active X script in a DTS package. I've used the filesystemobject to copy any files which have been created today into another folder.
The script uses an IF command, if I leave the IF out the DTS package runs fine if I put it back in I get an Invalid task Result Value...
We have just restored some files using arcserve 2000 on NT, it was a mistake! The arcserve log has told us that it has restored 725 folders and 5633 files. We don't know which files it has restored. Does anyone know if there is a more detailed report with this information in?
I'm using NT 4.0 workstation on a laptop and have deleted a profile. Unfortunatley the profile contained some files in the personal folder, is there anyway of getting these back apart from restoring from a backup because we don't have one!
The ODBC DSN was already set up as a system DSN. SP looked fine.
I read the first article that you suggested and used the ScriptPkg which comes with SQL 7.
I used this to script my packages and then ran the executables using task manager, it worked. I'm still hoping to get the job scheduler...
Initially I did seem to have a permissions problem, I could run the package from EM on my machine but it wouldn't run on the SQL Server. I managed to get round this. I can execute the package from EM on the SQL Server even though the login used by the SQL Server has no permissions to the 400. I...
I have created a DTS package which transfers data from the AS400 to SQL Server. This executes fine on the server but when I run it as a scheduled job it fails. I have found lots of articles dealing with this problem but I still don't seem able to get it to work.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.