BUG: DTS Import Wizard goes brain dead with long text record sources -
01-08-2004
, 07:09 PM
We have some 3GB files to import. These are fixed record length,
about 7200 bytes. The wizard will allow us to create additional field
delimeters up to about position 3600. After that it won't do any more
inserting. We tried creating the splitter at UNDER position 3600, and
then dragging it to where we needed, but the side-wise preview scrolls
to 3600, and then jumps back to position 1. If you drag left, it does
not wrap to end, but rather, just stops.
I'm trying to sell the idea of DTS to people involved, but this snafu
out of the start gate is not impressing anyone. The only thing I've
been able to think of to do is to, is have them save their wizard
generated package to VB on disk, and then tweak the VB, and then do
the thing where you change the VB app from a package define / execute
into a package define / save to SQL. Or to write Active Scripts on the
areas that need more break up, and write script code to split these up
more. Both of these seem hoaky, maybe there is a smarter, better way,
to deal with this? If I could resolve it in the Wizard, then the
resultant package would be much more maintainable, and other steps in
tweaking the transformations would go faster.
Thanks for any ideas - Best Regards, Lee Gillie - Spokane WA |