Zamial's Q&A profile

• SQL Server How can I output subset of a table to a flat file in SSIS?

  Hi All, I have a table A. I need output subset of a table A to a flat file using query, like: select A.* from A inner join B on... ..... inner join C......where left(A.id, 3) = B.sid.... AND B.num between 100 and 200). How can I do this in SSIS Which data flow item I may need Thanks   SSISy Boy wrote: Well there are several ways you could approach this. One possibility is to use a "Data Reader Source" item. In the Advanced Editor of this item, under the Component Properties tab, you may specify a SqlCommand. Another possible way is to use the "OLE DB Source" item. Double click the item to view the "OLE DB Source editor". Change th ...Show All

• SQL Server Multi-value parameters returning 'ALL' or an itemized list

  I work in the Data Warehouse where like in most large companies we run very long and complex SQL with lots of data in parameters are datasets. Due to the nature of our SQL I need our multi-valued parameters to return (something along the lines of...) ‘ALL’ if all values are chosen or an itemized list (as it already does) only if not all values were selected. The SQL would look like this... where ‘ALL’ in (@PARAMATER_NAME) or table.field in (@PARAMETER_NAME) I can not seem to find anything about this online, which I would assume is a very common issue. Can anyone help me with functionality I had also thought of ‘UNION’ing in ‘ALL” and from what I read online it was a ...Show All

• Visual Studio 2008 (Pre-release) WPF is Gold

  Runtime: http://www.microsoft.com/downloads/details.aspx FamilyID=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en SDK: http://www.microsoft.com/downloads/details.aspx FamilyID=7614FE22-8A64-4DFB-AA0C-DB53035F40A0&displaylang=en VS Extensions November CTP: http://www.microsoft.com/downloads/details.aspx FamilyID=F54F5537-CC86-4BF5-AE44-F5A1E805680D&displaylang=en - Doug In the description for the November CTP is the following: "This is the last release of this technology that will be in the form of a set of extensions for Visual Studio 2005. Any new technology in this space will be included in CTPs of the next full version of Visual Studio which is currently code named “Orcas ...Show All

• SQL Server Invalid Descriptor Index error

  I'm testing db to db transactional replication on a box ( all on the same box ) and the distribution agent fails with the above error. I know it's something to do with the physical server as this test works on other servers fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered ) Server and Agent accounts are in local admins, tried push and pull, named and anonymous. Replication also fails if I use the default snapshot location. I suspect policy restrictions ( maybe on the sql service accounts ) Any pointers would be helpful - there are no errors other than above, sadly. in my case I couldn't apply the sp so I just moved the files. Thanks for clarifying the point Greg. Still sort of worrying about the SP ...Show All

• SQL Server SQL Server 2005 Service Pack 2 -- Now Available

  SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ I read that there is a post sp-2 hotfix to apply and that the sp-2 files on MS site will be ammended for this hotfix. Any idea where to get the hotfix We've applied sp-2 and even though we are not in production yet, ...Show All

• Visual Studio 2008 (Pre-release) WCF can't communicate with WSUS 3.0

  I've developed a WCF service to communicate with a WSUS server. Connecting locally via GetUpdateServer() works great; but when I try to communicate with a remote server, it fails. I tried to ask the WSUS group if they could help, but I don't think any of them were familiar enough with WCF...so, I'm asking for help here. This is the error I am receiving: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) at System.Net.ServicePoint.ConnectSocketIn ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem after collision

  hello all..   i do a collision check..   this is working..   if a collision is detects the movement stops...   but how can i reactivate the movement (after changing the direction of my vehicle - because the bounding boxes still collide )   can you give me an advice please.. here comes the code   public void UpdateVorwarts( Spieler _Spieler, float _SpeedVor) { _Spieler.Aktiv.BoundBox = new BoundingBox ( new Vector3 (_Spieler.Aktiv.FzgWorldPos.X, _Spieler.Aktiv.FzgWorldPos.Y, 0), new Vector3 (_Spieler.Aktiv.FzgWorldPos.X + 48, _Spieler.Aktiv.FzgWorldPos.Y + 48, 0)); Boolean AllowMovement = true ; foreach ( Fahrzeug Obj in Game1 . ...Show All

• Internet Explorer Development IE7 FTP Security Issue

  I have run into a security hole in my ftp site that has only now become a problem with IE7. The structure of my ftp directory involes several streaming media folders and a Client folder in the root directory. The contents of the client folder and its children are all password protected. Inside these folders I upload content for my clients to view approvals and allow them to upload files for my own use. The root directory has read-only permissions for everybody because of the streaming content I am hosting. In the past when a client logs into their ftp folder, the password protected nature of the client folder prevents them from moving up in the hierarchy outside of their folder. In IE7 however, I have found that a client can now leave he ...Show All

• Visual Studio 2008 (Pre-release) Skinning a ScrollViewer (How do I create a custom ControlTemplate)

  I'm creating a custom control templates for all of the controls in an app I'm developing to give a custom look and feel. However, I'm stumped on the ScrollViewer. When I have a ListBox or some other control that uses a ScrollViewer and both scrollbars are visible, I can't figure out how to change the color or behavior of the gray box in the bottom right corner where neither of the scrollbars extend into. Anyone have any ideas Shawn Van Ness has an example scrollviewer template with the vertical ScrollBar on the left: http://www.windojitsu.com/blog/leftiescrollviewer.html The one pixel border is probably a bug. The WPF controls should match the native versions but they are not pixel perfect because the ...Show All

• SQL Server Database Attachment Security!

  Hello I'm using sql server 2005 express edition. I had so security problems that i got helps from this forum. Now i have another one : In my system i'm using a database with sa password, it means to login and work with database structure and data user should enter sa password. But when i deAttach db and transfer it to another computer, I can easily attach db to customers sql server without knowing sa password. I want to say : Everybody can attach my db to their system without knowing sa password and without need to create user, I need security in customer side not at mine. Please help me what's wrong I know there is a solution that i don't know! Thank you for helping me. Hello Thank y ...Show All

• Windows Live Developer Forums onmousemove callback and dragging

  I am currently trying to make so I can essential drag and drop pushpins around on the map but I am running into issues with getting the onmousemove callback to work while over the map. I've tried document.onmousemove=mousemove; and map.AttachEvent("onmousemove",mousemove); It does make the callback on areas outside the map just not on the map itself. Has anyone had any success with this Thanks, I had found a solution same type of thing but you can actually just put the onmousemove call back on the div you are inserting the map into so you dont have to worry about if you are on the map or not. <div id="map" onmousemove="OnMove();"> ...Show All

• SQL Server Need help importing excel

  Hello, I am very new to sql server 2005, and i wanted to know if anyone can help me in creating a SSIS packge that can do the following: 1. Import an excel sheet 2. Delete uneeded columns 3. Merge two fields together, only if first column is not null, and if it is null delete that record. 4. Dedupe records 5. export into dbf format 6. If possible, records that get exported get marked as exported in database . Any help would be very much appreciated. hello, first you'd need a Data Flow Task where you to add an Excel Source from Data Flow Sources. Could you explain if it's really necesary to eliminate some columns , you could use a sql statement filtering only data you need. Next, you may use sql joins amon ...Show All

• SQL Server SQL Server 2005 (2153) AV and down on SP prepare (recompile)!

  How I can resolve this problem ===================================================================== BugCheck Dump ===================================================================== This file is generated by Microsoft SQL Server version 9.00.2153.00 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request. ...Show All

• Visual Basic Help with Windows API for a button

  Ok, so i have the handle of the button i want to press on another applications window. I have managed to call BM_Click and it clicks the button. But is there a way to send a message to that button so it just excutes its code Instead of seeing the button actually click I am not sure if this is what you are wanting to do, but this code is an example of how to make one control, run a second control: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Button1.PerformClick() End Sub ...Show All

• Windows Live Developer Forums zoom and scroll issue in firefox

  Hi, When using firefox 2.0, zooming the map using the mouse wheel moves the page at the same time. Is there a workaround or solution for this issue Interesting, I'll have to read up on dojo. We simply don't use scrollbars, I turn them off completely and make everything resize to be 100%. http://www.viavirtualearth.com/wiki/fullscreen.ashx John. ...Show All