Jon Rauschenberger's Q&A profile
SQL Server Passing data between multiple Data Flows
OK, it's the first of the month...that must mean it's time for another dumb question! I'm trying to "componentize" an SSIS package with multiple Data Flows, and I can't figure out how to get the output of the results from one Data Flow into another. So, for example, at the end of one Data Flow, I have a Recordset destination, and I'm storing that into a variable. But I can't figure out how to access the contents of that variable in the following Data Flow. Can this be done, or am I going about this the wrong way What is the scenario you are trying to enable, Artus The first post in this thr ...Show All
Visual Studio Express Editions SQL Express beginner
I downloaded SQL Express. Would like to start learning it in order to access a client's SQL files. The only new option on Start/All Programs is SQL Server 2005, which gives me configuration tools. Would l ike to starty by creating a sample table to work on, but there does not appear to be any interface that I can find. Is there a beginner doc avaialble on the web that steps a novice thru getting started creating and using tables in SQL format using SQL Express that someone could recommend Thanks in advance. I would do a quick search through the MSDN Library, Writing SQL Queries: L ...Show All
.NET Development Problem inserting small date time in a sql server database
Hi, I have a cell in a sql server database that is off datatype smalldatetime. I am trying to pass in the value of todays date in a sql insert command but I keep getting the error "The conversion of char data type to smalldatetime data type in an out-of-range smalldatetime value" Below is my code(C#) DateTime TodayDate = DateTime .Today; int Num = 1; string text = "Test" ; //To test that the insert works fine SqlDataSource1.SelectCommand = "INSERT INTO Weekly_DB (Gen_Desc,Date ) VALUES ('" + text + "', '" + TodayDate.ToShortDateString() + " ')" ; } Can any ...Show All
Visual Basic Unable to read the project file...
This is "information" after last close of my project: --------------------------- Microsoft Visual Basic 2005 Express Edition Beta --------------------------- Unable to read the project file 'RoDanSolution.vbproj'. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.Common.targets: The imported project file could not be loaded. Root element is missing. I can`t make my project again... Thanks... ...Show All
Visual Studio Team System Beta 3 - Can't create a project
After installing TFS on single server (which has much improved). I now have the problem that I can't create a project (indpendend of the process type) I get the following error message in VS.NET. I've installed it twice without luck. Any idea Thanks Michael 9/25/2005 11:47:12 AM | Module: Wizard | Retrieved IAuthorizationService proxy | Completion time: 0 seconds 9/25/2005 11:47:12 AM | Module: Wizard | TF30227: Project creation permissions retrieved | Completion time: 0 seconds 9/25/2005 11:47:12 AM | Module: ELeadServiceMediator | Team Foundation Server proxy retrieved | Completion time: 0 seconds 9/25/2005 11:47:12 AM | Module: ELeadSer ...Show All
Visual C++ A doubt in VC++.net
hi, I have a doubt in VC++.NET's IJW feature. If we compile an existing VC++ 6.0 application inVC++.NET, almost (with slight code changes may be) it works. Even if the application contains objects from MFC or others, this technique works. I need to know 1. whether these will run under .NET CLR or not. 2. what is .NET's role & contribution to these application. will they still use older dlls 3. if i ship these application to a system where only the .net framework is installed, will they work Please make me clear thanks, 1) If all you have done is recompile that application then it won't run under the CLR: i ...Show All
Visual C++ I'm stuck and cunfused. ARR U C++!
ok. i made a small ...small SMALL msdos program with Visual C++ express (yep a newbie) and all it was, was a whats ur name age and if u like this kind of music or game. now i figured out the whole press one if u like this or press 2 for no. but i want to make it a says YES FOR YES! and so on. get it good. here's my code. im really stuck #include <iostream> using namespace std; int main() { int number; /* This describes the number int. */ char conversation1[256]; int halo; char variable = 2; char option; cout << "Welcome To the computer talking program.\n"; cout << & ...Show All
Smart Device Development How can I place TOOLBAR on top?
I try to place TOOLBAR on top or right with .netcf, but I can not do that . thank your help! Sorry. The correct url is: http://msdn.microsoft.com/library/ url=/library/en-us/dnnetcomp/html/ImageButton.asp frame=true ...Show All
Software Development for Windows Vista Dynamically seting state in statemachine workflow
Also is there any way to set a state dynamically I tried SetState ss = new SetState("StateName") ss.TargetState = "ExistingStateName" but it doesnot work. Isn't there a way I can change a state of a workflow programmatically I would assume so, becuase using the SetStateActivity isn't anything else. I would like to change the state of a state machine workflow from StateA to StateB within the code of the Workflow. Is this possible Which other possibilities are there Thank you ---------------------- EDIT: I once again posted to early. There is a way. I use a v ...Show All
Visual Studio 2008 (Pre-release) Why I can't Create the multi-layout Template
in Expression jan CTP I want to make my template and style for a button,like this tutorial http://spaces.msn.com/viliescu/PersonalSpace.aspx but in template edit ,When I doubleclick the Grid from Library ,Is working a grid in my timeline below Template,when I doubleclick another Icon in Library plane,like ContentPresenter...the new element will cover with the Grid in stage so i can't put more element in stage:( Who know about this After you insert a Grid from the Library palette inside the template, make it active by double clicking in the timeline (you will see a yellow highlighting adorner for the elemen ...Show All
Windows Forms MDI Child Forms Redrawing
Hello all, I have an application which uses an MDI structure with several child forms which are called up and displayed within the MainMDi form. The child forms are set to have no FormBorderStyle so to the user they appear as part of the main form. The trouble is, when navigating from one child form to the next, I can see the child form star ...Show All
SQL Server Report Model as datasource in ordinary report
I think the report model concept is great and it works well for the report builder. Can a report model or a data source view be used as a datasource for ordinary reports We have a large number of reports built upon complex relational queries (join join join join...), but pretty much the same query for all the reports. One way of solving this is by building an olap cube, but the thing is that all this reports are automaticly genererated from a "backroom" database for quality checking and then all the data is loaded into a final datawarehouse. But maybe it's possibel to do this without a cube in the backroom. ...Show All
.NET Development Mutex could not be created
Does any one know problem behind this I just closed Visual Studio editor and restarted IIS once. And its started working. HTH. Raj ...Show All
Windows Forms Programmatically creating files for use by separate application
Dear forum, How do I create a file in .Net, and then 'release' it so that another application can use it I am creating an application that involves programmatically creating a directory structure containing a number of text files. Once the files are created, I programmatically use the DTS (Data Transformation Services) object model to fireup DTS packages which insert data into the files. But the DTS packages are getting an error - the file is in use by another application...which is presumably the .Net application that is creating the files. I am really stuck on this one, a bit of a novice with System.IO. Any help will be much ap ...Show All
Smart Device Development SQLite and Compilation for Different Environments
I want to run SQLite on my PPCs for an app I am building. I want to be able to have 2 versions. 1 for all arm processors 1 for all x86 emulators If I compile a C++ app in Visual Tools 2003 for a 2002 device, will this app/should this app port accross all devices with a similar processor regardless of PPC version (ie: 2003-Mobile etc) Thanks! InquiringMinds wrote: If I compile a C++ app in Visual Tools 2003 for a 2002 device, will this app/should this app port accross all devices with a similar processor regardless of PPC version (ie: 2003-Mobile etc) Yes, it should work. Where do you download sq ...Show All
