Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 UNZIP a file in a Scheduled DTS Package

Author  Topic 

bmcfarling
Starting Member

1 Post

Posted - 2007-12-18 : 18:51:33
I need to unzip a file in a DTS Package, could someone point me in the right directions. Also it's a self extracting .exe file but WinRar doesn't have a problem just unzipping it. I have very little experience with DTS but, I cant find info on this anywhere on the net.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-18 : 22:29:15
Run dos command in the task, or run it via xp_cmdshell in exec sql task.
Go to Top of Page
   

- Advertisement -