Table does not exist in Copy objects task

I have a SQL2000 database that I need to copy tables from to my SQL2005 database. The table in the 2000 database are owned by a login named tsreader. This login is also in the dbo database role. So, when I access tables I have to prefix tha table name with tsreader. Currently in a SQL2000 database I have DTS packages that pull data over from this database everynight and they work fine. However when I try to do this from SSIS, I get the error "Object does not exist". My assumption is that it is trying to access the database tables as a "select * from tablea" as opposed to "select * from tsreader.tablea".

Any thoughts on how to make this work I know I have the login correct because it is the same one I use for the SQL 2000 packages. Also, in SSIS it allows me to chose the tables I want yet I still get "Table does not exist at source" when I try and execute it.

Any ideas

Thanks,

fjk




Answer this question

Table does not exist in Copy objects task

  • Nick Wang

    Thank you for your response. I was beginning to think I had lost my mind. Is there any known work around with the exception of setting up an data pump for each object separately

  • ptah

    AFAIK, there are no work arounds for this issue.


  • VR6R

    This is a known issue. There is a lot of community interest in getting this fixed. Hopefully the fix will be available soon.


  • Table does not exist in Copy objects task