I am facing an error while retrieving data from Oracle into a variable. This
is the scenario:
1. I have table in Oracle and SQLServer with the same structure as below. My
SSIS package is to sync data from Oracle to SQLServer

I have installed the SQL Server 2000 DTS Designer Components on a Vista
machine. When trying to open a .dts file (Management Studio | Management |
Legacy | right-click Data Transformation Services | Open Package File |
browse to desired .dts file), I get the following message:

I have a DTS that run weel when I run it manualy I mean when I right click
on it et select Execute DTS.
When I Scheduled The DTS it fails.
The DTS is importing Data From an accpac Application with a SYSTEM DATA