DalekDAW's Q&A profile
SQL Server can't execute tasks after moving .dtsx to new server
Hello. I have two servers, A for dev and B for production. On server A I developed a project containing a SSIS package using SQL Server business intelligence development studio. The package runs fine from the BIDS and also when I save it to SQLServer itself and run it as a scheduled job using the SQLServer Agent. All ready to roll out to Server B I thought, so I then saved the .dtsx file to a shared network drive. On Server B, I created a empty project with the same name as it had on Server A. I then imported the .dtsx file into the project using project > add existing item. The package appeared to import ok but I now cannot execute any of the data flow tasks in isolation. If I right click on them, there is no option to ' ...Show All
.NET Development Using DiffGram to Save and Restore Dataset RowStates, etc.
I want to save a dataset that has been modified to a file as a DiffGram and later restore it in memory, retaining all row changes (rowstate) across sessions. Based on several articles I've read and the MSDN documentation it would seem to be a simple matter of writing the modified DataSet to an XML file using the DiffGram write method, then reading it later from the same file (also with the DiffGram read mode). I'm using the following code: // get the initial dataset DataSet ds = new DataSet ( "ClaimDS" ); SqlConnection sqlConn = new SqlConnection ( "Data Source=mySQLDB;Initial Catalog=myDBName;Integrated Security=True" ); SqlCommand sqlCmd = new SqlCommand ( "kneGetClaim" , sqlCon ...Show All
Visual Studio Express Editions Can't find compiled program
I compiled the Hello World program with no erors, but i can't find the .exe file for the program It's strange I looked in C:\Documents and Settings\Kyle\My Documents\Visual Studio 2005\Projects\Hello World\debug before and it wasn't there, just now I looked again and suddenly it poped up. Well thanks for your time. ...Show All
Game Technologies: DirectX, XNA, XACT, etc. What Is The First Step In Game Development?
Dear, I Decided To Use C# And XNA. Now What I Have To Do Do I Have To Learn Some Books Or What Plz Tell Me. Now that you have GSE (Game Studio Express), I would start looking at the simple tutorials that have started to float around the Net. Some of the sites that you might want to look are... http://xbox360homebrew.com/ http://learnxna.com/ http://www.xnatutorial.com/ http://www.xnadevelopment.com/ This is just a small list to get you started... Also I would start to float around the XNA Groups on this site. ...Show All
Visual Studio Express Editions call event
Does anyone know how to raise an event when the enter key is pressed. be sure that you are using the KeyPress event. If you wanted KeyDown event then the code would be this: if (e.KeyCode == Keys.Enter) //or Keys.Return, whichever key you want to check { //do something } ...Show All
Visual Studio Debugger Does Not Run
I am running Visual Studio 2005. With some projects, when in the Designer mode, I select "Start Debugging". The status bar indicates, Ready, then "Build Started", and then back to designer mode. I can't get it to be in the debug mode (or to get the program to run). There are no compile errors. I can run and debug other programs fine. I can also run and debug this problem program fine on other machines with Visual Studio 2005 and express versions. What is going on with my version of VS In case this is related, on other programs I am writing, when in debug mode, when I am single stepping through the code, if I pause stepping for more than a few moments (less than a minute), the debugging process ...Show All
Visual Studio Team System Changes are not shown in the Form
In my application I do a change of some WorkItem fields. Via the Team Explorer in Visual Studio I want so see the changes of the WorkItem fields. When I select the WorkItem the changes in the Form are not shown. I change another field in the Form and then the next error occurs: "Unable to save all edited documents. 0 saved successfuly. 1 could not be saved. Please correct the unsaved work items and try again." So this means that the changes are committed but are not shown in the Form After about 5 minutes the changes are shown in the Form !! Why does it take so long to show the changes in the Form I closed all open windows in Team Explorer but this doesn't help. Even re-run the quer ...Show All
Visual Studio Team System Failed to create New Team Build Type
Hi, I trye to create a New Team Build Type, but it does not work. An error box is displayed with the next message: "Failed to retrieve data from the server. Please verify that the Team Foundation server is running and try again." But the TFS is running normally, and I work without any problem. I'm using a workgroup version of the TFS, and I'm an administrator of the Server... Can you help me please 17 $\ C:\Company\Projectos\ 1 37 $\Project\ d:\Builds\Project\BuildTest3\Sources\ 1 39 $\Project\ d:\Project Builds\Company.MMIBuild\Project\Company.MMIBuild\Sources\ 1 44 $\Project\ D:\Project Builds\Company.MMIBuild\Project\Company.MMIBuilds\Sources\ 1 47 $\Project\ d:\ProjectBuilds\Company.MMIB ...Show All
Software Development for Windows Vista plzz help me regarding 6.0.6000.0.0.WindowsSDK_Vista_rtm.DVD.Rel.img
hello all i downloaded the 6.0.6000.0.0.WindowsSDK_Vista_rtm.DVD.Rel.img but i am not able to install this i used iso buster but still there is some problem. it says " This disc contains a "UDF" file system and requires an operating system that supports the ISO-13346 "UDF" file system specification." can any one tell me how to install the sdk I assume that you got the message after you tried to "read" the DVD that you created from the .img file. Anyway, I've had some of this problem. First, there is a slight difference (I don't know what) between .img and .iso files, but the .img file you have is the "newer" standard; not every ...Show All
Visual FoxPro query for select limit record from database
hi I have Table with 1000000 records i want to select records like this at first time : first 100 records at second time :second 100 records . . but I don't know how Write Query You can do that in VFP in a lot of ways. SQL: for lnGroup = 1 to reccount('myTable')/100 select * from myTable ; where recno() between (m.lnGroup-1)*100+1 and m.lnGroup*100 ; into cursor crsMyGroup * do something endfor It could also be top N query if you can base it on a key (if VFP9): myKey = '' && if integer myKey = 0 and so on select top 100 from myTable where myKey > m ...Show All
Visual Studio Team System Database Project: "Add Project to Source Control" error
When I try to add my Database Project to Source Control, I get the following message: --------------------------- Microsoft Visual Studio --------------------------- Error TF50322: Unrecognized project name. --------------------------- OK --------------------------- I tried to use different project names, I tried to add the project to Source Control during its creation and after its creation - nothing works. Thank you. Following up on my last response, it will be best if I can fax you the document to sign. Can you please provide a fax number Thank you ...Show All
Visual Basic Run-Time error "5852' requested object not available
We have been having a few issue with out test server and Microsoft patches. Currently we have a production Win 2003 server machine running the application just fine, but after the test server received a patch from Microsoft we started getting a run-time error 5852 requested object not available. Over the past three weeks of so we have rebuilt the server twice tried installing and uninstalling various things, only to get the same error. So I am thinking that we need to find a way to code around this. I get the same run-time error 5852 when we first ran on a new XP server, this was corrected via the following link in MS knowledgebase. This other error we are not able to correct in the same manner. Bot ...Show All
Software Development for Windows Vista Page Limit?
Does anyone know whether there is a page limit in an XPS document I have created a 10,000 page XPS document printed with the Microsoft XPS Document Writer from Crystal Reports XI. I can open this document in the XPS viewer with no problems. However, when I create a 100,000 page document using the same package, the XPS document does not open in the XPS viewer and the memory use on my computer jumps and keeps on rising. I am working on Windows XP. Any ideas, anyone The problem you're experiencing is a bug in the implementation, not the limitation of XPS format itself. This will be considered for a future release. If you're blocked by this issue, try to write or find a tool which can repair ZIP files. ...Show All
.NET Development ReadOuterXml - Pretty Print Problem
Hi, I seem to have a problem wih ReadOuterXml, cause I need it to create a petty printed XML. The file is well-formatted and Valid. ************Snip*********************** Public Sub WriteXML( ByVal BoersenID As Integer , ByVal Boersenname As String ) Dim conn1 As SqlConnection = New SqlConnection() conn1.ConnectionString = "Data Source=localhost;Initial Catalog=openimmo;Integrated Security=True" Dim da As SqlDataAdapter = New SqlDataAdapter() Dim cmd As SqlCommand = New SqlCommand() cmd.CommandText = "Execute prcExportOpenImmo " & BoersenID cmd.CommandType = CommandType.Text cmd.Connection = conn1 conn1.Open() Dim xrdr As Xml.XmlReader = cmd ...Show All
Visual C++ loading dynamically a DLL built with VC++ 6.0 by an an exe file built with Visual Studio 2005
Hi guys Is it possible to load dynamically a dll that has been compiled and linked with VC6.0 by an exe file built by Visual studio 2005 nota: This dll exports only "C" style functions ( no class ) During the tests I've made, it seems that the GetProcAddress function fails to find the exported functions when the exefile and the library where not built with the same VC. any idea Regards You cannot dynamically do so however by PInvoking the DLL in question from a .NET app you can access those functions without the need to rebuild the old DLL by coding specific calls to the DLL prior to build time of your .NET app. ...Show All
