Post reply

Can''t see tables after Data Transformation Sevices

  • March 21, 2006 at 2:59 pm

    #113336

    I created a new database in the SQL Enterprise Manager using the Data Tranformation Services (import data). The data source was from an AS/400 DB2. The destination was local server using the windows authentication. The import worked fine. After the database was created, I tried to view the tables. It tells me that there are no items to show. I know that it created a table. It must be that I should not have used windows authentication when I created it.

    Any suggestions?

  • March 21, 2006 at 3:15 pm

    #627982

    I found the answer by opening the properties on the server icon and changing it to windows authentication I was able to view all of the icons (including tables) within the database.

    I worked on this several hours, and answered my own question minutes after I posted the question.

    Thanks.

  • March 22, 2006 at 12:07 pm

    #628187

    You are not alone .Sometimes simply sharing opens up your mind

     

     

Viewing 3 posts - 1 through 3 (of 3 total)

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