Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it
5 pts.
0
Q:
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it?

Hey i have Zip file which i want to extract using the sql script or using DTS Packages.

and also want to run the Batch file from DTS Packge.

its possible or not ? and yes then how ?
ASKED: Jul 17 2008  8:27 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
DTS includes an object which will run any command line application you tell it. This includes batch files, exe files, etc. It's called the "Execute Process Task". The icon looks kind of like the old Program Manager icon.
Last Answered: Jul 17 2008  8:54 AM GMT by Mrdenny   46795 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Jul 17 2008  8:54AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0