Answer Questions

• FSX SQL Srvr 2005 DTS

  Hi, I need help in creating a DTS in SQL Srvr 2005, can anybody help me doing this please   AC DTS has been replaced by SSIS (Integration Services) You will find a Visual Studio 2005 in your Start Menu, that's your starting point. Ok, so if I have the Express edition, I wont have it right   Thanks and regards.   AC AFAIK it is indeed only supported in Standard a ...Show All

• talrs Page headers and using more than one table in a report

  Hi all, I have a report with 3 subreports on it. They work well except for the last report. The last report has 3 tables on it and I have a header row on the first table. I want this heading repeated on each page. Trouble is, RS only knows about a new page for this table when this particular table extends over more than one page. What I have is a small amout of data in each of the three tables and only when the third table is produced does ...Show All

• Art Art OutOfMemoryException with SQL Server Mobile

  Hi, I'm getting always an OutOfMemoryException after my program runs for a while. It's a smartphone application running on .NET 2.0 CF and using the SQL Server Mobile 2005. Sometimes it's even not a OutOfMemoryException but a SqlCeException. But it's always when the phone is having little free memory left. I have also created a few custom controls (I even implemented the Disposable interface) to dispose all resources (Fonts, Bitmaps). I'm ...Show All

• shi2008 Question about Decision Trees and Neural Networks

  I have some accounting data, with some transaction attributes and amounts. I'm using Decision Trees to try and predict the next month's amount for certain combinations of attributes. I've tried two different structures for the model: A: one with 9 discrete text input attributes. B: And another with the same 9 attributes + a avarage Amount for all combinations of the nine attribute for every transaction. When i've processed them and look in th ...Show All

• Voltaire How to show two dataset with equal & non equal of multiple selection.

  Dear Friends, In my report, I am having Listbox for users to choose Country, City & Company. The user can choose Country. Based on the country selection, cities will be listed out. Based on the city selection, Companies will be listed out. They can choose companies. Now, I have to show two set of results. A. List of Companies as per selection ( dataset with equal to selection ) B. List of Companies which are not selected ( ie dat ...Show All

• VBVBVB RS2005 Multiple Parameters

  Hi I'm new to RS, I've got SQL2005 installed and I'm trying to use the multiple select report parameter. I'm using a report filter to = database.field IN =Parameter.value(0) etc and even though I'm select more than one in the drop down it's only returning values for one of the options! Helps what else do I need to do Thanks! Fixed, I removed the (0) from the .value filter expressions and it worked. ...Show All

• dtb5571 SINGLE-USER MODE ALERT

  Hi, Greetings. How do i set an alert in SQL SERVER if the mode is changed to Single-User mode. Thanks in advance, shanthy Hi Buckwoody, Thanks. I would like to set an alert in SQL Sever whenever the Database is changed to Single User Mode. Shanthy Shanthy - Are you talking about starting the server in single user mode I'd doubt that SSNS is the best tool here. You'll probably have more luck in another for ...Show All

• TravelMan Concatenation of integer data into text

  I am a TSQL Newbie trying to concatenate two columns (DocumentNo & SequenceNo) that were created with a “smallint” data type constraint in a full-text search database. I want to end up with a column containing varchar data such as “5-2” where this row of data contains information about the 2nd document in a series for a person or group designated as 5. If I could change the data type for the columns to varchar I think I could que ...Show All

• tschuler77 Password Protected Excel File

  Hi I'm in need of a bit of assitance here.  Basically I am currently creating a SSIS package which works in principle with the exception of my data flow.   On my data flow I am reading an excel file using the excel source, this works fine for a number of my examples but one of the excel files is password protected.  This is throwing an error when I try to run the package. Does anyone know how to read a password protected ...Show All

• fadiz SSMS - Intermittent Login Failure

  I have a 2000 / 2005 side-by-side installation on our test server. To login to 2005 with SSMS, the connect string is hostname/SQL2005, 1434 There's a WiFi network connecting my client PC to the network. SSMS fails to login frequently. I need to exit SSMS, then login again. It'll work. A new problem today - after successful login, I can't open a project and login successfully. Error messages states "Failed to Login". ...Show All

• BlondGeek SA account Locked out

  I have been using SQL2000 for a number of years and the company I work for needs a new system so I decided to install SQL2005. I installed SQL2005 without any problems and set a complex password for SA. I tried to log on and had to make several atempts as I remmebered the password after the SA account got locked out with the following message: Login failed for user 'sa' because the account is currently locked out. The system administrator ...Show All

• Ryan Taylor Problem in bulk insert

  Hi All, I am trying to perform Bulk Insert for an existing folder containing the data files into an existing destination table . I get the following error : [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\PD Data\PDDW_md_costs\Files_to_load" could not be opened. Operating system error code 5(Access is denied.).". Here Files_to_load ...Show All

• Michael Sims Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?

  Until there's an Integration Services 2.0, what custom components would you most like to see examples of The documentation team is starting work on the 2nd Web refresh of Books Online and SQL Server samples, anticipated for release around April, and may be able to incorporate some requests as samples or BOL topics. I scanned Kirk's "Requests" thread and, although many requests are for tweaks to existing SSIS widgets, I noted the following ...Show All

• GaryCanada Could not load type 'System.Data.SqlServerCe.SqlCeDataAdapter' from assembly 'System.Data.SqlServerCe'

  Hi, I am trying to make a mobile application work, but I get the following error. The operating system on Pocket PC is MicrosoftR Windows Mobile 2003 Second Edition. Any ideas Thanks in advance. The followings are the error and my codes: System.TypeLoadException was unhandled Message="Could not load type 'System.Data.SqlServerCe.SqlCeDataAdapter' from assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, Publi ...Show All

• Ian Shimmings Date and time Concatenation

  Hello, I have 2 columns in a table, one with date ("M/DD/YYYY" format) one with time ("HH:MM" format) How can i do to make one date column in "DD/MM/YYYY HH:MM:SS" format Thanks a lot Have a look here: http://blogs.conchango.com/jamiethomson/archive/2005/07/26/1867.aspx -Jamie ...Show All