Answer Questions

• Mitch Walker - MSFT Retrieving Hierarchy Captions from a Cellset

  I'm trying to retrieve the hierarchy caption(s) for a given axis in a cellset, but whenever I try to retrieve this: cellset.Axes(0).Set.Hierarchies(0).Name I get an exception like this: System.ArgumentException was unhandled Message="The '[Date].[Calendar Quarter]' object was not found.\r\nParameter name: uniqueName" Source="Microsoft.AnalysisServices.AdomdClient" ParamName="uniqueName" StackTrace: at Microsoft.AnalysisServices.AdomdClient.CubeDef.InternalGetSchemaObject(SchemaObjectType schemaObjectType, String uniqueName, Boolean retryUniqueName) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetObjectData(SchemaObjectType schemaObjectType, String cubeName, String uniqueName) ...Show All

• Galoleins Better was to handle fixed width flat files?

  Is there a better way to handle fixed width flat files than the built-in SSIS capability I have a fixed width file with over 400 columns and it looks like I need to manually click lines where each column starts/ends (quite tedious and prone to error). I have an excel version of the spec with start position, length, and data type for each column. So far it looks like the only way to automate this task is to somehow automatically generate the package XML from the spec and paste it into the dtsx file. Anyone know of a better way Wow, it feels good to not be alone here! I did the exact same thing a few months ago when importing a data feed w/ about 250 columns. I was thinking it might be neat to either writ ...Show All

• bird.tw How can I create a DTS package to update a table with data from an Excel spreadsheet?

  Every month a client sends a spreadsheet with data which we use to update matching rows in a table in the database. I want to automate this using a DTS package but am having quite a bit of trouble accomplishing what I think should be trivial task. I've been attempting to use a Transform Data Task with a modification lookup but I just keep inserting the rows from the source excel spreadsheet in to the existing destination table without ever modifying the existing data. Any guidance would be greatly appreciated as to a best practice approach. How do you tell the DTS package how to find the records to update How do you tell it the connection between the spreadsheet columns and the table columns Basica ...Show All

• XycsoscyX lsass.exe high cpu, Error 18456

  We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000). We are experiencing two issues that we cannot resolve: 1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this The website uses a SQL user account, not a windows user account. 2. We have an error in the event log that might be related to the issue above. It appears every few minutes: Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 10/25/2006 Time: 11:54:42 AM User: NT AUTHORITY\SYSTEM Computer: MSDB Description ...Show All

• jbelisle Error trying to create cube partition

  I've converted 4 AS2000 databases to AS2005. In just one of these databases, I am not able to add any partitions to any of the cubes. As soon as I click the "New Partition" link, get the following error: The wizard will close because of the following error: An item with the same key has already been added (mscorlib). I get this error if I try to create a parition from either Visual Studio 2005 or SQL Server Management Studio. AS2005 version is 9.00.2047.00. I can add paritions to cubes in other databases on the same server. I've been all over looking for help on this, with no luck at all. If anyone can help me, I'd sure appreciate it. Most likely something went wrong ...Show All

• IanG Problem with connecting with sqlexpress 2005 on my host

  Hi I have a problem with sqlexpress I'm using sqlexpress 2005 with asp.net 2 and all things work in my computer good but when i upload it on the internet in my host it return this error : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I am using sql server locally and i'm not using it remotly i just created a simple page (just have a detailsview) and upload it to the internet and then upload my mdf and ldf files to the app_data folder Right out of ...Show All

• papadi Execute Process Task Error - The process exit code was "1" while the expected was "0".

  How do I use the execute process task I am trying to unzip the file using the freeware PZUnzip.exe and I tried to place the entire command in a batch file and specified the working directory as the location of the batch file, but the task fails with the error: SSIS package "IngramWeeklyPOS.dtsx" starting. Error: 0xC0029151 at Unzip download file, Execute Process Task: In Executing "C:\ETL\POSData\IngramWeekly\Unzip.bat" "" at "C:\ETL\POSData\IngramWeekly", The process exit code was "1" while the expected was "0". Task failed: Unzip download file SSIS package "IngramWeeklyPOS.dtsx" finished: Success. Then I tried to specify the exe directly in the Executab ...Show All

• h1 Custom data processing extension with dataset

  I have been getting to grips with writing a custom data processing extension for using a supplied dataset. I have got it working OK so far, but I don't see how to make use of relational data. There's plenty of code for walking through the fields, but nothing to walk through the tables. Since this clearly has to be possible can someone tell me where I'm going wrong Thanks John Williams. This seems extraordinary! Is there really no way of reporting on more complex data when using a data processing extension I suppose theoretically it might be possible to write one dpx for each table, using one table in the main report and one in a sub-report, etc. But when running the reports how would you pas ...Show All

• RonanDiniz SQL error number is 5110

  Background: Im creating an ASP .Net app in VS2005. Local machine has SQL express installed and server has developer edition of SQL 2005. When it tries to create the database file on a UNC share it comes up with an error " The file "\\server\Visual Studio Projects\Websites\PWSDelete\App_Data\Personal.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file \\server\Visual Studio Projects\Websites\PWSDelete\App_Data\Personal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. " to you guys the error message " The SQL error number is 5110 and the SqlException message is..... " ...Show All

• Saiboro How to delete rows in tables...

  I need to delete some rows in some of my tables after tranfering data from my OLTP to SQL database. Im using SQL 2000 I have tried with the following: Delete from fsalesinvoiceline Join dsalesinvoiceheader on Fsalesinvoiceline.salesid= dsalesinvoiceheader.salesid and Fsalesinvoiceline.company= dsalesinvoiceheader.company Where dsalesinvoiceheader.billtocustomerno=’INDTAST DEBITORNUMMER’ Go Delete from dsalesinvoiceheader Where dsalesinvoiceheader.billtocustomerno=’INDTAST DEBITORNUMMER’   I get the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'JOIN'   What am I doing wrong /Soren D. Jensen ...Show All

• GTrz tfs installation issue !!!!!!!!1

  i had SP1 of visual studio and TFS installed on my server but it didnt work and i had a server failure, so i removed the SP1 after doing this i had this error: " Team Foundation Server does not exist or is not accessible at this time. Technical information (for administrator): HTTP code 503: TF30059: Fatal error while initializing web service " after searching on line i found that there is problem in version number of Microsoft.TeamFoundation.VersionControl.Server.dll file so i changed it to be compatible with TFS version number. by dowing this the following erro appeared " Please contact your administrator. There was an error contacting the server. Technical information (for administrator): HTTP code 500: Inte ...Show All

• John Gunning How To Execute an Oracle Stored Procedure from DTS

  In SQL Server 2000 DTS How do I call and oracle stored procedure I've tried using the Execute SQL task with the Exec <my procedure name> ; and it errors. I've been searching for the answer on how to execute Oracle Stored procedures from DTS without any luck. The stored procedure creates the table and data that I want to pump into SQL Server. Any help would be greatly appreciated. Thanks! Hi Ewata, The syntax changes depending on the connection type you're using. What type of connection are you using ~Matt Connection type is Oracle provider for ole db When I put the following syntax in an execute sql task, I recieve an invalid SQL statement error: ...Show All

• Alex Farber Connection to DB from VB.net express

  When trying to connect to a db in VB.net express I get this warning An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) this is my code 'verbing maken mat de db Dim DBconnection As New SqlClient.SqlConnection( "Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Documents and Settings\Pieter Van Driessche\Mijn documenten\Visual Studio 2005\Projects\kasboek\kasboek\db1.mdf';Integrated Security=True;User Instance=True" ) DBconnection.Open() Can somebo ...Show All

• yjtsai Creating Partions on Developer Edition

  Hi, I was trying to partition my cube built in MSAS 2005 Developer Edition based on time dimension, however I was running into a lot of issues. I just read an article which states that cube partition is only possible on Enterprise Edition of MSAS 2005 can someone verify if it is true and if thats the case then why do they provide an option to partition the cube in the developer edition. Thanks I do these errors myself. A key is an integer but I write with a ' ' around it(or reverse). I do not think that my query bound partitions do subselects. It is a normal select query, with a where clause added for you, when I have tried it. Regards Thomas Ivarsson ...Show All

• RufusLDK replacing nodes and sub-trees

  Hi, I have an table where I use XML data type to store documents. The following is an example of original document: <!---ORIGINAL DOCUMENT---> <ABC> <xyz>.....</xyz> <xyz>.....</xyz> <gef>.....</gef> <qew>....</qew> </ABC> <!---NEW DOCUMENT---> <ABC> <xyz>.....</xyz> <gef>.....</gef> <reb>....</reb> </ABC> My question is how to update the original document so that the two previous instances of xyz tag are replaced by the new single xyz tag, the original gef tag is replaced by the new gef tag, and the reb tag is added to the original document as it is not not present ...Show All