Mackin, Christopher
CMackin at Quiznos.com
Mon Aug 16 12:07:04 CDT 2004
I've done this via the WinZip Comand Line add-ons http://www.winzip.com/daddons.htm Along with a DTS package in SQL Server. I actually created a batch file to pull the zip files from an FTP site, unzip them and have that batch file called from step 1 of the DTS package. -Chris Mackin -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Monday, August 16, 2004 11:02 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Import comma delimited from zipped files Is there a tool to allow me to import data into SQL Server from a comma delimited file contained in a zip file? John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com