DTS import from zipped flat file

hi there
is it possible to import data from a zipped flat file into a SQL Server 2000
database using DTS in a single step, ie. running the external decompression
application or algorithm, perhaps as a task, from within DTS?
best regards
Loane
In the future you should probably ask DTS questions in the DTS newsgroup to
ensure you get proper attention. But there are plenty of 3rd party tools
that you can use to unzip a file. I see no reason why you can't call one of
them in a task.
Andrew J. Kelly SQL MVP
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eVeNcmiiFHA.3692@.TK2MSFTNGP09.phx.gbl...
> hi there
> is it possible to import data from a zipped flat file into a SQL Server
> 2000 database using DTS in a single step, ie. running the external
> decompression application or algorithm, perhaps as a task, from within
> DTS?
> best regards
> Loane
>