SSIS package gives work offline error

• Prasad Prabhu

  SSC Veteran

  Points: 209

  More actions

  May 4, 2007 at 5:20 am

  #172237

  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 output

  Code: 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