Answer Questions

• SevilJC problem importing csv delimited text file into a sql server 2005 table

  I am using the Bulk Insert command and trying to import a CSV delimited text file into a table and I am having problems with the quote field delimiters ", " The command below works but it takes in all the "" quotes as well and the field delimiter comma , works only if the commas are the separators only. If I have a comma within a address field for example then the data gets imported into the wrong fields. What can I use to id ...Show All

• Golf_Novice DTS transaction problem

  I created DTS package that has two connections “Source” and “Destination”, contains several “Execute SQL” tasks and several “Data Driven Query” tasks after them. For all tasks workflow properties are set to “Join transaction if present”, “Rollback transaction on failure” and “Fail package on step failure” except the last “Execute SQL” task that has also “Commit transaction on successful completion of this step” property set. The problem: when ...Show All

• manticor Different Results With View Versus UDF

  I have two views, for various reasons I decided to wrap a Select * From View with two UDFs. When run on their own, the UDFs return the exact same resultset as their respective view (did a compare and stuff to make sure). However, when I join them together, what was once 130,000 records (when joining the views) skyrockets into millions of records, and the resulting resultset is filled with duplicates. What is going on ...Show All

• Alfonso Calderon Is it possible to deploy reports on server and view it from client machines

  Hi, I'm a newbie to reporting service. I deployed a report on the server. When I viewed it on the server by entering the URL of http://localhost/reports$SQLExpress , everything's fine. When I tried to view it form a client machine on http://MyServerName/reports$SQLExpress , it failed. I did assign a role to the client user. I'm just wondering whether it is possible to do this. I'm using SQL Express, the server r ...Show All

• Maju V Poulose Client side redirect -- timeout period

  Can I configure the amount of time that the redirect will ping between the two servers if it cannot get a connection to either ...Show All

• Joel C Enable User Instances in SQL Server

  I'm just starting out and trying to connect to my first database using the following string: Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True I get the following error during debug: " Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances ." I've done this on every database ...Show All

• thezman Is there a way to set a variable in a data flow from a SQL statement (like in control flow)

  I'm currently setting variables at the package level with an ExecuteSQL task.  This works fine.  However, I'm now starting to think about restartability midway through a package.  It would be nice to have the variable(s) needed in a data flow set within the data flow so that I only have to restart that task.  Is there a way to do that using an SQL statement as the source of the value in a data flow   OR, when us ...Show All

• wam41887 Microsoft Please help

  A report I designed looked perfect html and pdf but when exported to excel it chops off the last column when printed. Does the report grow when exported to excel How can I fix this If I change the margins it fixes on the excel side but then the page doesn't look right on the pdf side. Thank you in advance for any help. Microsoft any suggestions please. ...Show All

• mimino YAIP (Yet Another Install Problem)

  Problems getting SQL Express June CTP to install. When I run the setup I get: -------------------------------------------------------------------------- SQL Server 2005 CTP Setup has detected incompatible beta components from Visual Studio or SQL Server. You must run the build cleanup wizard from the CDE to remove previous SQL Server components and .NET Framework components, and then run SQL Server 2005 CTP Setup again. For detailed instructions ...Show All

• User77 Conditional parameters

  I have a report that has five parameters. A couple of my parms are drop down lists. If parm 1 is not null, the lists should have a null record. If parm 1 is null, the lists should not have a null record. Is this possible I have tried using the parms on the stored procs behind the drop downs, but I have gotten some weird results. ...Show All

• westoncerny SqlServer2005 can support merge replication with SqlCe2.0??

  Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. ...Show All

• DaveyC11111 flow functions ?

  Hi Does anyone know where can I find a list of flow functions valid in MDX The list in ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/mdxref9/html/e363722a-3e5b-40a9-a0b5-399dd2d93f6d.htm ist not complete. For example: the case when else end function is not there. I really need a switch. Thanks! Have you looked at this article. http://msdn2.microsoft.com/en-us/library/ms144841.aspx It's a bit s ...Show All

• Andrew Thorpe RS2005 Crashed After Editing and Restoring Config Files

  Dear Anyone, Here's what happened. We backed up the web.config and the rsreportserver.config. We messed around with it trying to make an assumption worked. When we finally gave up, we deleted these files and renamed back the web.config and the rsreportserver.config files. To our surprise when we tried to open our report manager, the error below showed up. We tried to reconfigure the report server using the reporting services configuration too ...Show All

• shorinsamurai Database Mail does not work from SQL Agent Job

  Receiving Message: [264] An attempt was made to send an email when no email session has been established Just installed Service pack 1 and that did not help. Did you perform the following 3 steps when setting up your database mail 1. Enable database mail, create a new profile and mail account 2. Right click SQL Agent>Properties>Alerts System>Enable Mail Profile 3. Expand SQL Agent>Operators>Create New Operator ...Show All

• bigjefe Fuzzy Grouping: Any success with > 3 million records?

  I have tried to process > 3 million Fuzzy grouping records on two different servers with no success. 3 mill works but anything above 4 mill doesn't. Some background: We are trying to de-dup our customer table on: name (.5 min), address1 (.5 min), city (.5 min), state (exact). .8 overall record min score. Output includes additional fields: customerid, sourceid, address2, country, phonenumber Without SP1 installed I couldn't even ge ...Show All