Answer Questions

• Robert The Doctor Management Studio Express CTP update now available

  There is a new Management Studio Express CTP download available at   http://www.microsoft.com/downloads/details.aspx FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en . This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting.  With the update, Management Studio Express and Books Online no longer interfere with each other. To update Management Stu ...Show All

• rgreene_nl How to address hierarchies with different # of members in lowest level

  I have a cube with 2 hierarchies for Geography dimension 1) Standard Hierarchy: Levels (ALL-> Group -> Division -> Region -> Country) 2) Custom Hierarchy: Levels (ALL -> Country) The lowest level is the same in both hierarchies (COUNTRY), but I have different # of Countries for each hierarchy. I will have 3 possibilities for the Country Level: 1) Countries that are in both hierarchies 2) Countries that should be ...Show All

• ayacenda Migrating db's from 2000 to 2005 results in truncated columns???

  Hi all, Today I stumbled across something very strange. A couple weeks ago we migrated 2 servers from sql2000 to sql2005, and changed the default colation at the same time. The way I did it was I backed up all the user databases to *.bak files, uninstalled sql2000, installed sql2005 using the new default colation, and restored the databases. Today we discovered any columns that used to be char(xxx) were truncated to char(255), and t ...Show All

• Koya Timeout expires when deploying assemblies in SQL Server 2005 June CTP

  I am encountering a timeout expired error when deploying a .NET assembly in SQL Server 2005 using Visual Studio.NET.  I already enabled SQL Server for CLR.  Whenever I run the CREATE ASSEMBLY command in SQL Management Studio, my query just ends up executing without stopping. Can anybody help Did you try increasing the timeout Project Properties -> Database -> Connection String -> Browse -> Add New reference -> Ad ...Show All

• PersonalBushido SSIS Doubts

  I am having this question in my mind from when I started using SSIS.. In a package I have an OleDB source and a flat file destination. and I hook up the source to destination in SSIS and run the package.. it works .. fine.. but internally what is done does SSIS performs BCP out Going from OleDb to flat file it just reads the data. There is no Bulk option for reading data out of SQL, because it doesn't have t ...Show All

• venkee DTC - Transaction context in use by another session

  Hi I have a master package that executes a series of sub packages. The master package is run from a SQL Agent job. The packages are reading from and writing to two databases on the same instance of SQL Server 2005. If I set the Execute Package Tasks for the sub packages without any precedence constraints between them and set TransactionOption = Required at the master package level (and supported from there downwards) I get the following ...Show All

• StallionLZ Open Report Builder and Link to Report Directly?

  Hi, I've created a simple webpart that lists all the reports that a user has created using the Report Builder and next to each line item is an "Edit" link. What I would like to do is open up the Report Builder application and pass a parameter of the report path or something like that so that report builder opens up the report automatically. Is this possible Thanks Tristian THanks, this ...Show All

• ozForever ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC ...Show All

• Carriage1 Password Protected Excel File

  Hi I'm in need of a bit of assitance here.  Basically I am currently creating a SSIS package which works in principle with the exception of my data flow.   On my data flow I am reading an excel file using the excel source, this works fine for a number of my examples but one of the excel files is password protected.  This is throwing an error when I try to run the package. Does anyone know how to read a password protected ...Show All

• Rahim2 unhandled exception when using management studio

  Hi guys am getting unhandled exception when scrolling thru objects in object explorer in sql server management studio. it happens intermittently when i click different objects like diagrams,tables etc., any help on this much appreciated. BTW previously i had RC1 but now i have standard edition.i used get similar error with RC1 also. the error i get is "Unhandled exception has occured in a component in your application.if you click continue, the ...Show All

• mok Change query issues

  I am trying to take this statement: Select Total = SUM(gt) FROM (Select Distinct CustomerName, CustomerNumber, FeeGoal_AZ AS FG, FeeSchedule, (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS gt from DCR WHERE branch='00002' group by CustomerName, CustomerNumber, FeeGoal_AZ, FeeSchedule ) as dTable and change up (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS ...Show All

• Anthony Dewhirst Splitted char values in table

  Hi, I have the following content in one column of a table (each line one row, only 'underscore' seperated char): x_y 1_2_3 A z_X_c 9_2 I need to split this values (seperated by '_') and write each value into a new table. The resulting table with one column, shall look like: x y 1 2 3 A z X c 9 2 It is not the problem to split the char in single values, the problem is to seperate each value into one row. Thanks for the help, marc ...Show All

• MuddyTigerFeet Unable to install SQL Server 2005 Standard

  I am trying to install SQL Server 2005 Standard Version on my IBM Thinkpad running Windows XP (SP2). I am installing from the CD that was given out to attendees at the Visual Studio 2005 Launch Event. The install is failing on the SQL Database Services with the following error: SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]. The default full-text language is no ...Show All

• mladjoboy Attempt to fetch logical page error

  Hello, I have recently moved some dts packages I had been working on from my development(sql2k5) to production environment(sql2k5).  Having come across many configuration related errors, I believed my latest one to be of this type at first.  However I'm recieving one I've never seen before: "Attempt to fetch logical page (1:95152) in database 8 failed. It belongs to allocation unit 72057594043301888 not to 72057594045661184.". Possible ...Show All

• kogkog "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All