Table does not exists Error

• SQL.AP

  Hall of Fame

  Points: 3304

  More actions

  May 7, 2015 at 5:33 am

  #317933

  Hi All,

  I have one stage table and one main table.

  I am loading data from a source server to the stage table first and then using a DFT to load data from stage table to main table.

  Data is around - 120 million

  When I am executing my package, the stage table gets loaded but when it comes to the DFT loading data from Stage to Main table, SSIS throws an error - "Source table does not exist".

  I am not sure why I am getting this error.

  All connections are in place and everything looks fine. But after loading data into this table SSIS fails.

  Please help.

  ____________________________________________________________

  AP

• Lempster

  SSCoach

  Points: 15651

  More actions

  May 7, 2015 at 7:05 am

  #1796201

  What have you got set in your OLEDB source?

  Regards

  Lempster

• SQL.AP

  Hall of Fame

  Points: 3304

  More actions

  May 7, 2015 at 7:12 am

  #1796202

  Step 1 - Load data from Source to Stage Table

  Step 2 - Stage table to Main table (I am directly using the stage table in OLEDB source)

  ____________________________________________________________

  AP

• Lempster

  SSCoach

  Points: 15651

  More actions

  May 8, 2015 at 10:33 am

  #1796653

  Are you sure that your OLE DB Source in Step 2 is using the right Connection Manager? The error message seems very clear.

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  May 11, 2015 at 3:00 am

  #1796891

  I think you dropping an creating the table at every run , and you probably missing the table creation step

• SQL.AP

  Hall of Fame

  Points: 3304

  More actions

  May 11, 2015 at 11:25 pm

  #1797145

  Thanks for you help.

  I was not creating or dropping table in the SSIS package.

  Issue was - while loading the table, due to large amount of data table was getting locked and in the next step OLEDB source was throwing this error. Not sure why.

  I tried using the query instead of directly using the table -

  Select * from <TableName> WITH(NOLOCK)

  and it worked.

  ____________________________________________________________

  AP