dbTalk Databases Forums  

BUG: DTS Import Wizard goes brain dead with long text record sources

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss BUG: DTS Import Wizard goes brain dead with long text record sources in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lee Gillie
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.