Answer Questions

• Kevin Dente Export Sql data to text file

  Hi all, I am new to ssis. I try to create a package completely by vb.net to export a table in sql server to text file. i got the following error while i run the package, An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". The AcquireConnection method call to the connection manager "OLEDBSrc" failed with error code 0xC0202009. component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. One or more component failed validation. There were errors during task val ...Show All

• singam OLE DB Source Editor

  hi, I am using SSIS to extract data from sql server and import into MDB file. In the process, under data flow task, I have used OLE DB Source Editor as source. Here i have choosen SQL Command as mode of data population. In the box below i have typed the following statements. "Exec Site_Address" I have used many temperory tables in this procedure. When i run this procedure in the query analyzer window i get the desired data which has to be imported to an MDB. After typing the above statements and when i click the button preview i can see the data. But when i click the Columns.... i dont see anything there. I am unable to see any columns there. This is getting to my nerves because, when i use OLE DB as Destination i am unable ...Show All

• Juliano.net Database Issue

  HI, I can't seem to wrap my head around this problem. Hopefully it's a simple solution. I have 2 tables, one called SETNAME, and one called PLAYERS. SETNAME has 2 fields (NAME and SETNAME ID) PLAYERS has 4 fields (LAST NAME, FIRST NAME, PLAYERSID, and SETNAMEID) The two tables are tied together via the SETNAMEID field. My issue is this, how do I associate more than one set to a player, without duplicating the names of the players in the PLAYERS table Thanks Peter WHat about this here Thats a common approach. SETNAME has 2 fields (PLAYERSID , NAME) COmposed key on Playersid and Name PLAYERS has 4 fields (LAST NAME, FIRST NAME, PLAYERSID) HTH, jens Suessmeyer. --- http:// ...Show All

• T.Vargek date/time format with Format_string is not working

  with member x as [Date].[Calendar]. CurrentMember . Name , format_string = 'mm/yyyy' select x on 0 , [Date].[Calendar].[Date]. AllMembers on 1 from [Adventure Works] When I run this, I get the same value as CurrentMember.name for 'x'. Any ideas The .Name is not of type date - instead use .MemberValue : with member x as [Date].[Calendar]. MemberValue , format_string = 'mm/yyyy' select x on 0 , [Date].[Calendar].[Date]. Members on 1 from [Adventure Works] ...Show All

• spinal MDX Sort ASC - on property that has datatype integer - result 1,103,2,203,...... ?

  Hi, i want to sort my Client dimension on its property Client-ID, for example Client Client-ID A 1 B 2 C 103 but this query: SELECT NONEMPTY(ORDER( [Clients].[Clients].[Clients], [Clients].[Clients].Properties( "Client-ID" ), ASC),{[Measures].[Sales]}) ON COLUMNS FROM Sales sorts them like text. Client Client-ID A 1 C 103 B 2 Some ideas Thank you! First, you probably want BASC instead of ASC, but that is not the problem here. The problem here is that .Properties always returns string data type for b/c reasons. You can do one of the following: SELECT NONEMPTY(ORDER( [Clients].[Clients].[Clients], [Clients].[Clients].Properties( "Client ...Show All

• Nick Efremov Conditional running total question

  Hi there, I have a problem with trying to get a total of a conditional value. My data output looks as follows: HEAD OFFICE BRANCH (group1) (Group 2 below) Ford         Mustang     2001     Blue     Excellent Toyota      Raider        2005     Red     Good BMW       5.30 i         2006     Blue     Excellent Mazda      MX5          2003     Yellow Good WESTERN CAPE BRANCH Ford         ...Show All

• soconne SQL Server Database backup Failed!!!!

  Hi, I was trying to restore some databases from one SQL Server to another SQL server on another machine. When i backed up them i followed the procedure described on the MSDN website. Now when tried to restore them on to a new machine on another instance of SQL Server i got the following error. I really dont know what it means. The error is: "Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\eRoom_eRoomSite.mdf' may be incorrect. File eRoom_eRoomSite cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\eRoom_eRoomSite.mdf'. Use WITH MOVE to identify a valid location for the file. Device activation error. The physical file name 'C:\Program Files\Mi ...Show All

• afshar DMX from Java

  My preferred programming language is Java (sorry Microsoft). I've searched for examples of running DMX queries into an Analysis Services database from Java but failed to locate any. I've seen suggestions that XMLA could be used but again, I can't locate any examples (in any language). For my current project I ran up the white flag and used C# instead but this wouldn't be an option in other cases. It would be possible to make the DMX calls from C# objects and call those from Java but that's pretty labourious to code. Suggestions I found that page but I didn't find any code sample to go with it. have you tried the XMLA Thin Client sample at http://www.sqlserverdatamin ...Show All

• toratora validating XML file against XML schema

  Is there a way to validate a XML file against XML schema before loading the data from XML file into MS SQL database Thank you very much for your help in advance. Minor addition to Karthik's reply: if you don't want to store the data in the XML column, assign the XML value to an XML variable typed by the XML schema collection. You can load the XML data from a file using OPENROWSET for example - see the following whitepaper for an example: http://msdn.microsoft.com/xml/default.aspx pull=/library/en-us/dnsql90/html/sql2k5xml.asp Thank you, Shankar, Program Manager, SQL Server If your column in SQL Server 2005 has been defined as a typed XML column that is defi ...Show All

• Hi_4_All Loops and building comma delimited strings

  The problem: I have 2 tables, with a one to many relationship - lets say customers, and order items. Each order record has a field that is meant to be a comma delimited list (they are reference numbers) that is driven by the quantity field. So, say in the order record, an item has a quantity of 3. The reference number will look like this: 1, 2, 3 And if the next order item for that customer has a quantity of 4, the reference number value is 4, 5, 6, 7 And the final item with quantity of 2: 8, 9 Reference numbers can either be auto assigned (and are in my web application) or manually set. If manually set they will NOT be numeric. In my web application, it is possible for users to return to a customer's order and ...Show All

• Corinna Vinschen Two log files generated using "c:\\" + @[System::ExecutionInstanceGUID] + ".log"

  Why are two log files generated when using a Text Log Provider with a Connection String property set to the following expression "c:\\" + @[System::ExecutionInstanceGUID] + ".log" I've set up package logging with a view to getting a unique, and linkable log. However, two files are always generated, no matter what the DelayValidation settings may be on the connection manager, file, and package tasks. Strange. I would guess this is something to do with the execution instance guid before logging begins (which I find strange actually). Hopefully someone from MSFT will confirm or otherwise. -Jamie Hi, If you are running the package from designer or in debug mode, it ...Show All

• John230873 Error Log shows message regarding I/O Requests taking longer than 15 seconds. Why?

  I noticed the following message in the error log last week: "SQL Server has encountered 50 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\mssql\dataDB1_Data2_Data.NDF] in database [DB1] (7). The OS file handle is 0x000003F4. The offset of the latest long IO is: 0x00000c71fec000" I get the feeling that this is not a database issue per se, but perhaps the engine informing me that it's I/O requests to the O/S are taking too long. Is that correct Can you point me to a document which discusses this topic Could this be a disk/controller issue Could this be caused by a poor distribution of database files across disk volumes Thanks Hi, I a ...Show All

• dizzyjay Data Source

  I have a problem connecting Visual Studio 2005 to my DataBase file. I've downloaded northwind.mdf . Three weeks ago I installed SQL express and I used Visual Studio in the following manner: From server Explorer tab I choose Add connection.. , Change data source and I selected Microsoft SQL Server Database File (SqlClient), next I've selected my NORTHWND.MDF and when I pressed Test connection , it succeded. Recently, I've purchsed SQL server developer edition. The problem is when I follow the steps above I reveive: An error has occurred while establishing a connection to the server, When connecting to SQL Server 2005, this failture may be caused by the fact that under the default SQL Server does not allow remote connections. ( provider: ...Show All

• Stéphane Beauchemin Clustering , how to start ?

  Dear Friends, i'm using windows 2003 server on both computers i wanted to practice clustering with sql 200/2005 [two nodes] but it asks for a quorum disk as a shared disk between the two clustered nodes, i didn't know what a quorum disk it, the internet when i searched for says that a quorum disk should be either a scsi or fiber channel disk, i've never seen a scsi disk, i'll purchase it today, but what i'm confused about is, how will i connect one single scsi disk two two computers/nodes i mean does a scsi disk have a long cable to connect to and if yes, then where does the cable fit in on either of the nodes, or is it not physcially shared then if it's logical then how do i configure it. pls reply soon, regards, and thanks ...Show All

• R.Tutus Transactions - Back to Basics

  Hi all, I am having no end of trouble with transactions in the package which i am building. I now just want to go back to basics and see if someone can tell me where i should set specific transaction options. Firstly, my package runs a for each loop which loops through a directory of directories. In each of the sub directories there are 2 files. The first steps in the loop are to check if a folder has been processed previously, if so then it moves it to a specified directory. The reason that this is done first is that i cannot move the directory whilst it is being read in the foreach loop, so i pass the path to the next iteration of the loop. There is another file system move directory task outwith the foreach loop to deal with the last di ...Show All