Answer Questions

• Tamila Calculated Measu Wierd scaling issue when subtracting two decimal numbers

  I have a calculated measure which is a simple difference between a measure on consecutive dates. It seems to be working fine, except that the original numbers have a scale of 2 decimal points (they are currency measures). This is the calculation part of the MDX expression: ([BusinessDate].[Date]. CurrentMember , [Measures].[GBPEQUIV-SENSITIVIES]) - ([BusinessDate].[Date]. CurrentMember . Lag (1), [Measures].[GBPEQUIV-SENSITIVIES]) eg: 2,588,829,302.21 - 2,572,404,828.64 The real answer is -16,424,473.57 However, the actual value of the calculated measure is -16,424,473.5770621 which has a higher scale than the actual numbers and is in fact inaccurate. I presume it is doing some sort of floating po ...Show All

• Mike Culver Exporting a table with changing column names to an excel file

  I'm trying to write an SSIS package that exports a table that has changing column names to an excel file. The column names change due to the fact that the table is created by a pivot daily. the only thing I'm missing is the ability to dynamically map the tables' columns to the excel destination. Is this possible I read in another thread that "It is not possible to create packages or new objects within packages using SSIS." I also read in the books online that "The input and the input columns of the Excel destination have no custom properties." To me this means that I cannot programmatically create or remove columns in the excel destination. Please tell me I'm wrong. So, to summarize my research so far. In writing an ...Show All

• Xiao Feng Long duration Pre-Execute phase

  Does anyone know why SSIS sometimes just sits in the Pre-Execute phase of a data flow and does nothing It doesn't matter how elaborate the data flow is or the volume of data. It can sometimes take 80% of the task's run time. the same problem here... packages that repitively get stuck in the pre-execution phase. right after the status level doesn't rise any more, the server seems to take a deep nap: no activity shown in the system's performance monitor any longer! and these are packages that have run until last week! i haven't seen anything like that during my last 10 months of ssis-development. despair takes place, i just don't know what to do... any suggestions cheers, frank postscript. yes, there ...Show All

• Christian Schweizer For Each File - Limiting Files

  Thanks everyone I have another question. If I use FOr Each Loop Container (For each file Enumerator), it will select all the files in that folder. What if I want to select just 100 files (assuming 500 files in the folder) How do i do this Thanks while there is no way to terminate loop early, you can stop your task from executing by using precedence constraints with expressions: create a variable that will be incremented each time inside the loop by a script task in the beginning of the loop, connect your task to this script task with precedence constrain and set precedence constrain expression to @fileCount <= 100. The task will be executed only 100 times. ...Show All

• lhoodwinkle HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005

  SQL 2005 DOES NOT HAVE THE SAME FEATURE THAT WAS IN 2000 TO DELETE OLDER FILES OLDER THAN CERTAIN DAYS. I DO HAVE A JOB THAT CREATES A FULL DAILY BACKUPS BUT SINCE I DON'T HAVE ENOUGH SPACE, I WOULD LIKE TO FIND A WAY TO DELETE ALL OLD BACKUP FILES OLDER THAN X AMOUNT OF DAYS AND ALSO DELETE TRANSACTION FILES OLDER THAN X AMOUNT OF DAYS. IS THERE A TOOL TO DO THIS. CAN ANYONE HELP PLEASE. EMADKB I've never been too fond of Maintenance plans, there is only a limited amount of control with them. If I want the delete function for old backup files I use the -DelBkUps switch in the sqlmaint utility. Put this into a multi step SQL Agent job and you have ultimate control. BOL - ms-help://MS.SQLCC.v9/MS.S ...Show All

• Thelostcircuit Is this SSAS bug fixed in SP2 ?

  Can someone with the SP2 beta installed try the following and tell us if the formatting bug has been fixed (using the provided Adventure Works DB) with member [Measures].[DP] as [Measures].[Reseller Order Quantity] / 1000000000 select [Measures].[DP] on 0, [Reseller].[Business Type]. members on 1 from [Adventure Works] On SSAS 2005 SP1, I get scientific notation for the 2nd and 3rd rows returned by the query (as in 2.2076 E-05 ) This is a major issue for us as we tend to run SSAS queries from SQL Server using OPENQUERY. For instance, the following query fails because of this bug: select convert ( money , isnull ( substring ( "[Measures].[DP]" , 1 , 50 ), 0 )) from openquery ...Show All

• we7313 RMO + Interactive Conflict Resolver setup

  Hello, I'm trying to setup the Interactive Conflict Resolver in my C# app via RMO. (using SQL Server 2005) The only article I can find on MSDN or anywhere is involing T-SQL. Can someone please shed some light on this for me specificaly on the subscriber side. Thank you! Chris Check out the lollowing topics in BOL, http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.replication.mergearticle.allowinteractiveresolver.aspx http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.replication.mergearticle.articleresolver.aspx http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.replication.mergesubscription.useinteractiveresolver.aspx Regards, Gary ...Show All

• mEt Migrating Access XP database to SQL Server 2005 Express

  I want to migrate my Access XP database to SQL Server 2005 Express Edition. The Start Menu does not display any migration assistant in SQL Server 2005 Express menu list. How to migrate it hi, never tried it my self, but have a look at http://www.microsoft.com/downloads/details.aspx familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en regards Access includes a tool called the upsizing wizard that will assist in moving your database to SQL. Regards, Mike ...Show All

• jabuka Importing multiple flat files to multiple tables in SSIS

  I have a couple of hundred flat files to import into database tables using SSIS. The files can be divided into groups by the format they use. I understand that I could import each group of files that have a common format at the same time using a Foreach Loop Container. However, the example for the Foreach Loop Container has multiple files all being imported into the same database table. In my case, each file needs to be imported into a different database table. Is it possible to import each set of files with the same format into different tables in a simple loop I can't see a way to make a Data Flow Destination item accept its table name dynamically, which seems to prevent me doing this. I suppose I could make a different Data ...Show All

• Anyhoo (Harder?) cube query & design question

  Hi, I have an MDX query (and worst case a cube design) problem that I haven't been able to solve, any ideas on how to go about this Here's a simplified description, starting with the Dimension & Attributes * We make phone [Call]s. * In each [Call], and for a number of [Product]s we ask a number of [Question]s. * Each [Question] results in an [AnswerText]. These also reside in a user hierarchy [Answer Dimension].[Q and A]. * All of the above are attributes in the [Answer Dimension]. Facts * Measures.[Answer Count], which at the granular level is always one, i.e. each fact records that we recieved a single [AnswerText] to a single [Question] about a single [Product] in a single [Call]. * Measures.[Ca ...Show All

• Vladimir Chtepa Adding Columns Dynamically

  Dear All, I have a requirement, in which i have to add columns dynamically depending the records of a master table in sql server 2000. Pl, do help me If you mean a query, than there is no way to do that beside dynamic SQL. if you want to use dynamic SQL, make sure you first read the article of Erland to fully understand what you are doing: http://www.sommarskog.se/dynamic_sql.html HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- A.K.A Cross Tab query Research SELECT CASE WHEN THEN END AS [] Adamus ...Show All

• hashmi Files that go to different destinations?

  Hello all, Been looking to figure this out for a while, can't hurt to ask the experts :D .... I have a folder that will periodically contain text files: TABLE1.TXT TABLE2.TXT TABLE5.TXT However, the files will likely be different each time, ie, the next time the package is run, there might be TABLE2.TXT TABLE3.TXT TABLE4.TXT I'm trying to write a package that will: For each file in the directory, get the name and determine the table. (I can do that with a foreach container and a script task, yay) Fire off a sql query that looks like "truncate table ___ " (I can hack my way into doing that by getting a connection object from the dts.connections collection and creating a command, etc, while in the script task). Import the text fil ...Show All

• erzfezsf DTS to Excel, $0

  I am exporting some data from a view to an excel file though a DTS. $0 amounts come as -0, what is the reason for that an dhow can I fix it Jim, When I try a straight export with money data equalling zero or '$0' as strings, either from SQL Server 2005 or 2000 (using the Import/Export Data wizard in both cases), I get $0.00 or $0 in the Excel file. Can you be more specific about what you are seeing What is the view definition Is the problem column a table column declared as money/smallmoney in SQL Server, an expression, or what Are you using a wizard or another method to do the export When you select from the view in SQL Server, do you see .0000, or something else You haven't given us much to go on. Steve Ka ...Show All

• CloudyOne SCD component - is there an alternative?

  Hi, I have several SCD components in my project. As I have to process millions of records, SCD's are taking a lot of time. Is there a way to speed them up Work arounds Any tip is welcome -Tom Tom De Cort wrote: Jamie, Alex, Rafael, I've replaced my SCD's by ole_db sources where I perform a left outer join to check if I already have records or not -> so after a conditional split I do an insert or an update This works great, let's say for most of the SCD's In one case, where I throw this custom SCD against a huge table, SSIS puts lockings on the table - in which I want to insert or update - and the process ends up with doing nothing at all. (Strange because this happens after having processed 30000 rows ...Show All

• Mablao Dividing a Column

  I have a column that contains the persons Full name. I would like to split it so that it contains the persons First Name and Surname. Can i do this from a select command. Hope you can help e.g. Full Name -------------- Dave Smith Want to acheive First Name Surname Dave Smith On my first table I have the full name - from the command you gave me I was able to split the full name into two columns. In the second table this already contains two columns first name and surname. I want to be able to do an inner join on table 2. surname = table1.surname table 2.firstname=table1.firstname For some reason Im receiving an error - just ...Show All