invalid argument error

[kunai]

Hi,

I have a DTS package that i use to import data into a table. It has 2 global variables (strings).

The data files are stored locally on the server before the package is run.

I'm getting the following error:

Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft JET Database Engine
Step Error Description:Invalid argument.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003001

This happens whether i run it from my application or excuting it directly in Enterprise Manager.

I have checked user rights and everything seems fine.

Any ideas please?

Thanks
-J

 

[kunai]

I've found out that the error is because my task isn't accepting the path to my dbase data file. I can't specify in the ActiveX code the filename.

Anyone?

 

[kunai]

Fixed it.
The problem was that i was feeding the path and filename to my Dbase connection object. (thus the reason for the error). It only accepts the path.

I used code to change the source:

oPKG.Tasks("DTSTask_DTSDataPumpTask_1").Properties("SourceObjectName").Value = DTSGlobalVariables("fileName").Value

Works fine.