I'm trying to push data into an Access DB from a straight forward Sequential file stage. I'm using the MSOLEDB stage with all the correct parameters and columns,etc.
However I keep getting the following (quite undescriptive) error:
Can anyone help me with writing data to Access?DataStage Job 59 Phantom 5568
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage AccessTest..MS_OLEDB_33
DataStage Phantom Aborting with @ABORT.CODE = 3
Am I using the correct stages?[/quote][/b]