John,
I had been working with Mike on some problems with Posgresql data types, INT8 and Money not working in the importer and he knew we were using the very latest version 7.7.2.4 so I did not mention it again. We had to change the data type we were using to VARCHAR in the ODBC settings and change the MONEY type to VARCHAR to get the importer working with Postgresql.
Today when I was looking through the logs to see if could find something useful to send you, I decided to try to start the service manually again ( I was able to re-boot the server last night after installing the license key) the service did not started from the re-boot (set to automatic) and was not running but today when I manually started it from the Services application it did start. I stopped it and re-started it and it is working now. Not sure what to say, another administrator may have had some patches pending I did see some log entries related to some Office feature installs. I will let you know if it does not start the next time I re-boot the server.
The agent service has never run prior to today, I had assumed it was because we were using demo software and I assumed the two enter license key splash screens were trying to interact with the desktop and were causing the service no to run. After I installed the license key I had hoped the error would just go away, and now for some unknown reason it has.
On a related matter I find in many cases when I add file operations related to deleting files or renaming files I get multi-step errors and general instability of the package. If I copy the file operation icon to a new package as is and execute it, it will run without error. I do get an error when I past the icon into the new package but it seems to work when I executed the package.
I have a very nice package running with lots going on but it seems to break very easily and become unstable for no obvious reason. I try to add a step to clean out a download directory before I do an FTP and I get errors. I try and move some files to a local Archive and I get errors. I will past some of the errors I have received in line below. Am I missing something related to permissions or general setup. We are new to using this software. I am running these packages under the context of the domain administrator. Most of the time the Multiple-step error is what comes up and the package never finished running.
The server this is running on is a domain controller for a few windows clients, most of the clients are now running Linux and a different LDAP, the server seems very stable no problems running other software. In some cases I have created CMD files to do the same operations and called them from your package and they seem to work performing the same steps. We could not get FTP wild card file delete to work without errors (using full paths with wild card filenames) so we wrote a command line file and use FTP MDELETE and it does work on the remote MS FTP server, we added it as the last step in the package.
Jim
