Post reply

where to view of data being importing (flat files)

  • August 23, 2004 at 10:49 am

    #85229

    does any one know where to view of data being importing (flat files)?

  • August 23, 2004 at 11:48 am

    #520214

    First, forgive me - I'm not trying to 'put you down', but your broken english makes it difficult to understand what you want.

    Are you asking where the data is located when you do an import?

    If so, the data is located in the database you imported it into.

    If that's not what you meant, would you please take the time to explain your question/problem better?

    Thanks,

    -SQLBill

  • August 24, 2004 at 7:23 am

    #520317

    What I meant was that; When data is importing from a flat file where would go to view the transaction where the tables and records are being put into what field.  I want exactly see or know did the transaction has taken place wether it pass or fail.

  • August 24, 2004 at 7:38 am

    #520322

    I understand now, thank you.

    You can't view the actual transactions unless you have an application installed that allows you to view the transaction logs. SQL Server doesn't have anything that really lets you do this.

    You can check that the transactions actually happened by checking the database(s) that you imported the data into.

    Was the database empty before the import? If so, is there data in it now? How many rows did you import? How many are in the database?

    If the database was not empty before the import, how many rows were in it before the import? How many rows are in it after the import?

    -SQLBill

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

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