Post reply

OLE DB or ODBC error: Login failed for user 'apingali'.; 28000.

  • September 24, 2014 at 11:34 pm

    #311205

    HI,

    I'm getting following error what should i do to resolve this

    A connection could not be made to the data source with the DataSourceID of '6d3822bb-b80f-4a5c-9bce-63d58573ff9c', Name of 'SqlServer 10.73.154.40,1436 DM_1054_ADTUSA'.

    An error occurred while processing table 'V100_HourlyKPI'.

    The current operation was cancelled because another operation in the transaction failed.

    Thanks

  • September 25, 2014 at 3:22 am

    #1748071

    Can you post the code that is being executed and that is generating this error?

    It looks like you execute an action with multiple steps. Somewhere inbetween the connection is lost or can't be made. But without knowing the code it's shooting in the dark.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • September 25, 2014 at 6:46 am

    #1748131

    I would guess that you've deleted the Connection Manager that was used by the OLEDB Source component , or, you've copied the component (or maybe the entire Data Flow Task) from one package to another where the Connection Manager does not exist.

    Regards

    Lempster

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply