Answer Questions

• MarcGBeauchamp Change the WHERE conditions dynamically

  Is there a way I can build a case statment or similar to handle different where conditions I know I can do it dynamic sql but it would be nice to have a method where I can create the querries directly in a normal statement Someting like: Select c1, c2, c3 From Table WHERE Case @Condition WHEN '>' @SelColumn > @Limit WHEN '=' @SelColumn = @Limit WHEN '<' @SelColumn < @Limit END I know this doesn't work so an example that do work would be nice. Depending on the expression, yes, it might.  And depending on what else you're using as a search argument and what indexes you have in place, "every row" might mean "every row of the table" -- so th ...Show All

• LukasO Calling .Net Assembly or Dll from SQL Server 2005 at config Level 80

  Hi, I create a dll assembly with the strong name in VB.Net environment. Created assembly is registered also. SQL Server 2005 configuraton level is set at "80" I want to call that assembly from stored procedure with the database config level at "80" But when i execute the stored proecure i get the following error Error Source: "ODSOLE Extended Procedure" Description: "Invalid Class String" My Code in VB.Net is given below: Imports System Imports System.Reflection Imports System.Globalization Imports System.IO Imports System.data Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server Imports Microsoft.VisualBasic Imports System.Diagnostics I ...Show All

• galbox20 How tot select the most recent date

  I have 2 tables: 1) Item table (No_, Description) 2) Sales Price HAG table (Item No_, Sales Price HAG, Starting Date) I want to have a report within from every item the most recent sales price. But, it is possible that a unique item has more than 1 sales price in the 'Sales Price table' (if it has more than one Starting Date). I want to report the sales price with the most recent date. I've made this statement: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description, [DatabaseName$Sales Price HAG].[Unit Price] FROM [DatabaseName$Item] INNER JOIN [DatabaseName$Sales Price HAG] ON [DatabaseName$Item].No_ = [DatabaseName$Sales Price HAG].[Item No_] ...Show All

• MarkTR table scalar function syntax. . how wrong and how far am i?

  SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION DetailedView AS BEGIN Declare @fieldname varchar ( 10 ) Declare @stmt varchar ( 4000 ) Declare Fields Cursor For Select Amounttype From Amounttypes Set @stmt = 'Select pono, myid, billtype' Open Fields Fetch Next From Fields Into @fieldname While @@Fetch_Status = 0 Begin Set @stmt = @stmt + ', sum(amountfc * Case When amounttype = ''' + @fieldname + ''' Then 1 Else 0 End) As ' + @fieldname Fetch Next From Fields Into @fieldname End Close Fields Deallocate Fields Set @stmt = @stmt + ' From multiplebillsviewall Group By pono, myId,billty ...Show All

• VMan SSIS Connection Manager Broken

  Hi to all, I'm having serious problem with SSIS on my development machine. each time I try to add a new Connection manager i got this error : TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL INFORMATION: The connection manager 'OLEDB' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design) This happen for any type of Connection Manager, ADO.NET, FILE,SMTP. I've already tried to uninstall SSIS , but nothing change. I've any chance to get this problem solved Thanks in advance There are some ideas buried in this thread- Re: The connection manag ...Show All

• DavidC&amp;#35;2005 XML Task and variable output?

  Hello, What I'm trying to do is get an XML query from a database and use the XML to render an excel document. Can this be done using SSIS Can I actually read a column from a database and store it in a variable and then create an excel spreadsheet with that variable in SSIS Would this be done in the control flow using the XML task editor Thanks, Phil I'll rephrase my question. Using the following options in the output of the XML task in the control flow: Diff Compares two XML documents. Using the source XML document as the base document, the Diff operation compares it to a second XML document, detects their differences, and writes the differences to an XML Diff ...Show All

• Larry Surat selecting date range

  I have an MDX query that I'm using in Reporting Services: SELECT NON EMPTY { [Measures].[NumberOfClaims] } ON COLUMNS FROM ( SELECT ( [Date].[DTM02_Date].&[2003-12-23T00:00:00] : [Date].[DTM02_Date].&[2005-01-01T00:00:00] ) ON COLUMNS FROM [ClaimStatus]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS Now this works fine... until I change the dates... such us putting in 2000 instead of 2003 in the date first date. This cube is from two tables: 1. A Claim table (health care claim) 2. A Date table The data table has two columns: 1. a key 2. the actual date The claim table has a key that links to the date table's key, and the corresponding date is the claim date. So when ...Show All

• sabo How to check whether an SSIS package is executing

  I have scheduled an SQL Job to run every 15 mins. This runs an SSIS package. But sometimes my package might execute for more than 15 mins. In this case, a second instance of the package would start. I don't want this to happen. So is there any way I can check whether the package is already running before I continue the execution of the same. Right now I am using a mutex to handle this problem. Are there any problems using the mutex and is there a better way to handle this Thanks in advance. Sumesh Other way is use checkpoint file and simple task scrpts that check if checkpoint file exists. If exists wait 1 sec … Public Sub Main() Dim fileName As String fileName = & ...Show All

• Ramanakumar SSIS Deployment

  Hello, I would like to know how to set up the SSIS package with the DATABASE, SERVER NAME and Connection String into variables, so that I can change these parameters of the deployement, on another name of server and database (and connection string). Thanks a lot for your advices ! Marie-Therese Hi Marie, This came up in a recent post . This article by Jaime Thomson might help - Easy Package Configuration HTH! ~Matt Thanks a lot Matt ! Hello Marie, You don't need variables the realize this. Within SSIS you can use Package Configuration to make Database, Server name and connection string configurable. In the Package Configuration you can specify which properties of a OleDB or ODBC Connection can be configured ...Show All

• Gerhardo better table management (partitions?)

  Hi, For my work I am now learning Sql server 2005 and I have been given a database that has been set up by someone else to work with. It is my job to get the database ready for use in reports. My problem is that the current database has one huge table with almost 8GB of data. The table contains data from 2004 to present (and growing) from 14 different countries. The reports we use are mostly per country, but we also want to compare the 14 countries to eachother for say, whole 2006.  At the moment the table is stored in one single file instead of using partitions. I believe partitions can give a good performance boost when running the queries. But how do I do this Currently the country codes are just plain text, can they be us ...Show All

• anand.r SQL and Internet

  Hello, I'm having problems with SQL SERVER 2000 and internet. I've a network with WINSERVER2000 and SQL SERVER 2000, and 5 Computer with WINXPPRO. They are connected to a swith witch is connected to router with internet by cable. The problem is that every time the internet fails, I can't connect to the SQLSERVER , when internet cames again it will work normally. I've a similar situation with another network with but instead SQLSERVER is MSDE. My program is based in VB.NET and my string connection is provided by the dataform wizard of VB.NET. What can I do to avoid this situation Thanks in advance, Luis Mendes Luis, Sounds more like you have a network problem. Wh ...Show All

• AmitKa SSIS Package Connection Contexts

  1) When we work with SSIS data flow packages, for source and target conatiner, we add a connection. 2) Instead of pre-fixing connection contexts this way, I would like to provide these dynamically at execute time. 3) Is this possible & if so, how 4) Is it possible to compile, deploy and install packages without specifying connections for source and target containers and then provide these dynamically at execute time. ...Show All

• Eduardo Coelho Image (Jpeg,Gif) on A Header pade & Sort

  Hi We setup our report to use and external image (Gif format), the name of the actual image is passed by using a parameter, the image is located in the header section of the report. The image shows on the report (all pages/PDF) without any problem, until I click on a sortible column, then the image will not display on any of the pages. Any Idea Thank you Veneto ...Show All

• Soteriologist transactionoption=required

  Hi I set the transactionoption = required at package level. This package has a couple of dataflow taks and both the tasks are set transactionoption = supported. If one of them fails, both the tasks should be rolled back. When I run the package, it simply hangs at the first dataflow task with no error message. I had to stop debug to stop the execution of the package. My system has DTC service enabled with Network DTC access enabled and the sql server is running on my local machine, which is windows xp box. Any idea why this happens and the solution or workaround for this Thanks Ramani Did you set Fail Package on Failure for the data flow tasks Hi Mohit Thanks for the s ...Show All

• BlackCatBone Install and Uninstall problem

  Mike, I am having the same issue, but a slightly different situation. I installed sql express...then thought I should uninstall and install sql express with advanced services...got the sa login error described in this thread but with error number 29521. the summary log says this...should I also send you the error log referenced in this log Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Fri Jan 05 09:59:01 2007 Machine : myname Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstr ...Show All