Answer Questions

• Jim Harrison IsaDewd How to import cube definition from SSAS 2000 to SSAS 2005

  Hi. I have a SSAS project CAB-file created in SSAS2000 and would like to import/convert it to a SSAS2005 project but I can't find any way to do this... Does anybody know how this is done  Any suggestions would be greatly appreciated! Regards Kjetil Hi, The error occurs in the validation page (where there is a tree with the AS2000 objects) or on the next page (migration page - where the scrip ...Show All

• Mr. Furious Can't Design a Script

  I've placed a Script Task in a package, but the "Design Script..." button only closes the dialog and nothing happens. I've tried a Script Task in an empty package, too. This is a vanilla 2003 virtual PC. No previous beta/CTP versions installed. RTM bits of SQL 2005 and VS.NET 2005 Pro. I can edit macros in VS.NET, so I'm sure the VSA environment is around. No event log entries. Typically run as non-admin, but tried as admin, too. Anyone e ...Show All

• Asian Dragon Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?

  Until there's an Integration Services 2.0, what custom components would you most like to see examples of The documentation team is starting work on the 2nd Web refresh of Books Online and SQL Server samples, anticipated for release around April, and may be able to incorporate some requests as samples or BOL topics. I scanned Kirk's "Requests" thread and, although many requests are for tweaks to existing SSIS widgets, I noted the following ...Show All

• lochew Unable to execute SQLCMD using System.Diagnostics.ProcessWindowStyle.Hidden

  For some strange reason, I am unable to use the SQLCMD utility hidden. My code is preety straight-forward, I use it to enumerate a list of available servers and I can't use SMO since it requires Windows XP SP2 and my application may be installed in Windows 2000. My code looks like this... ProcessStartInfo startInfo = new ProcessStartInfo (); startInfo.Arguments = "-Lc" ; startInfo.CreateNoWindow = false ; startInfo.FileName = "sqlcm ...Show All

• Ray Hayes SQLAgent running SSIS corrupting offline cubes?

  Hello- I've an SSIS packeage that genrates offline cube (.cub) files via an MDX query run against an Analysis Services cube. When I run the package through the Management Studio all runs fine and the cube files are generated and can be used by excel. However when I run this package through a SQL Agent job the files are generated and the job completes successfully , but when I try to open them in Excel they appear to be corrupted and I th ...Show All

• Chris A. Palmer Reporting Services 2005 - Showing wrong version

  Hi I installed RS 2005, SP1 and then the rollup fix 2153 however; if I run http://server/reportserver or view the reportserver log file, it shows version 2047 which is the SP1 version. I have added the tail end of the rollup hotfix log file which shows I have installed it. Is this a known issue 06/14/2006 16:03:57.153 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Servi ...Show All

• NicoVan error applying initial snapshot

  Hi Using HTTPS web synchronisation - merge replication. I have a very strange error where it bombs out half-way through downloading the snapshot Downloaded a total of 3 chunks. Downloaded snapshot file 'snapshot.pre'. Downloaded snapshot file 'myView_6.sch'. Downloaded snapshot file 'table2_2.sch'. Downloaded snapshot file 'table2_2.cft'. Downloaded snapshot file 'table3_3.sch'. Downloaded snapshot file 'table3_3.cft'. Downloaded snapsh ...Show All

• cpk How do you backup a database using sql server 2005 express???

  I know there isn't a backup feature but I was wondering if there was a way to back up a database Thanks!!! hi, download SQL Server Management Studio Express, http://www.microsoft.com/downloads/details.aspx familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en , connect to the desired instance, navigate to the database you are interested in.. right click, tasks, backup... the backup dialog ...Show All

• David Zeller How to incorporate exec sql describe select list

  Hi, What is the "EXEC SQL DESCRIBE SELECT LIST" equavilent in .NET using MS SQL Server Thanks in advance. If this gets the metadata of the result then you can just look at the SqlDataReader object returned by calling ExecuteReader for example. There are many ways to do this depending on your requirements. Check out the .NET SDK on SqlCommand object for some examples. ...Show All

• Ashish Kumar Newbie question about indexes

  Hi , I have following statement : SELECT * FROM Table WHERE Col1=@Var1 AND Col2=@Var2 ... AND ColN=@VarN How should I design indexes for best performance ( Add one index on columns Col1 till ColN or add N indexes, first for column Col1, second for Col2, ... ) Thanks, for your suggestions Here's what the optimizer guys have to say: One index should be fine if he always has every column in the WHERE condition and he is doing equali ...Show All

• Devang Khandhar SQL Server 2005: Upgrade to Aug CTP VS.NET invalidates CLR

  I get the message that (CLR) v2.0.50215 not installed properly. The August CTP release of Visual Studio seems to be installed properly. Does this mean that both SQL Server 2005 and VS.NET have to keep versions synchronized I guess so. I might add that this is under XP 64) VS June, July and Aug CTPs are not compatible with any SQL Server build, they will be in Synch again for the next CTP and for RTM. ...Show All

• freon SQL Server 2005 and RDO compatibility

  Are there any known issues with using RDO with SQL Server 2005 My company is in the process of updating our SQL Server 7 database to SQL Server 2005. Most of our applications are several years old and written using RDO to access the database. I have since started the daunting task of updating all the applications to ADO, but it's only about a quarter of the way done. We need to update the database ASAP, but we cannot wait until all the ...Show All

• odcit Error in Adding Maintenance Plan

  Below is the Error ( I have SSIS installed ; when I open Business Intelligence Studio it lists SSIS as installed) Maintenance Plan Wizard Progress - Creating maintenance plan "Backup xxxDatabases" (Error) Messages * Create maintenance plan failed. ------------------------------ ADDITIONAL INFORMATION: Create failed for JobStep 'Subplan'. (Microsoft.SqlServer.MaintenancePlanTasks) For help, cl ...Show All

• Greg Fiore help coverting a varchar to a float

  Hi, I'm using the following code to convert a varchar to a float in a trigger. declare @acre varchar (6) set @acre_size = 0.0 select @acre = plotsizeacre from inserted declare @num int select @num = isnumeric (@acre) if @num = 1  set @acre_size = @acre This normally works fine, but I'm getting errors if the plotsizeacre field is 1,75 Casting to a float or converting to a float also gives errors.   Any idea ...Show All

• SimonGUK Value "+00000000000000" considered as NULL values in the last column

  Hello I use a Flat File Connection Manager for a file with 18 columns. My column delimiter is the "~" caracter and my row delimiter is "{CR}{LF}" The source files contains about 2300 lines. None of them contain NULL values. My last row is a numeric(16,2). Even if it is not the appropriate type for the value I want extract, it works with all my columns. My problem is with the last column. I have read the SQL Server 2005 interpretat ...Show All