Table does not exists Error

Question

Post reply

Table does not exists Error

SQL.AP

Hall of Fame

Points: 3244
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

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lempster SSCoach Points: 15651 More actions · Answer 1

What have you got set in your OLEDB source?

Regards

Lempster

SQL.AP Hall of Fame Points: 3244 More actions · Answer 2

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 · Answer 3

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 · Answer 4

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: 3244 More actions · Answer 5

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