wencey's Q&A profile

• SQL Server DTS Packages Unspecified Error

  WE have dts packages created with ftp component in Sql 2000 dts designer. At the same time client where we are developing the package has sql 2005 components. When we move this package to sql 2000 production server - we can execute nor we can open the package it will give unspecified error. if we recreate the package on client which does not have sql 2005 component than only it works. So for any mistake the packge once opened in sql 2000 designer also with client having sql 2005 components it does not work. Only criteria this error happens when you have ftp component used in dts package. Did anyone has seen this problem Any fixes or patches available to be applied Thanks for the help. Manoj Hi Microsoft already kn ...Show All

• SQL Server Column format in Destionation Excel file

  Hello, I have an SSIS package that basically runs a query and exports to an Excel destination. Everything works fine except for a date field that I use. When I preview the export it the date looks fine, as in a 1/7/07 2:05 PM for example. However, when I look at the actual Excel file/Export it will list the date as 1/7/07 without the time. I then have to format the column to the right date format in Excel for it to display correctly. I want to prevent the manual formatting due to the fact that this file needs to be automated. Is there any way to make this happen Thanks, Marco I don't know if this would actually work; but you could create an empty excel file with the formatting you want; then ...Show All

• SQL Server Save some Stored proc in file and create SP from file

  Every day we are restoring prod DB in Development env. I need to save before restore users stored proc, restore DB and after create SP from file. Thanks. The command-line tools may not be adequate because the defaults do not suffice if your definitions are larger than say 8000 characters. And it will be a pain to automate the scripting of multiple objects and so on. Best is to use SQL-DMO/SMO or DTS/SSIS tasks for this. ...Show All

• Software Development for Windows Vista Imapi2 on Vista RC1

  My builds are now broken on the SDK (which is now at version 6 ! !) that matches Vista RC1. http://www.microsoft.com/downloads/details.aspx FamilyId=117ECFD3-98AD-4D67-87D2-E95A8407FA86&displaylang=en Anyone know what is going on I don't see the sample code or anything that corresponds to ImapiV2 anymore. This is very confusing :-| I guess I won't be getting much work done this week... I got it now thanks Garrett! Part of the confusion is because (I thought) the SDK versions were supposed to match the major release versions. But apparently the platform sdk that matches RC1 build 5600 is sdk build 5536. ...Show All

• Visual C++ Can SetTimer() (mfc) be used in real-time applications?

  I'm developing a time-series data acquisition system that interfaces with DAQ hardware which reads and generates voltages through it's channels simultaneously. That means that Input (data acquisition) and output (generation) must be done with accurate timing. Unfortunately, the Generation process must be done using software timing (windows timing). So, i declared a SetTimer(TimerID, 1000, TimerProc) so that the callback kicks in at each second. At first, I encountered timing issues that the hardware timed data acquisition was lagging behind generation. I tried redoing that class but then again i tested it to be accurate (i actually used a stopwatch). It was only then that i found out the windows timer had elapsed 3612 seconds after exactly ...Show All

• SQL Server get first row first column value into a variable

  It is my second time on this forum Nice people managed to help me on my first thread. I am encouraged to proceed with you ! Well   I  have an Excel source that returns One row , two columns: what I want is get the value returned in  the first row - first colum into a variable so I can then execute sql tasks based on this filter parameter ! Can you guide me   Regards Jacques   Hi Again Jacques, Here is an entry of a previous post I did (you can read the whole thread at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=736614&SiteID=1 ) ---------------------------------- You may have more than one option here; I would try with a script ta ...Show All

• Visual Studio 2008 (Pre-release) ScrollViewer problem

  Say i want to put a custom style on a scrollviewer How can i find put in xaml if the scrollviewer can scroll left or right I want to disable the scroll buttons if you can't. ...Show All

• Windows Forms acceptbutton -doesn't work when I am in a datagrid

  I have a windows form, where I tab through text boxes... If I am on a text box and hit Enter, the button that the accept button is set for, will work and execute the script. But , when I get to the datagrid, I force the grid to keep the number of rows that are present, and I can tab to each cell ,but I can't tab out of the datagrid. Maybe that is a problem... I tried to do a focus , but didn't work. In either case, the enter key doesn't execute the button script once I enter this grid Does anyone know why this behavior is going on thanks Bev, Trapping keystrokes in Grids is different than in all other controls. Basically, you have to override the ProcessCmdKey method in your DataGri ...Show All

• SQL Server Report Service 2005 with VS.NET 2003 ASP.NET application

  I am very new to reporting services. Can anyone kindly summarise the ways you can access report services report in a VS.NET 2003 web project I can only find crystal report components Thanks in advance Hi, the easiest way is to create a proxy class for RS. You don’t have to do this on your own, simply create a web reference to Reporting Services. In the background the WSDL from the ReportServer is consumed and a proxy class generated. Now, you can use every SOAP API that Report Server offers for rendering the reports, more on that can be found in the tutorials of the BOL. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms Hot Key function for whole program

  Hi all Are there any good examples for a hot key class. I would like to implement hot key functionallity for the whole application I am creating standard text when user presses ALT or CTRL + F-key. Any links / urls you know of Lars E The easiest way is to specify the same key-handler to every textbox you want it to work for. The alternative is to have a "windows wide" hotkey set, then apply it as it works, searching for the active control to put your text into, which I don't think you would like to do. There may be a more messy solution, but i don't know of it. ...Show All

• Software Development for Windows Vista Link2019 for Some Winspool.lib functions but not others

  Hello, I'm using VC++ Express on Vista (build 5600) with Microsoft R Windows R SDK for Beta 2 to create a simple C program using the printing api. When I use the InstallPrinterDriverFromPackage function, I get a LNK2019 message from the compiler, but if I use a different function (e.g. EnumPrinters) everything works fine. When I put the linker in verbose mode, the following output shows that it is searching the winspool.lib lib: Searching C:\Program Files\Microsoft SDKs\Windows\v1.0\Lib\user32.lib: Searching C:\Program Files\Microsoft SDKs\Windows\v1.0\Lib\gdi32.lib: Searching C:\Program Files\Microsoft SDKs\Windows\v1.0\Lib\comdlg32.lib: Finished searching libraries test.obj : error LNK2019: unresolved externa ...Show All

• Visual Studio Express Editions USB port

  Hey guys, I've been searching for a while now about how can i connect to the USB port using C# but i found nothing so if any one here knows how can i do it can he share it with us. Hi, SamuraiJack This thread is on the topic: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=588602&SiteID=1 Thank you ...Show All

• Smart Device Development PDA windows Form

  I need to develop a project which allow to control all the form flowing. Which mean my PDA can handle 2 or more same form at the same time, in my menu bar i can choose to activated the form. My problem is i do not know how to control the form while 2 or more SAME form open and store it into the menu bar. For example Dim NewFrm as frmOrder NewFrm = New frmOrder ' First Form 'Then open the second Form NewFrm = New frmOrder ' Second Form In what method i can create a form in a child so that i can call Either FirstForm or Secod form Dear BrightAngel, When we new a Form instance, we add it into the array. After then, if we want to get it back, we can just use index two fetch its ...Show All

• Visual Studio Express Editions Application settings? How do you load them in other forms?

  I can't find it in MSDN, but I'm trying to load application settings completed and saved in my Prefs form, and I'm trying to get them to load on startup in my Index(startup). Please help! Also, while I'm asking... Private Sub OptionsToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OptionsToolStripMenuItem1.Click If Prefs.CheckBox1.Checked = True Then 'Do nothing ElseIf Prefs.CheckBox1.Checked = False Then Prefs.CheckBox1.Checked = True End If End Sub I can't get this code to change the Prefs. CheckBox to True if it's not true. Help I claim to be no genius, but you're basically reiterating it in the method. It is the same code, just backwards. Also, while you're s ...Show All

• Visual Studio Express Editions DHTML controls

  how do i get the copy, cut and paste controls to work with the DHTML box   We can help you with that and have you editing HTML in as little as ten lines of code........ add a menustrip to code form and add File                 Open   mnuOpen               Save   mnuSave              Close  mnuClose               Exit     mnuExit ** note, these case sensitive names. Be sure to ...Show All