Answer Questions

• Andrew Mercer Configuration Order

  I am trying to use the SQL Agent to specify the connection properties of the connection manager that supports all of the other SQL Configurations in my packages. It would appear that configuration files specified in the SQL agent job are applied after the other configurations. I have the same package I want to use under different configurations on the same machine. This package is also portable across to other machines. so cannot have any location information embedded in the package. Does anyone have a solution for this I had started out using Parent Package configuration until I discovered that small issue. I now have an XML configuration file, which is working fine. However I would like to hav ...Show All

• Whoisit Term Extraction frequency per row

  Is there a way to perform term extraction on each row in a table, and have the term extraction denote the frequency of the term on a per row basis rather than a per table basis Otherwise, is there a way I can take extracted terms and apply a sql function that returns the occurance of that term in each row Example: Row 1 = 2 hits, row 3 = 5 hits, etc. Then is there any way to take advantage of the normalization (i.e. stemming) functionality to turn records into normalized text No, sorry ...Show All

• Amos Soma SSRS and Teradata

  Is anyone out there using SSRS with a Teradata data source R First on the date thing, I cheated. I made a function that changed the datatype to the Teradata specific format. Function FormatTeraDate(byVal aDate As Date) AS String return String.Format("1{0:yyMMdd}", aDate) End Function I probably didn't need to make it a function, but I am thinking about creating an assembly that will have wrappers for Teradata specific things. On the multi-value, I don't have a good answer. What I do have is a way that work without the ALL option. First, I changed the SQL for the data source to a dynamic string ="SELECT Fld1, Fld2 FROM TBL1 WHERE " WHERE Fld1 in ('" & Join(Para ...Show All

• Chimme Install problem

  I am having a problem installing SQL express. I have 2.0 framework installed as well as the other express software. I also have Visual Studio 2003 installed. Do I need to uninstall other version of Visual Studio Do I need to uninstall other versions of SQL. I get an error but it does not tell me what the problem is. Thank you Dee Thank you Dan, I have posted there. Dee Also can we somehow add the icons for the install to our desktop, if so how Dee No, the exec to start the program, but someone answered that for me. Thank you I posted a reponse to this in your other posting. See: http: ...Show All

• pkr2000 Simple copy table data fails after 7973680 rows

  This is the error I get with a simple Data Reader Source (SELECT * FROM A) to SQL Server Destination copy between identical tables from a linked to a local server: Error: 0xC02020C7 at Copy INTERMEDIATE_Billing From swdatastaging, SQL Server Destination [373]: The attempt to send a row to SQL Server failed with error code 0x80004005. Error: 0xC0047022 at Copy INTERMEDIATE_Billing From swdatastaging, DTS.Pipeline: The ProcessInput method on component "SQL Server Destination" (373) failed with error code 0xC02020C7. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. Error: 0xC0047021 at Copy IN ...Show All

• Carel Greaves Upgrade SQL express database to SQL server Standard database

  Can I upgrade SQL express database to SQL server Standard database Please give information to me! Thank you! Thank you for your information. Yes, you can upgrade from Express to Standard. Just pop in the Standard media and start the installer. On the instance selection screen, select the name of the Express instance, and continue. This will upgrade the instance and allow you to add the new components you selected. If you do not select the Express instance, it will install the SQL Standard edition side-by-side. Thanks, Sam Lester (MSFT) ...Show All

• rholder Select Statements in SQL 2005

  I know this is probably a dumb question but I need to find a for sure answer on this. When a developer writes SELECT statements in their code will the * clause work with SQL Server 2005 We have tried to discourage such activity but has not worked. We are in the process of moving our systems to SQL Server 2005 and wanted to know if this would be a gotcha. Thanks for any advice, comments on this subject. Jeremy Is there an article out there that explains what syntax is allowed with T-SQL in 2005 Thanks, Jeremy Jeremy: For one thing, select * leaves "land mines" in stored procedures. What happens is that the meaning of select * is determined at stored procedure compile time and n ...Show All

• el-chema Volatile Storage

  I am new to windows mobile development, and I am looking to create an application (C#) which uses the SQL server CE. I am curious what to do about data loss. I have a Windows Mobile 2003 PDA, which means half of my storage is main memory (volatile) and the other is built in storage (no volatile). I expect I would want to install my application to the main memory, along with the database. I Planned to give the user the abililty to select a subset of properties for running the application and storing them in the DB for running. But if the user's battery runs out I wouldn't want them to loose all of the information in the database (ie configurable property selections chosen by the user). If the user looses the application, I plan to h ...Show All

• jamarnkin Data script task - how to generate multiple rows from one row ? (string splitter)

  Hi in input we have a set of rows, each one with a column containing a string (eg: "AAOOOOAAAOOA"). We'd like to split this string (using a vb.net data script task) into tokens (eg: "AA", then "OOOO","AAA","OO","A"), and to output one line per token. How can we achieve that with a vb.net data script task (Or anything else ) best regards Thibaut DarrenSQLIS wrote: Phil, I agree in principal, the native stock components should be faster as a rule, but have you got any references Yep, no problem... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=857796&SiteID=1 Just be careful because some have tested the script task and ...Show All

• BobishKindaGuy Error in initialization of the report service

  I installed the evaluation version of SQL Server 2005 to my Windows XP machine. Everything has worked well. Now I have problem. I installed the reporting service to test the web reporting. In the Report service configuration manager I get three errors: The Web Services Identity indicator is red and pushing Apply button gives the error : ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B Pushing Initialization button gives the message: There was an error while switching panels. The most likely cause is an error retriewing WMI properties. the exeception details are: An error occured when attempting to connect to the report server remote procedure call (R ...Show All

• Radith Problems with SQL 2005 Export Wizard

  I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site. I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting: TITLE: Operation stopped... ------------------------------ The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ------------------------------ ADDITIONAL INFORMATION: The package failed to load due to error 0xC0011008 " ...Show All

• Szymon Kosok Error code: 0x80004005

  I created a package that refreshes tables on one SQL Server to another SQL Server. First, I use an ExecuteSQL task to truncate the tables. Then I use a Data Flow task to copy the tables from one server to the other. Finally I update a log table. It was working fine with four tables. I added another table to the refresh and now I get these error messages: [Source - RbcAcctSegment [1096]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". ...Show All

• Anarchy Buttons

  Hi. Is there a way to insert a command button or flash button on to a report im using SSRS 2005 with VS 2005 Thanks... I can't think of a way. But what about the effects of a button Are there any rollover or click events You can't put standard controls on a report just specific RS controls. You could put an image of a button and have some click through action on it. ...Show All

• hoobler How to Upgrade sql 2005 dev to enterprise

  Hey, I tried the skuupgrade=1 and it appeared to want to install a whole new instance. This operation was supposed to recognise what to upgrade and what instance to do (there is only one). Can some send me some detailed instructions on how to upgrade my sql 2005 developer edition to the enterprise edition thanks Terry When you run the setup.exe, it 'should' find the installed instances, and ask if you wish to upgrade or create a new instance. Did you run setup.exe from the dvd/cd more or less...had to copy the contents of the cd to the hard disk..no dvd installed on the machine.... ...Show All

• Bubo your SQL Server installation is either corrupt or has been tampered with

  I got the above message when my system started. I uninstalled everything, but had problems uninstalling the desktop engine. An attempts to reinstall just hung at "Please wait while Windows configures Microsoft SQL Server Desktop engine". I used the MS recovery tool to remove the desktop engine. After that running install would progress further thru the above dialog window, but then the progess bar just zipped backward and the dialog box disappeard. Nothing! No message or anything. How do I clean up this mess Thanks, -- Frank Is this for SQL 2000 (MSDE) Do you have any SQL related entries in your Add/Remove Programs list What install are you trying to run when you get the error Thanks, Sam Lester ( ...Show All