Answer Questions

• beN! Ssimple Data Flow ? - processing after using a Destination

  I have a data flow that reads multiple rows from a table and then inserts to another table for each row. I use an ole destination for my inserts. However, after that insert I need to do other table inserts and I can't figure out how to continue the data flow with the fields in the pipeline. Out of the destination is only the Error flow - Is there a way to do this thx Have a look at the Multicast transformation. -Jamie ...Show All

• Scott Lock Compilation/sec is more on production where recompilation / sec is zero

  Hi Team, Our production Environment is SQL server 2000 with SP3. I noticed lot of compilation/sec (where recompilation/sec is closed to ZERO). I know every stored procedure will get compiled initially then it may get recompiled for lot many reasons & I have very good understanding of reasons for recompilation & lot of document on that. Where as I am trying to understand what causes for compilation. I noticed we are not using ...Show All

• JeepATLGuy Executing password protected packages

  Hi - I have a master package that executes a series of other packages. Each of these 'sub' packages has the security property Encryption Level set to 'EncryptSensitiveWithPassword'. The master package has a series of file connections in the Connection Manager, one for each sub package, in which the password of the corresponding sub package is provided. When I run the master package in BIDS (in interactive mode) it opens each of the sub pac ...Show All

• FadedNite Merge replication using wins mobile 5.0

  Hi all, I have developed a mobile program with sql server 2000 merge replication. It works fine in Win mobile 2003 OS, but, not working at all after I upgrade the mobile OS to Win mobile version 5.0 Does anyone have any idea at all what's going on Thanks a lot. AngelaC Can you catch the exception and dump the HRESULT, Major Number, Minor Number, Native Number, Error Collection ...Show All

• Caleb T - MSFT SQL Mobile Embedded XP support?

  I am building a mobil application using Windows XP embedded. I need a database that will run on xp embedded as follows: Client mode: Sometimes connected to server(local) sometimes disconnected. Server Mode: Ready access to database from client and system running server. Client must be able to switch to server mode in event of failure. Does SQL Mobile support running Windows XP embedded on the Server Does SQL Mobile support running ...Show All

• Keyser isnull() Problem

  Today we get a call from one of our customers. One of our Apps gets a time-out error from SQL Server 2000 (SP4). After searching we get the following result: This instruction becomes never finished (>30 Minutes waiting) select isnull(T025.C048, '') as [int. Vermerk] FROM T025 ... This statement is ok (1 Sek.) select T025.C048 as [int. Vermerk] FROM T025 ... C048 is varchar(10) nullable The value of the field was "WNO" - not null. After ...Show All

• Donsabras Filter measure group.

  Is it possible to filter data in a measure group Do I have to create multiple cubes and data source views For example, I have a huge Fact table but I want to restrict certain rows base on the user. I can't use the built-in Roles security because my application does not rely on Windows NT users/groups. If you can't use roles - you're stuck. But are you using a middle tier app If so, you might be able to use ...Show All

• Nvc Reporting Services

  About a month ago I was able to download the Reporting Services for free to use with SQLExpress. Now I am unable to locate the download. I upgraded my PC so need to reinstall everything. Anybody know where the download is. Thanks You can find the links for the various VS 2005 Express Editions here: http://msdn.microsoft.com/vstudio/express/default.aspx -- Robert Wrong one. The one That I am lo ...Show All

• Shreya Change a dimension table name?

  Does anyone know how to change a dimension table without copying and pasting Not sure what you are talking about. What version of Analysis Services do you use Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. For AS2005, if you open data source view and select a table you can invoke context menu and select Replace Table menu item. Things bound to the old table will now be bound ...Show All

• jandizon How do deduplication on Fact Table

  Hi, everyone, l've a fact table DEVICE with following structure, DEVICE_NAME VARCHAR(50) DEVICE_DATE DATETIME DEVICE_NUMBER INT Where DEVICE_NAME and DEVICE_DATE form a PRIMARY KEY So l would like to import a text file with same information into this table. My problem is, text file contains records which will violate my primary key constraint. In that case, l would only insert the record with DEVICE_NUMER not equal to ...Show All

• dcumg Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (eve ...Show All

• OutlawPhx Script Component -

  Hi, In our office recently installed VS .net 2005 RC and Yukon Sep. CTP. The problem is, create a dtsx package.  Drag and drop a script component in dataflow after a OLEDB source.  Let the script component be transformation type. Edit it, click on scripts in the left hand side tree, double-click on the button 'design script' (right bottom corner).  I get an error: TITLE: Microsoft Visual Studio ------------------------------ Cann ...Show All

• Jason Wells Cannot install SSIS or Notification services

  I'm trying to reinstall SQL Server 2005 STD but I cannot get Setup to install Integration Services or Notification Services. I looked in the log and this is what I found. Needless to say, it makes no sense to me. It seems that Setup is trying to find a missing source list for a certain product. I have no clue what that product is. I've spent endless hours trying to figure it out and I'm still drawing a blank. This is a printout of the log. In ...Show All

• CFleming SQL table properties reporting

  This is a very simple question to which I haven't yet found an answer. I've just started working with SQL Server, and would like to print out a report listing the properties (Ie. field types, length, description, etc.) of all of my tables. How do I do this Thanks in advance. There are probably far better ways to do this, and (disclaimer) I don't think MS would recommend querying the systems ta ...Show All

• Ron Park Partitions not stored in the cube file

  [Sorry - I'm throwing alot up here today - I know] All partition info is stored in a <cubename>.partitions file. I'm just wondering why this information is not stored in the <cubename>.cube file in the BIDS project. Especially considering that, if you view the code of <cubename>.cube there is an empty < Partitions /> tag for each Measure group. Seems a bit strange to me. Any idea why this is -Jamie ...Show All