Avatar of Chaste Swedge
Chaste Swedge
Flag for United States of America asked on

Any Known Issues with utilizing AppCmd.exe via SSIS to manage Web Sites? What are the best practices?

Are there any known issues with utilizing 'AppCmd.exe' via SSIS to manage Web Sites? What are the best practices? Is WMI safer/better? Can SSIS support functionality with WMI for operations other than 'read'?

Am I merely asking for trouble? The environment is Windows Server 2008, IIS 7 and SQL Server 2008 R2.

Thanks!
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005Microsoft IIS Web Server

Avatar of undefined
Last Comment
Chaste Swedge

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Andrei Fomitchev

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Reza Rad

could you explain exactly what you trying to do?
maybe we find better solution then
Chaste Swedge

ASKER
Hello,

Hello to you reza_rad and thank you formand.

I haven't had time to research the WMI documentation, but I will shortly. In the list above formand, I do not see a command to add a virtual directory, which with AppCmd would be 'appcmd add vdir /app.name:string/ /path:string /physicalPath:string'. I would hope that this would be contained in WMI, but I have to check.

For you reza_rad, here is what I am thinking of doing:

1. FTP Data

 I have a vast array off HTML data and client/javascript in an FTP directory that is dumped each night. I've written several routines that figure out dates, titles, etc. of each of the directories, subdirectories and index HTML pages that are published to put into controls in .NET. Because the data at this FTP site is constantly changing, and because I do NOT want to have to publish 100's of mb of data whenever I move the application from DEV, to TEST, to STAGING and then to PROD, I was experimenting with creating a virtual directory to hold the pointer/reference to this FTP folder. Of course, since the contents of this directory changes each day, I must update the Virtual DIrectory to make sure that all new content is present.

 

2. Options

I see that I have one primary option, and please add as many others as you like. I could utilize SSIS to create the virtual directory at a given time each day/night immediately following the publish of the new data to the FTP site. Another option would be to create a separate website on the local IIS instance, and have THAT website point to the FTP directory. This would seem to be an easier path, but I suspect there would be issues when the content of the FTP directory changed each day. Also, this ties me to having the FTP site and the Web Site on the same machine, as when on different machines there are security issues with cross-domain/cross-machine browsing and linking the physical location of a local website to a foreign machine.

Any thoughts would be appreciated for either of you. Thanks!

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes