dbTalk Databases Forums  

Import packed data into Sql Server

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


Discuss Import packed data into Sql Server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vivek Jayan
 
Posts: n/a

Default Import packed data into Sql Server - 07-19-2003 , 02:08 AM






How do we deal with packed data while using the DTS import
facitlity. The data provided is a fixed record length flat
file with sepcific record legths packed to reduce data
size. Does Sql Server 2000 offer any utility to unpack
this type of data fiel to import into a table in the
server.
Thnx for your help in advance

Reply With Quote
  #2  
Old   
John Bell
 
Posts: n/a

Default Re: Import packed data into Sql Server - 07-19-2003 , 01:54 PM






Hi

It is not clear how you records are packed, but it may be possible to write
a bespoke active X script transformation that will unpack them.

John

"Vivek Jayan" <jmvivek (AT) hotmail (DOT) com> wrote

Quote:
How do we deal with packed data while using the DTS import
facitlity. The data provided is a fixed record length flat
file with sepcific record legths packed to reduce data
size. Does Sql Server 2000 offer any utility to unpack
this type of data fiel to import into a table in the
server.
Thnx for your help in advance



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.