SSIS Package Run Through Tidal Scheduler Agent Not Successful

Hi,

I have created a simple SSIS package using BIDS which does data copy from SQL Server to a excel file

I'm able to execute it using dtexec command locally connecting to the remote db server.

We have a file shared server where we are keeping the dtsx files.

Our DB server is located on another server.

We have another file shared server where Tidal agent is installed and we have created a batch file which has the dtsexec command and this batch is kept here.

Now when I create a job and run it it gives us the following outputCode: 0xC0014019
Source: tidal_jobtest
Description: The connection manager "dbserver.database.db_user" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.
End Error
Error: 2007-05-04 09:09:58.06
Code: 0xC020801C
Source: Data Flow Task OLE DB Source [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "dbserver.database.db_user" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error
Error: 2007-05-04 09:09:58.06
Code: 0xC004701A
Source: Data Flow Task DTS.Pipeline
Description: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC020801C.
End Error

I have checked the SSIS package properties and the offline mode property is set to false but still i get the same error.

Also Can anyone let me know how to check whether we are using 32bit or 64bit drivers in connection or for dtsexec command

Please help me on this

regards
Prasad