Answer Questions

• japt hosting SSIS packages where?

  After i create a SSIS package, where can i put it or store it in the SQL SERVER 2005 so that i can execute it later on You could stored (I'm not wrong) it in three different places: In the SSIS File System In MSDB In FAT/NTFS You can execute a SSIS from a job, .net framework 2.0 code, VbScript, with DTEXECUI, etc.. You can execute dtsx file directly or use dtexec command It's better using Agent Job,and define schedule Hi, The option to do this is available once you have built you're project and you have done this whilst the CreateDeploymentUtility is True. All you then have to do is go to the deployment folder (usually in the bin directory) an ...Show All

• Udhay Kadiyala SQL Sever 2000 to SQL server 2005

  Hi all, I have an aplication in VB6 that uses an ODBC to link to a SQL database. Until today all my clientes had SQL Server2000 and my aplication worked fine. Some of my cliente have now SQL 2005 and my application still woks fine except in one of them. In this particular cliente it gives an error when the application tries to read/write a particular table and a particular column. This column is data type BIT and my code is ... Myrs("Servida")= true ... Any idea why the error appens And why only in a particular machine and not all of them with SQL2005 What can I do I changed the code for myrs("servida")=abs(cint(true)) and solved the problem, but is not the way that I want to go. I do not want ...Show All

• paulixml MDX - exclude certain members in a calculated measure in SSAS 2000-2005

  We had to implement measure which shows values accumulated until the current day in month. All days in the current month are totalized except special days like sundays or holidays. These have a flag ("IsWorkday") in the underlying database, which indicates this. The values to accumulate are saved on the first day of each month and data is only saved on the first day of each month. (forecast stuff) In SSAS 2000 we solved this in the following way: We implemented a calculated measure in the cube, which grabs the values from the start day of the month (OpeningPeriod). Then we used an IIF Function and a MemberProperty called "IsWorkday" to exclude the special days from the calculation by setting the calculated measure to ...Show All

• Alexnaldo Santos PIVOT Table

  Can Pivot Table be done in 2000 RDL I need to be able to use this feature of Pivot Table. Pivot tables can quickly be rearranged by dragging and dropping columns to different row, column or summary positions. Thanks If you mean Reporting Services 2000 (*.rdl files) then, as far as I know, you cannot embedd interactive olap functionality into the report. //Johan Not sure what you are trying to achieve. If you are looking to provide your users with PivotTable-like functionality embeded in web page, you might want to take a look at embedding OWC - Office Web Components control into your web page. Edward Melomed. -- This posting i ...Show All

• Vitalijus Can't run dts package job

  I setup a job which call a dts package (I try to call it from file system and from SSIS Package Store with the same result) and it doesn't run. If you take a look from the SQL Server Agent you could see this --->> 2012-06-17 09:01:02 - ! [LOG] Step 1 of job 'prueba' (0x85B4D5E843DB3145A6A1A6A0A43D04F3) cannot be run because the DTS subsystem failed to load. The job has been suspended Any ideas Excellent! Glad to help out. This was happening to people that installed to a drive other than C:. Did you install to a different drive It's a bug in setup. If so, you can fix it by changing the dbo.syssubsystems table in MSDB for the dts subsystem. Look to see where it's pointing. It should be s ...Show All

• ratslav RunningValue question

  I have a form that uses some header information (like client ID with name, address, etc) and then uses a table for orders that customer has placed. I now need to print something like a page number (but not in the header or footer). When I try RowNumber, this does not work as the dataset is returning multiple records for the first customer and then the next item in the list (the next customer ID) skips the number of records from the first. So I need the first one to have 1, the second to have 2 and so on. I tries RunningValue, but for each record it starts back at 1. What I need is like a counter. How would I go about this and thanks for the help. Try RunningValue(MyFieldsCount.value,Count,Nothing) ...Show All

• jones6 Help with finding last record!

  I have two columns - code (nvchar) and date (datetime) within an sql 2005 table. The code contains a list where the items are duplicated and I need to search for each item for the newest date and if the date is older than 180 days to display that record. Was relatively easy using the Last function but this does not exist now. Any help would be appreciated. TIA Thanks guys, Will try these over the weekend when things quiten down here. No Xmas slowdown for us... PJ: Would you please provide sample data and intended results Dave try this: -- sample table / data create table t1 ( [code] nvarchar ( 10 ), [date] datetime ); insert into t1 VALUES ( 'AB' , ...Show All

• mfdiqwer What interface does Management Studio use?

  Hi, Does anyone know what interfaces Management Studio use It does seem to retrieve information about Server/Database objects without the performance issues that SMO suffers from How does it do it Regards, Joginder Nahil www.starprint2000.com Joginder, If you take out the call to PrefetchObjects for tables the performance of you code will improve. This is because prefetch only seems to retrieve the properties needed for scripting when it prefetches the child objects of tables (columns, indexes etc), regardless of what you have set in SetDefaultInitFields. When you iterate through the Columns InPrimaryKey isn't prefetched and so you round trip for every single column of every single table. If you don't Prefetch th ...Show All

• ksona SQL Server Mgmt Studio (2005) on WM5 device (Cingular 8525)?

  Can I run SQL Server 2005 Mgmt Studio on my WM5 device (Cingular 8525, a.k.a. HTC TyTn) to manipulate my MS SQL 2005 db on 2003 server box Thanks I should have clarified that it doesn't have to be SQL Server Management Studio running on my WM5 device ... I just need a way to run sql commands remotely, without using a terminal services client. Is there the ability to do something like telnet to the server and execute commands via a command prompt I know that 2005 comes with a sqlcmd utility ... will it run on WM5 No, unfortunately you cannot run SQL Server Management Studio on your WM5 device. To see the prerequisites for SSMS, you can go to the SSMSE download ...Show All

• Robert S Parker Programmatically Data Conversion component creation

  Hi there, I have created a package which simply imports data from a flat file to a SQL Server table. But I need to incorporate a data conversion component by which I may change the source-destination column mapping programmatically. So what I thought that I need to add a data conversion component into the dataflow task. After adding this component (I found its component id as {C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C} ) I have created a path which establishes the mapping between output columns of source component and the input columns of data conversion component. Now I am not sure how to establish the mapping between the data conversion component’s input column collection and output column collection. I am giving my code snippet her ...Show All

• Zia Khan Date Ranges in KPI Value Expression

  How do I enter a date range for a KPI in the Value Expression This simple expression will get me a count for 2006 but how do I get a count of 2005 and 2006 combined ([Measures].[TOTAL AMT], [Incident Status].[Incident Status].&[1], [Start Date].[Year - Quarter - Month - Date].[Year].[Calendar 2006]) Thanks * is shorthand syntax for Crossjoin() - this is documented in BOL : SQL Server 2005 Books Online Crossjoin (MDX) Updated: 17 July 2006 Returns the cross product of one or more sets. Syntax Standard syntax Crossjoin(Set_Expression1 ,Set_Expression2 [,...n] ) Alternate syntax Set_Expression1 * Set_Expression2 [* ...n] A ...Show All

• s12 Sum with null values

  Hi everybody. I have a query that, in a certain filed, returns a numeric value for some rows and null for others. For that field, in Reporting Services I have to report the null values as 0, and add a total (a sum) of the values of the entire Query (again, for that field). On the report designer, when I drag and drop the field to a TextBox there's no problem. But when I write the formula =Sum(Fields!FieldName.Value, "DatsSet1") to another textbox (a textbox in a footer or something like that) and try to run the report I get the next warning: The value expression for the textbox ‘textbox6’ uses an aggregate function on data of varying data types. Aggregate functions other than First, Last, Previous, Count, and CountDistinct can only aggreg ...Show All

• babakf dtexec over the network

  Hi All, I'm trying to execute DTExec from a workstation and I got some help from a different group without luck maybe someone here can help me. This is what I try so far. 1. My package run in command line from my sql box using dtexec with parameters. 2. Set the package with DontSaveSensitive and import into IS under MSDB with the same option setup. 3. Set package role to public. 4. Share DTS folder with everyone permission just for testing. 5. Execute the package from a workstation using //sqlServerbox/DTS/BINN/dtexec /dts "msdb/mypackage" /SER "MySQLServer" /set \package.variables[myvariable].Value;"myvalue1,myvalue2" (myvariable is string and I can pass multiple values separate by commas) 6. Still g ...Show All

• KRISTER Save to XML file

  i'm trying to save data to an XML file from an OLE DB source using the "For XML" clause in the SQL command. Do I need to use a flat file connection manager or a raw file connection manager And what destination do I use jschroeder wrote: i'm trying to save data to an XML file from an OLE DB source using the "For XML" clause in the SQL command. Do I need to use a flat file connection manager or a raw file connection manager And what destination do I use There are no built in components to allow you to output as XML but Donald Farmer's book contains code showing you how to do it in a script component. If you don't want to buy the book (although i recommend you do - its very cheap) then read th ...Show All

• AlexReg Architectural Design Question ?

  We currently have a number of SSAS 2000 physical cubes and a single KPI virtual cube that our finance department reports from. A colleague is prototyping a new approach in SSAS 2005 and I’m looking for some feedback. Please see http://www.dailyware.com/SSAS2005Design.jpg for a high level overview. The lines in red illustrate custom .Net applications that push aggregated data from cubes to some other reporting source (SQL tables, XML ) that our finance department will report from. Thought that come to my mind include: many points of failure, significant custom development required, none-mainstream, high maintenance cost…. Thanks, Gary Hi Gary, Edward already provide ...Show All