Answer Questions

• JabberA Saving SSIS results to Log or text file using dtexec

  Hi, How to save the SSIS package results to log file using dtexec command............please help regaridng this........... Thanks in advance, Hi Donald, Thanks for your reply, actually i am using the folwoing command with out creating connection manager for log provider dtexec /sql "\CTSFullPackage" /ser "test" /u "sa" /p "test" /l "DTS.LogProviderTextFile;c:\log.txt" ...Show All

• mwetmore Can't get results from JDBC

  I'm having problems getting query results for my web-app using jdbc.  The connection I make to the server looks fine, but whenever I execute a query, I get no results.  I'm using something like the code below: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                 con = java.sql.DriverManager.getConnection(connectionUrl,userName,password ...Show All

• xensu ODB Datareader time columns

  I am using an ODBC Datareader to connect to a proprietary DB (Epex) and I need help on column mappings. The Epex database has a number of time columns which we successfully imported using SQL 2000 DTS by defining these as varchar(5) . When using SSIS (Service Pack 1) these fields are shown as 'eight-byte signed integer [DT_I8] '. I have attempted to these columns to both [DT_WSTR] and [DT_STR]' without success. I can change the Exter ...Show All

• Dan Krause How to calculate hours between 2 dates but excluding weekends

  Looking for way&logic to calculate hours between 2 dates (Ticket.date_opened and Ticket.solved_date) but excluding weekends This function calculates hours only  DATEDIFF(hour, Ticket.date_opened, Ticket.solved_date). Thanks! I suggest you create a function to calculate the number of weekdays between 2 dates (excluding the weekends using the datepart(dw,@date)-function) and multiplying this by 24... or alternativly, calc ...Show All

• MartinHains SQL Server 2000 Database Limitation

  Hello All, I am currently consulting with a company who uses MS SQL Server 2000 standard. They currently have a software application that they lease (ASP) to clients and host on their own server. Each instance of the application requires its own database. They are currently at 1050 databases on a single database server, but anticipate increaseing their client base to about 5000. To date their administrator has not noted any performance issues w ...Show All

• Nezo Purging the transmission queue

  My transmission queue has lots of messages that will never, ever be delivered because the transmission_status = "The session keys for this conversation could not be created or accessed. The database master key is required for this operation." How can I purge the transmission queue to get rid of this junk END CONVERSATION @dh WITH CLEANUP will purge the messages of the conversation with the convers ...Show All

• martinnickel Problem getting contacts from Exchange

  When I attempt to use ADO to get data from any "Contacts" folder I always get... System.AccessViolationException was unhandled   Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt."   Source="System.Data"   StackTrace:        at System.Data.Common.UnsafeNativeMethods.ICommandText.Execute(IntPtr pUnkOuter, Guid& riid, tagDBPARAMS pDBPar ...Show All

• Ben Brodie Calculating distance based on latitude and longitude

  I need to be able to take the latitude and logitude of two locations and compare then to determine the number of miles between each point. It doesn't need to account for elevation, but assumes a flat plane with lat and long. Does anyone have any algorithms in T-SQL to do this The SQL Server 2005 Samples download contains the source for the Spatial Data Library which I believe has a C# function for calculating the distance between two ...Show All

• k_savelev typed XML parameter for a CLR stored procedure

  does anyone know how to pass a typed XML parameter to a CLR stored procedure Cheers The only reason of passing typed XML to CLR SP is to verify it against schema, because CLR cannot use the benefits of the typed XML. Unfortunately, built-in autodeploy feature in the VS 2005 cannot create CLR SPs with typed XML parameters (as well as many other useful things), so I use predeployscript.sql and postdeployscript. ...Show All

• Hits Access 2000 to SQL Express 2005

  I have a commercial applicaton today developed in visual basic 6 with an access 2000 database. This application is ran by hundreds of businesses nationwide. Each business is running anywhere from 1-8 computer systems. Every once in a while a customer experiences corruption with the Access 2000 DB. Because of this I would like to switch the backend to SQL Server express 2005. 1) Does SQL Server Express need to be installed on every single P ...Show All

• maxc OLEDB source - Use table or select only columns needed.

  Hi All, With the OLEDB source, is it wrong to use a table / view as a source and only check the columns required or is it beneficial to write a select col1, col2 etc etc as a SQL command I cannot see any difference in performance between the two. Thanks. Let's agree to disagree! :) -J Thanks Jamie but... I would still like to know the underlying reason it is bad :) Accepted that Select * is bad due to many reasons but: My ...Show All

• frozenfreak cannot convert between unicode and non-unicode with Oracle

  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 bel ...Show All

• Ian L Currency conversion wizard - performance

  We have created a cube in which we want to do many-to-many currency conversion - i.e. we have a measure group with amounts measured in 4 different currencies, and we want to be able to display these amounts in any of these 4 currencies. The measure group is linked to a company dimension which in turn is linked to a currency dimension via a referenced relationship (there are 3-4 more dimensions in the cube). Running the currency conversion wizard ...Show All

• JustinRenquist SQL Server Reporting Services

  Hi There http://msdn.microsoft.com/vstudio/products/compare/default.aspx    States that Express Editions supports - SQL Server Reporting Services........... I would like to Generate Reports using these Services...... How Do I Do It Thanks Cheers Bronco Billy "Beer and Fast Women are Ok... No Cigarettes or Hard Liquor Allowed Yes - we are presently working to release another edition of SQ ...Show All

• Garrett_Brown Import tables from DB2 to sql 2005

  I have problems importing tables from db2 using the import wizard using IBM OLE DB Provider for DB2 The tables and data ('Preview...') can be viewed but when trying to map the columns ('Edit...' next to the tables) or import the data an error is recieved [DB2/NT] SQL0443N  Routine "SYSIBM.SQLCOLUMNS" (specific name "COLUMNS") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727".  SQLSTATE=38553 Schemas is ...Show All