Answer Questions

• Nikolaj Berg Amondsen Exporting text file and populate it as table using SQL

  Hi, I have a problem, I have some text files in the server. I have to export that file and read it line by line and then cut it into fields and populate it as a table in SQl with SQL commnads. Could you anybody help mw with some hints, any relevent readings etc.. How can i use sql framework for this If you have control over how the text files can look like, I would recommend using the FOR XML and XML Shredding mechanisms (OpenXML, nodes() ...Show All

• Rashad Rivera 'Earlier years' and 'Later years' in a timedimension

  Hi, I need to group together year 2003 and earlier in the bucket 'Earlier years' and 2009 and later in a bucket  called 'Later years'. Is there any simple way to handle that within a timedimension     I have a table MatchDate with the column MatchDate, MatchYear, MatchQtr, MatchMonth. I solved the issue by using MatchYear as 'Earlier years' for years before 2004 and 'Later years' for years ...Show All

• Sutty SqlCeConnection guidelines - keep it open?

  What is exactly the recommended way of using a SqlCeConnection object in your application In all the examples I see (IBuySpyDelivery for example) it opens the connection object in the constructor and leaves it open most of the time until the class gets disposed. Is that the way to do it Or should you open and close the connection for each database action (insert/select/delete) you're doing on the local SQL Mobile database I'm a bit conf ...Show All

• Felix Jiang Fuzzy Group Updates?

  Hi there, Quick Background:   I have an SSIS package that reads data from a flat file then runs it through a Fuzzy Grouping component.  The result of this Fuzzy Group is put into a SQL server 2005 table. Question:   Over time, the flat file will be adding new records (some that should be added to existing groups) and so I'll need to update my Fuzzy Group table to include these new records.  Is there anyway to ...Show All

• DirkH another backup quick question

  Hi What does Backup set expiry do Apart from mark the set as "Not being allowed to restore", does it delete the file cheers ICW If you're backing up to tape it sets the date the backup expires so the tape can be overwritten on the next cycle. I personally recommend you back up to disk, then back up those disk files to tape along with your regular network backup. ...Show All

• Lucc Update/Delete/Insert not working (by using the DataSource)

  I have added a database in my application as SqlServer database file(xyz.mdf).When i dropped a table from the datasource on winform, a gridview control along with datanavigator were created.When i was clicking the SAVE Button, data is not inserted,deleted and updated in database.Its just inserted,deleted and updated in dataset and not reflected in database. It is working fine when i use the database from the SQL Server 2005 Professional Edition ...Show All

• mors SQL Express:Trouble using sp_attach_single_file_db command

  Operating system: XP SP2 DB Server: Express 2005 I am encountering the following problem and have not been able to find the cause or reproduce it on a clean test machine which is very frustrating. I am curious if anyone else has experienced this problem and knows the cause and hopefully a solution. Here's what I do ... 1. Install express server using the default settings (this works fine). 2. Attempt to connect a database file to ...Show All

• Joe Dawson I'm New & Need Help. Install + Use SQLExpress with Access

  I'm totally new to using RDBM's, and have never installed or used SQl. Can someone please tell me how to install SQL Express, do whatever I need to to at the command prompt, etc., and then what I need to do in order to create a database in Access which uses SQL Express as the backend I'm using Windows XP I have .Net framework 2.0 installed and the .Net SDK Can someone please help a noob out :) Thanks., James What do y ...Show All

• Spog Mog SMO

  hi everybody, I want to add the Microsoft.Server.smo.dll to my VS 2003 .net project. However, when I try   to do just that, I get an exception (A reference to Microsoft.SqlServer.Smo.dll could not be added.  this is not a valid assembly or COM component etc). Any idea Ozbourn now let me put this way i have visual studio 2003 and i have also installed Framework 2.0 I have installed SQL Express 2005 ...Show All

• NitinVaghela RDA Pull Error table

  My dev environment: VS2005, SQLServer Mobile, SQLServer 2005 server db, PPC windows app. Having a problem with pull. First pull works fine. I request an error table from the pull. When I need to repull, I drop the table, but if I try to programmatically delete the error table, I get the message that the table has restricted DDL operations allowed. Apparently Drop is not allowed. Sometimes dropping the main table deletes the error table, somet ...Show All

• tbrinkman multiple conditional formatting

  Hi, is there simplier method of doing multiple conditional formating   right now i have to nest the conditional:  iif(a=b, "Blue", iif(a=c, "Red", iif(a=d, "Green", "Black"))).  so if i have 5/6 or more conditions, it will be very messy. thanks, Ash In some cases (e.g. numeric values), you could use alternatives to the IIF function: * =Choose(...) http://msdn.microsoft.com/library/en-us/vblr7/ht ...Show All

• pavel989 SQL Server 2000 sign-on to 2005

  Good morning, I'm wondering if it's possible to connect to SQL Server 2005 from 2000 I'm having no trouble going from 2005 to 2000 but I can't seem to connect the other way. Any help would be apprciated. Thanks, Hi Bill,   I have done that as well, with no problems.  Can you let us know what error you're seeing (or problem you're having)   Also, can ot ...Show All

• Steven F Why I can not deploy my report project?

  Hi, all here, I am having a problem when trying to deploy my new report. The error message is like this: can not connect to the server, make sure the connection information is correct . But I have double checked the connection information, the server I tried to connect is the reporting server name on my local host though. (/localhost/Report Server). So what is the problem though. Did some body here ever occur this problem Thanks a lot f ...Show All

• Alan_98 SSIS Package Corruption

  Hi, Anyone know why one would get a package corruption error This is the error: “There were errors while the package was being loaded. The package might be corrupted. See the error list for details.” We tried the prescription said here: http://whiteknighttechnology.com/cs/blogs/brian_knight/archive/2005/12/19/34.aspx but that did not seem to work. This has happened for a few packages now and wanted to see if there w ...Show All

• another_pancho Flat File Source, please Help !!

  Hi all I have some problems with the "Flat File Source" ... I am trying to load a textfile, but IS allways cuts the rows ... When I look at the preview while designing, the row is complete, so I am wondering what IS is doing ... Thanks for any comments Best regards Frank Uray Here is what I am trying to load (one row from the file): WPBX1 1.2 19330065002695435000 001200526000 000020002002-11-13-11.17.55.2220262006-03-03- ...Show All