Answer Questions

• Scottzrn WQL Query - Where Cluase

  Hi, I am trying to collect windows event log in a raw format. I need to collect this data everyday for the past day but somehow I can't use the date criteria. Please Guide. The following query also brings data for 20061104 too. Is there a date function or Left function which I apply to get data only for specified date. SELECT ComputerName, Logfile, RecordNumber, Category, CategoryString, EventCode, EventIdentifier, EventType, Message, SourceName, TimeGenerated, TimeWritten, Type, User FROM Win32_NTLogEvent Where LogFile = 'System' and TimeGenerated >= '20061105' and TimeGenerated < '20061106' Hi Jaged, If there is no log information exists for a specified log and date, the WMI data reader tasks fail with the follo ...Show All

• Loonyjuice Union Support

  Hi there, I am facing a very strange problem. When I try to read data from my Xml based DB using XQuery (or XPATH), it shows me an error message that xQuery union is not supported. I really want to use union (|) in my XQuery and currently I am using query() method. So, is there a way by which I can execute my query Regards Salman Unfortunately we don't support the XQuery union operator in SQL Server 2005. As a workaround you can use the sequence constructor as follows: /a | /b can be rewritten as (/a, /b) The main difference between the union operator and the sequence constructor is that the union eliminates duplicate nodes. You can achieve this by adding /. after the sequence constructor because / operator elimi ...Show All

• Brant Yin Cann't Add Linked Server ?

  Hi      After I installed the Sql Server EveryWhere Edition & Sql Server 2005 I tried to add linked server to reach a Sql ServerCe database from my Sql Server DataBase on desktop.    If you know how can i use sp_addlinkedServer  stored procedure to add SQL ServerCe database as linked server or you know the steps should I do with the GUI to do this then help me, please.   regards   please help me if you can ! Hi thank you   David Frommer for your fast response   How are you trying to add the linked server   I can tell that I did not know the correct values of the procedure SP_AddLinkedServer, so ...Show All

• RichardHarley How To Execute an Oracle Stored Procedure from DTS

  In SQL Server 2000 DTS How do I call and oracle stored procedure I've tried using the Execute SQL task with the Exec <my procedure name> ; and it errors. I've been searching for the answer on how to execute Oracle Stored procedures from DTS without any luck. The stored procedure creates the table and data that I want to pump into SQL Server. Any help would be greatly appreciated. Thanks! Use this syntax: SQLStatement={call <procedure name>} Hi Matt, I'm using "Oracle Provider for OLE DB" and I've tried the syntax: SQLStatement = { call <sp_name> }. My Oracle Stored Procedure runs efficiently at Oracle client, but I've taken error me ...Show All

• dakerson Fuzzy Lookup Error

  Hi I get the following error when I use Fuzzy Lookup in a Data Flow task with TransactionOption property set to “ Required ” [Fuzzy Lookup [61]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: " Cannot create new connection because in manual or distributed transaction mode .". When I Change the TransactionProperty to “ Supported” it works fine. I need the property set to Required for it does an undo in the event of a failure. Any ideas on how to get the Fuzzy Lookup to work Set Required on the package container, and Su ...Show All

• yjacket2006 Report Builder Formatting Currency

  Hi all I need Report Builder to format Certain Numbers as Currency by default. According to the documentation I need to set the culture setting in the report's datasource. I'm using a SSAS2005 Cube The Report Manager then let's me create the Model wich is used by Report Builder. My Question is: Where do I set the culture setting I cannot find it in the Cube and viewing the model's xml hasn't helped. Any help will be dearly appreciated G This gives the path to my datasource. Does this mean that I have to set the connection string for that datasource that the path from the model refers to maybe set it in Connection String Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us ...Show All

• Vimal_Rupera Reporting Services 2005 textbox with html?

  Hi, Is it possible to insert html into a text control I have some records containing html that are saved using a website based on a richText html editor... How can i send the html to the textbox so that it would render like it is desired If by any reason i cannot use html how can i at least specify line breaks and feeds Best Regards, LS Hi, no you can’t use HTML here. It was always on the roadmap but not implemented yet. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Paul Mehner Offline/remote backups

  Hi What is the best way to perform daily offline/remote/off-premise backups of our websistes Sql Server 2005 database I've looked into using SSIS but for one reason or another am having serious problems with this. Ideally we'd like to be able connect over the internet and/or lan and pull the entire database down in one go. Our db is ~600mb so isn't major. We used to use Sql Server 2000's DTS and this worked well, but I'm having a real hard time using SSIS to do the same so was wondering what the other options are Many thanks Ben Hi Kevin The reason we used DTS originally was that it allowed us to backup over the internet. Obviously, upgrading to Sql Server 2005 made SSIS the log ...Show All

• llorrac using sql to deploy a database

  I am trying to write an installation for my application. I am using an SQL Express database as well as an ODBC driver to connect and querry an existing interbase database. Therefore the install needs to do the following: Install .NET - done Install SQL Express - done Install application - done copy some XML files - done Install ODBC Driver - done Create database - not done I am using a setup and deployment project to do the above. I have also written a small application to install the ODBC Driver and attepmt to create the database which I intend to run as a custom action if possible. I have used the SQL management studio script wizard to write an sql script for creating the database with the intention of usin ...Show All

• ar_pad Taming the UI in DTexecUI

  Is there an option(s) that will allow me to reduce the amount of output to the Package Execution Progress window My package has a number of steps, but trying to keep track of progress is difficult at best given the deluge of messages this window displays. I would prefer output similar to the SQL Import/Export wizard, which shows executing tasks on a single line with a status and a link to any error messages off to the side. Is this available somehow, or do I have to build it myself Thanks, any help appreciated. I don’t know if you can filter what’s in the progress report; but you certainly can enable package logging and decide what to log   Jamie Thomson wrote: ...Show All

• ahmedilyas Change chart type dynamically from Column to Line graph??

  I am developing several charts with column type and sub type as stacked. There is a requirement from the users that they want an option to choose the type of chart. Is it possible to change chart type dynamically from say Column type to Line type based on user option in front-end Any help will be appreciated. Thanks in advance !! I have the same problem. I created 5 charts on one report. but i dont want to execute the report for each change. all the charts are using the same dataset. Can i show /Hide all the charts except the choosen one by clicking on a textbox thanks The closest you can get directly in RS at this point is to define multiple charts with different types and ...Show All

• myoungbl Custom Security: How do you manage groups

  Dear Anyone, We are trying to create our own custom security extension for rs2005. We are wondering how will then security extension will manage the authenticated users and how will it be mapped to an existing RS2005 group or role Thanks, Joseph It completely depends on how you write the extension itself. I'd recommend that you use the forms auth extension as a start: C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample Change the parts of it that handle authentication, and then leave the parts alone which do authorization for you. If you go this route, you will continue to use all the same roles you did before: Browser, Content Manager, etc. ...Show All

• Lanex Hosting SQL Everywhere In a Windows Service

  The Sql Mobile site on MSDN recommends that you do not host SQL Everywhere when running as a service. Is this a recommendation, if so why, or is it simply not possible. My understanding is that when hosteed in a IIS hosted application a not supported exception is throw. If anyone has any ideas on this or pointers to some resources i would appreciate them. Thank You At present we have blocked hosting Microsoft SQL Server Everywhere Edition under IIS (by default). This is not a officially supported scenario. There are few techinal + business jsutifications behind this decision. You can get it working under hosted environment, but it is not officially supported. After Microsoft SQL Server Every ...Show All

• bagjuice Newbie Advice Installing SSRS

  Hi, I've decided to install SSRS (2005) on my windows XP machine. I'm not very familiar with IIS (i'm currently using version 5.1) and I think between IIS and SSRS, i've managed to break something. I've been looking at various articles to try and get some clarity on my predicament. However, i'm not getting any joy with them.s I have located the logfiles (which I can provide). Unfortunately, I have no idea how to intepret the information contained therein. Can anyone help Many thanks in advance Clint Please provide more information. First make sure every tab in the configuration tool is green. Then try to access your report server virtual directory. If there is an error on the web page please copy it here ...Show All

• raghu_grdr cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I believe that the encoding of the text file is ANSI. If it is relevant the database collation is Latin1_General_CI_AS (the same as it was when 2000). Any help anyone can provide will be greatly appreciated!!! TITLE: Package Validation Error ------------------------------ Package Validation Error ...Show All