I'm using a DTS package to transfer data from a Paradox table to my SQL 2000 server.
When I use the Import/Export wizard to transfer data from Paradox it works fine, but if I choose to run AND save the job as a DTS package on the local server, although it runs OK, when I run the saved DTS package it fails.
The error generated suggests the table doesn't exist but of course it does.
There is a known issue I am aware of with table names more that 8 chars long. However, I have the Borland Database Engine installed, and this should resolve the issue.
I don't understand why the package executes OK, but then run as a saved package it fails. I have had this working but I think this was before applying SP1. Any advice would be appreciated.
When I use the Import/Export wizard to transfer data from Paradox it works fine, but if I choose to run AND save the job as a DTS package on the local server, although it runs OK, when I run the saved DTS package it fails.
The error generated suggests the table doesn't exist but of course it does.
There is a known issue I am aware of with table names more that 8 chars long. However, I have the Borland Database Engine installed, and this should resolve the issue.
I don't understand why the package executes OK, but then run as a saved package it fails. I have had this working but I think this was before applying SP1. Any advice would be appreciated.
