SQL server
FTP + SQL2000 DTS – excellent!
For all of us dinosaurs still using SQL 2000, an extremely useful (if you need this of course!) custom DTS task is the SQLDTS FTP Task which “is designed to give you greater control over FTP operations compared to the task supplied with SQL Server 2000″. The ability to FTP text files (in both directions) [...]
sql 2000 DTS ‘cannot open a log file of specific name’
When migrating DTS packages today I came across a problem with DTS log files I had completely forgotten about.
The DTS package seemed to run perfectly but on completion it said ‘cannot open a log file of specific name’ – this revealed itself to be a problem with the packages logging properties which I’d forgotten to [...]