I have the retreival and import all completed, just can't get the unzipping to work.General Info:SQL Server 2000 (SP2) running on Windows 2kUsing WinZip Command line add-on (fully licensed)When I execute the following command from the Command prompt, it functions properly, running for about 5 secconds.C:\wzunzip.exe -o E:\Db\TechData\Delta\datapaqpro_delta_20030922.zipWhen I execute the same command using the extended stored proc xp_cmdshell - it does not finish, just hangs there:EXEC master.xp_cmdshell 'C:\wzunzip.exe -o E:\Db\TechData\Delta\datapaqpro_delta_20030922.zip'I have tried everything that I can think of. Ultimately, the goal is to unzip the file as part of a DTS package which retreives file, unzips the text files and imports them. I am trying to unzip a file using xp_cmdshell and it seems to run indefinately. Import/Export (DTS) and Replication (2000) We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |