View Complete Post
Is it possible to script adding a sql agent job for an SSIS package that uses one or more configuration files? I've spent the better part of the day searching forums and blogs for any examples, but all I can find is just default TSQL or stored proc
jobs. I have most of the script written to pull the appropriate information in, I just do not see how I can specify the configuration files for the job step. And yes, I've even tried going through Visual Studio accessing that api to see if i can
dig out the appropriate object/property to no avail...
Any help would be incredibly appreciated as this would make a huge step forward for our deployment process :)
---- UPDATE ----
I know this sounds odd, but I'm mostly asking because I can't even access a sql 2008 server right now to see what gets put into the step normally for the SSIS Package..I'm assuming all it's really doing in that step is a dtsexec with the appropriate switches,
if this is the case, then I can probably just build the command out to pass in multiple configurations...?
I have a user control that I place on a page severl times. When I make a selection on a ddl in one one control the SelectedIndexChanged event fires for all the control on the page for that ddl. So I get duplication of an insert that I do. Is there a way to make sure these events are isolated so this doesn't happen.
Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application
I selected umbraco cms and got this wizard:
I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.
I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.
My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?
Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.
I recently upgraded to VS 2010 and downgraded to SQL Server 2005. Now when I go Website > ASP.NET Configuration nothing happens.
It's likely this has to do with the fact that when I was installing SQL Server I got the 'ASP.net Version Registration requirement' warning, as well as the 'Failed to find the ASP.net Version Registration requirement with MS IIS'.
Anyone know what I need to get ASP.NET Configuration working?
To my displeasure I cannot find VWD2005 which at one time would generate a complete web.config for Ajax so I downloaded and installed VWDE 2010 to a clean install of XP Pro.
I've created a new tab on the toolbar for the controls but after I select the Ajax dll to add the controls to the toolbar it grinds away and then goes poof and closes down the task leaving VWD look as if I had never even created the tab in the toolbar.
Any advice here?
which edition of sql server are best for me Developer edition or express editon for development purpose.
i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.
I'm trying to test calling a webservice, I've found several free ones on http://webserviceshare.com, but none of them work for me. Some of them give example calling code in C# which I've translated to VB.NET, they're typically just two to four lines, I don't think I've translated them incorrectly.
On that I've tried is US Zip Validator. I added a Service Reference to http://www.webservicemart.com/uszip.asmx?WSDL, called ZipService.
I then call it like so:
Dim myZipService As ZipService.USZipSoapClient = New ZipService.USZipSoapClient() Dim myCity As String = myZipService.ValidateZip("27707")
I get the following error on the first line of code:
"An endpoint configuration section for contract 'ZipService.USZipSoap' could not be loaded because more than one endpoint configuration for that contract was found. Please indicate the preferred endpoint configuration section by name."
A page with information on this web service (including C# source code) is at:
Im trying to create a Web Deployment Project, the built in setup and deployment is very good in Visual Studio, i need to able to add an additional step in the setup to change the connection string in the Web config file. Ive seen a lot of articles on how to do this and in particular this http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx#7162670 I am however stuck on the final part of this tutorial, im using the code Scott provided but have two errors, heres part of my code where the errors are
void ConfigureDatabase(string targetSite, string targetVDir, string connectionString)
// Retrieve "Friendly Site Name" from IIS for TargetSite
DirectoryEntry entry = new DirectoryEntry("IIS://LocalHost/" + targetSit
Hi guys really new to ASP.NET I was trying to install the CSS Friendly control adapter but for some reason the instructions on the website seems outdated. I downloaded all the files (Source Code, DLL, Browser) I believe I need to add the DLL file to my website's Bin folder and the Browser file to the APP_Browsers folder is this correct? After I place this files how to I get it working? what do I have to do? Also if I want to create a new DLL file from the Source code how do I do these? I opened the web-site with Visual Studio 2008 and I can see all the files in the solution explorer? But how do I compile this to a DLL file? I tried doing a build solution but all I get is an .sln file???
Any help would be greatly appreciated
Thanks in advance
We look at some techniques you can adopt to reduce the amount of housekeeping code you write so you can focus on the essence of the application.
MSDN Magazine February 2009
Because Virtual Server is built upon a set of COM modules, you can automate the creation and testing of virtual machines. Here we use Windows PowerShell to run the tests.
Dr. James McCaffrey and Paul Despe
MSDN Magazine December 2008
This time James McCaffrey sets up a virtual environment to use for configuration testing to introduce you to software configuration testing with Microsoft Virtual Server
Dr. James McCaffrey
MSDN Magazine September 2008
Stanley B. Lippman explores the use of C++/CLI as a pure Microsoft .NET Framework-compliant language.
Stanley B. Lippman
MSDN Magazine August 2007
There are a number of ways to configure an application in the .NET Framework 2.0. This article explores the classes of the revamped System.Configuration namespace and explains how to use XML configuration files for your app configuration settings.
MSDN Magazine June 2006