Answer Questions

• spyork Connection managers - OLE DB

  Hi There Quick question.In DTS when you had multiples tasks connecting to the same Database, it was reccomended that you create multiple connections for the same database and let each task use a different connection, thereby making a new connection for each one. In SSIS if i define 1 OLE DB connection to a database, but i have say 6 tasks using that connection that run simultaneously, does eachone open a new connection to the database to make it ...Show All

• oaktown How do I get AdventureWorks to show in sql2005.

  How do you make the AdventureWorks sample show up (June ctp)   I already installed it using the msi file: "C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi" But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step).  What's missing Right-click Database Engine , point to New , and then click Server Registration . The New Server Re ...Show All

• Butch Clark Feedback on CTEs

  When I first saw this feature I though "Yeah, that's a nice-to-have" Now that I'm actually using them for real my opinion has changed to "WOW. These solve SO many problems that I couldn't have solved otherwise". Specifically I'm using them to navigate hierarchies (which is of course what they are for). Kudos to the SQL Server team, and thanks very much!! -Jamie Thanks for your feedback. Happy to see that you like the feature and it d ...Show All

• squ1die Bulk Insert Unicode

  Good day, We are using bulk insert with a formatfile to load a text file into sqlexpress. One field in the text file contains non-ascii (unicode) charaters and the corresponding database field is nvarchar. When the record and row are specified in the format file as: <FIELD ID="23" xsi:type="CharTerm" TERMINATOR="\t" MAX_LENGTH="400" COLLATION="Latin1_General_CI_AS"/> <COLUMN SOU ...Show All

• Erik Moore Changing the value of a variable

  I'm looking for all possible ways to change the value of a variable. I know this ways: - edit direct - configuration file - scripting task - scripting component It is possible to change the value with other components       It is unclear whether you are looking for tasks/components that change the value of a variable or whether you are looking for ways that it can be d ...Show All

• Bob Bojanic - MSFT Mapping of SQL Server data types to Integration Services Data Type

  Does anyone know of any cross-references between SQL Server data types and the new data types introduced with SQL Server Integration Services   For example, Integration Services has "DT_DATE", "DT_DBDATE", "DT_DBTIME" and "DT_DBTIMESTAMP".  So far, if I have a SQL Server datetime column, the only Integration Services type I have been able to use is "DT_DBTIMESTAMP".  There must be a way to map the datetime type to "DT_DATE", "DT_ ...Show All

• Captain Toad What is the best way to return boolean logic from a UDF?

  CREATE FUNCTION MyBoolean(@p1 varchar ( 255 ),@p2 varchar ( 255 ) ) RETURNS bit AS BEGIN DECLARE @b bit SET @b= 1 -- plus other heavy logic RETURN @b END GO then call this in a CASE or IF-ELSE this: IF MyBoolean('foo','bar')=1 THEN ... Is there a better way to return and use boolean variable like other programming languages(like c# or vb, that have a true boolean data type ...Show All

• Viper8896 reporting services 2005 proxy

  I am trying to create a RS proxy to use in my web site. I did this successfully with RS2000. I used web matrix to generate the proxy and put the dll and .cs file in the bin directory of the web site, then I just used <%@ import namspace="rsProxy" %>. It worked like a charm. Now I am trying to get the 2005 version working and created the dll's but all I get in my web page is that it couldn't find the namespace. I also tried ad ...Show All

• Robert Pinkerton How do I calculate the difference between two line items?

  I am trying to calculate the difference between two date/times as they relate to two separate errors that have occurred on a production line. The available date fields are as follows: Error Date First Error Date Last Error Date First Repair Date Last Repair Date 1 4/17/2006 08:23:29 AM 4/17/2006 08:23:29 AM 4/17/2006 08:23:29 AM 4/ ...Show All

• BaoMJ Clearing/Unselecting Multi-Value selections made

  I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections Ron, Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an & ...Show All

• Martin Thorsen - MSFT CLM

  Can someone send me the link to the primary Sql Server (2000 preferably) MS forum   Or is this it You can certainly post your SQL Server 2000 questions here.  You might also take a look at this site http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx   for additional newsgroup resources. ...Show All

• Leo Leys Problem With Attach Tabels

  Hellow Everybody. I have an access db that part of the tables there are attached from sql server 2000, and other attache to another access db (access2.0). This DB are transfer data from the sql server DB to access2.0 DB. It had working for 4 month very good. Week ago problems occured when the connection to sql server failed. Everytime I try open sql server table, it ask for connection details (login,password). Is anyone familiar with th ...Show All

• Destroy89 Dimension as Parameter in Reporting Services

  Hallo everyone: I am using reporting services and I am looking for a way to define a parameter “dimension”. The problem is that in Reporting services are available just the fields resulting from the mdx statement. Using the following statement I can use the fields “ value ” and “ Customer ” Select {[Measures].[ value ]} on 0, {[ Customer ].allmembers} on 1 From [Cube1] I could solve it lik ...Show All

• AmirRony2 xp_smtp_sendmail and Outlook Express works; Database Mail doesn't

  Hello, I recently upgrade a SQL 2000 SP4 EE running on Windows 2003 AS to SQL 2005 EE. I was using xp_smtp_sendmail on SQL 2000 through an Exchange server successfully. However after the upgrade I am unable to send SMTP mail through Database mail, although testing it through Outlook Express works successfully. I've enabled it in Surface Area configuration and here's the results of the sps EXEC msdb.dbo.sysmail_help_status_sp ; Started E ...Show All

• Boris Mueller Guide to Setting Up the Different Data Mining Operations

  Unfortuately, the documentation doesn't seem to really provide the process to setting up the various mining operations (clusters, trees, etc.). So I am sitting there, trying to figure out what it is asking for when I try to set up a K-means cluster. Is there a better guide available Much of the information is being integrated into the documentation as well as some of the samples.  This site is run by the ...Show All