asked on

SSIS OLEDB Destination using old table name

I have Data flow Task getting data from one table and putting in another.

The destination table was renamed and even though I have changed the task to reference the new table name, when I try to run the task it fails with invalid object name and shows the original table name.

I have searched the code behind and cannot see the old table name referenced anywhere.

Where else can it be stored?

SOLUTION

Jim Horn

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

edtechdba

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

BrianFord

ASKER

Thanks jimhorn, I'm not actually changing connections at runtime and the destination table does exist. The package worked just fine but the table was subsequently renamed (outside of SSIS), and even though I have update the task for the new name it's still looking for the old one.

edtechdba: I tried as you suggested several times but to no avail

I even deleted the entire Data Flow Task and recreated it from scratch but there still seems to be something cached somewhere..

BrianFord

ASKER

I found the solution was to drop and re-create the table itself in SQL Server mngt studio, a bit weird but obviously there was a named cached somewhere and re-creating the table fixed.

Thanks for your input.

edtechdba

How about changing the path in your OLE destination to the absolute table path?
Database.Schema.TableName (instead of TableName)

edtechdba

Never mind, glad you were able to resolve your issue!