DTS does not pass the detailed error back to DataGarage/Collect. When troubleshooting a DTS failure it is crucial to run the package manually to expose the underlying error. Use the following steps to run a DTS package manually (from the App server).
DTSRUN /n [package name] /u [username] /p [password] /s [sql server]
[package name] = The full name of the dts package (e.g. dgBASIS.BAS60.AM01.imp)
[username] = The account Cransoft uses to log in to the SQL Server where the package exists
[password] = The password for that account
[sql server] = The name of the SQL Server where the package exists