Table not displayed when selecting as an OLE DB Destination

Question

Post reply

Table not displayed when selecting as an OLE DB Destination

Welsh Corgi

SSC Guru

Points: 116520
More actions
June 3, 2016 at 6:55 am

#311041

I have a Table that is not displayed when selecting as an OLE DB Destination.
The table exist. I can select on it.
I do not get it.:crazy:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I created a new OLE DB Destination and the table appeared.

Weird.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

FridayNightGiant SSCertifiable Points: 7151 More actions · Answer 2

Right click on the package and select view code. Look under DTS:ConnectionManagers at the one that works and the one that doesn't and compare the differences.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I got the same problem on a different table however when I create a new OLD DB Destination the table does not appear when I attempt to select it.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I ran the Import Wizard and I saved the SSIS Package.

It did not allow me to unselect the Create Table.

So I deleted it.

Then I tried to map the destination and I get an error invalid object.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I recreated the table and it worked.:crazy:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/