View Complete Post
Not sure if this is the right place to ask but I'll try...
I have to execute an integration service package in an .adp project. In other words, click of the button on the adp window has to start a package or a job.
Can that be done? And if yes, how? I've been searching the Web but without success.
Thanks for your help.
this is an issue regarfding the SQL Severe Integration Services
I have installed the Business Intelligence Studio through SQLEXPR_TOOLKIT.EXE
but the problem is when i am trying to create the SSIS Project it is not showing the SSIS Project Templates in BID .
I have try to change the location of Templates in Tools --> Option --> project & Solution but the still the problem is same
Thanks in Advance
I'm planning to develop a new SSIS project where I have a data in a table (Raw form) and I want to put into our production database. I just want to start with a test project and if you provide me little inside that will be helpful.
Here is what I'm trying to do
Typical order table (Order Header and Order Detail)
Temporary table with raw data which need to import in Order Table.
Order Header contains auto increment primary key which needs to be in order details table. So how should I develop a project where I go thru each record of temp table, write a record in order table, get order id (pk) and write data in order detail table.
Hope it is very much clear.
Hopefully I will get expert advice soon.
Thanks in advance,
Trying to remote debug ASP website from VS2010 Pro to Windows Server 2003 machine. Specifically, trying to debug a Web Service, but breakpoint says, "The breakpoint will not currently be hit. No symbols have been loaded for this document." This happens for all compiled code though. I have read this is due to missing PDB files and the work around is to manually copy them, as noted here. Problem is, I cannot find any PDB files for my project, except referenced libraries, which I can remote debug.
This is beyond frustrating. I migrated my code from VS2008 .Net3.5 to VS2010 .Net4.0 to take advantage of the inherent multithreading framework. Debugging works when using local host and was stable until deployment to test server.
Seems like a stupid question, but I will go to Build > Build Solution many many times and the build will succeed many many times, then I will put in a minor syntax error and the build will fail, BUT the build will not fail because of the minor syntax error; it will fail because of an unresolved type that I put in about twenty compiles ago. And then I will fix the minor syntax eror, and the compiler will still complain about the unresolved type. Here is my code:
<%@ Register TagPrefix="FTB" Namespace="FreeTextBoxControls" Assembly="FreeTextBox" %><html><body> <form runat="server"> Hello World!! </form></body></html>
Pretty simple, really. I go to Buld > Build WebApplication1 and it runs OK. Now, if I put in a minor syntax error, such as substitute "forrrrrrrm" for "form" and then try to Build Solution, it complains not about the misspelled word, but about the FreeTextBox. And then if I correct the misspelled wird, it still complains about the FreeTextBox. Which leads me to believe that Building the Solution does not check absolutely 100% everything that needs to be checked. Is there a more thorough way of compiling a program that I need to use?
is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem
I wonder how to add a project template called Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?
Hello, I am working in a aspx web application that must be built in several separate "modules" with different functionality which will be partly developed by different teams.
However, I need the completed app to reside in ONE virtual directory. There will be a single startup page. I need session state to be preserved across pages in different modules.
I structured it as one solution with different Web Projects and one class library project with common functionalities.
1) is this the right approach to do this? Or which one would be better?
2) each time I add a new web project to the solution, a new web.config gets created. What do I do and where do I put them?
VS 2010 + framework 4.0 + TFS
Regarding TFS and source control, I have a single Team project, the solution and web projects are inside it.
I am using VS2005.
I don't have much experience with web setup projects, but I now need to create a decent windows installer in order to allow customers to install one of our web applications. I have created a simple web setup project and it works fine, but not when it comes to upgrades of the application.
If for instance I install version 1.0 on a machine, and then later I try to install version 2.0, I don't seem to have the control that I would like... I can specify in the web setup project that the installer must enforce an uninstall of previous version, but then all application files and logs are uninstalled as well. If I let the application just install itself over the older version, it seems to leave some old DLL's there - it then causes issues in the application because DLL version conflicts.
My basic requirement is that I would like th installer to upgrade the old version with all the files required, but leave any application and log files in tact - this way the customer won't have to reconfigure the application after install.
What is the best way to handle this?
We have several .NET based products for which we need to generate multiple MSI files to allow for multiple instances of the same app to be installed on the same machine. For instance, we might have a single server running version of the app that are pointed at either test or QA databases, or may use the same server box to deploy the product for multuple clients. (So, for instance, our web server might have separate installs of the same code in different locations for product names "Client A test", "Client A QA", "Client B Test", etc., where the only real differences are in the web.cionfig files that are not overwritten by the install of a new version.)
Right now we simply have a deployment project for each named variation of the app. This works, but is likely to become a maintenance mess as the number of instances grows. We'd like to be able to maintain only a single deployment project and script the creation of multiple MSIs, one for each product variation, after the build of a baseline MSI.
As I understand it, this should be acheivable by building the MSI, then for each possible instance, making a copy of the MSI and giving it a unique ProductCode and PackageCode; this way Windows should recognize each instance as a unique application. I've done this (as well as changing the produc