chris.stuart (10/21/2010)
When you select the table to be populated in the drop down list in the OLE Destination component, you have the "Name of the table or the view:", you get the owner of the table and the table name i.e. dbo.table1.
You misunderstand the situation. I'm not using an OLE DB Destination component. I'm not even in Data Flow at all. I'm using the Bulk Insert Task inside the Control Flow screen.
Bulk Insert Task has 4 tabs. General, Connection, Options, Expressions. Under Connection, it has Connection (for connection manager), DestinationTable (drop down list for the tables in the connection), Format, RowDelimiter, ColumnDelimeter, and SourceConnection/File.
chris.stuart (10/21/2010)
Manually go to the dtsx package and search for the entry dbo.table1 and add the database name to it as well...When you go to the OLE Destination again, it will show the database, owner & table. This should sort out our problem.
PS, you will not be able to select the table again from the drop down box as it will only populate it again with the owner & table name which will fail again.
Not that it matters, but for future reference, I'm not sure I understand this last bit. "Manually go into the dtsx package?" I'm already in BIDS. If that isn't manually in the package, what is? Always remember to give more details on directions like this when answering other people's questions. It's too generic to give them something to google on.