Comparison finished (data) locked

RBoydRBoyd Posts: 2
edited January 12, 2005 8:09AM in SQL Packager Previous Versions
Creating a new package which includes data. the Wizard seems to run fine and progress bar shows the data being packaged. Then the Comparison finished (data) dialog appears estimated time is 0 and it justs sits there looking at me.
Some of the tables do contain a lot of rows 100k is the dialog not reflecting the actual progress of the data import?

The only option is to kill SQL packager using task manager.

Any suggestions? Can I log the progress of the package creation?

Thanks

Richard
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    Sorry about the delay in answering. There isn't a way to enable logging in SQL Packager, but have you tried using SQL Profiler? It's probably the next best thing because it will show all of the queries being run by the application and how much data was sent back as a result.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Richard,

    SQL Packager may be having some trouble writing temporary files. The presence of .net Framework 2.0 seems to cause Packager to allocate temporary filenames that already exist (this is out of Packager's control; it's the Windows API that assigns temporary file names!).

    Maybe it will help to run Windows Disk Cleanup and have it delete all of your temporary files.
    · Share on Twitter
This discussion has been closed.