Answer Questions

• Amos Soma #&^%@#$ Report services...... OMG how do you set a report parameter in code....

  Here's the error message.. Unable to cast object of type 'Microsoft.Reporting.WinForms.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WinForms.ReportParameter]'. Here is the code Dim rp = New Microsoft.Reporting.WinForms.ReportParameter Me .RV1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote Me .RV1.ServerReport.ReportServerUrl = New Uri( "http://10.1.1.138/ReportServer/" ) Me .RV1.ServerReport.ReportPath = "/test/rEmailInvoice" rp.Name = "InvoiceNumber" rp.Values.Add( "0618050" ) Me .RV1.ServerReport.SetParameters(rp) <--- get error message here. Me .RV1.ShowParameterPrompts = False ...Show All

• AE from SFO retrieve AM or PM

  HI Chaps very simple question this time Is there any method availabe to retrieve AM or PM value from date, IN TSQL hoping will get answer shortly regards, Anas I always use something like this: Select Case When datepart (hh,@datevalue) < 12 Then 'AM' Else 'PM' End I JUST NEED THE VALUE AM OR PM NOT THE COMPLETE DATE you want quick and dirty (filthy dirty)- well here you go SELECT substring(convert(varchar(26),@dtVal,109),25,2) AS AmPm obviously you can use any date format that contains Am Pm and substring appropriately Any of these maybe select convert(varchar(20), getdate(), 100) -------------------- Aug 10 2006 4:10PM select conver ...Show All

• Leah Phillips Error 29515 - Encryption not supported on client - wtf??

  I have tried reinstalling the sqlncl.msi - re-booting etc without success. I'm on windows vista beta 2 build 5384. Brand spanking new machine (less that 48 hrs old) and I can't beleive my bad luck with sql express.  My xp pro machine works fine.   Hers's the error: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. For help, click: http://go.microsoft.com/fwlin ...Show All

• doener Report Builder Report Possibility?

  This may not be possible, but I wanted to see what some of the experts' opinions are here. One of our users has created a report in Report Builder. I want to take this report, post it to a folder and allow her employees to run the report. I've put it in a folder called "Reference Line Reports" and gave browser permission to a list of users. These users are able to run the report (without having access to Report Builder or the report model). When they try to utilize the "infinite clickthrough" functionality, I get the following error. The permissions granted to user '<domain>\<username>' are insufficient for performing this operation. (rsAccessDenied) If I give one of these user ...Show All

• tee_user5 ForeachFile and ForeachItem

  Since I installed SP1, I do not see ForeachFile and ForEachItem anymore as possible collections in the Foreach package, What went wrong Thanks for any advice. Still could not solve this (annoying) problem (need ForEach File) Can somebody please help thanks, I've installed SQL Standard edition this weekend (with lots of problems, had to reinstall windows, visual studio did not install) and since then I have the mentioned items. just discovered another (very) big problem though, not one of my SSIS packages works, every time I want to edit the data flow, Visual studio crashes, any experience with that You may have to make s ...Show All

• Finkster Could not Authenticate with SQL Server

  Here's my situation and I've spent enough time to troubleshoot. Any help would be appreciated. 1) I have a VB.NET Windows Form Application that uses SQL Server Express 2005 database. 2) The "mdf" file is a part of the application itself. 3) When the application distributed to my clients using Windows XP SP2, the "Click Once" installer automatically installs SQL Server 2005 Express [which is a pre-requisite] and copies this mdf file into the application folder. 4) The authentication mode is "Windows Integrated" The problem is, when the application is launched [while logged in as the local system administrator in a given computer], it is unable to connect to the SQL Server. I get the following error, Failed to generate a user instance of S ...Show All

• Karma Patrol Using ALL in a prompt

  I'm trying to follow Cris Hays's instructions on adding 'ALL' to a prompt. I added it to the selection list with the query ---------------------------------------------------------------------------------------------------------------------------------- Select 'ALL' as [Business Unit Code] Union all Select Distinct [Business Unit Code] FROM BL_CQ_LQ_Compare2 Then I added it to the base query ------------------------------------------------------------------------------------------------------------------------------------- SELECT [Strategy Code] AS Strategy, [Gen Number] AS GenNum, [Mat Number] AS Material, FROM BL_CQ_LQ_Compare2 WHERE ([Business Unit Code] = @BUCombo) OR ('All' = @BUCombo) ORDER ...Show All

• DavidAragornHouse Delete files older than 3 days using SSIS tasks

  I want to delete all files in a given folder that are older than 3 days from today's date. I tried using a "Foreach Loop container" with a "File System" task inside it but found I couldn't access any file properties such as the file creation date. Am I using the wrong task for this job TIA, Barkingdog P.S. History of the problem: I used the sql 2005 Database maintenance program to setup our database backup jobs. One day I noticed that the free space on the drive where we keep the dumps had grown small. I found that we had at least 4 weeks of dumps in there, not the 3 days I wanted to keep! I looked but could not find the "delete file" option in the SSIS package generated by the Data ...Show All

• Sonic.NET AGGREGATE doesn't do MIN/MAX on textual columns

  Hi, Can anyone from MS exaplain why the AGGREGATE component doesn't allow you to select MIN/MAX when the column is DT_STR/DT_WSTR Thanks Jamie OK thanks Donald. Sommeone on this forum was indeed asking for it and when he asked why it wasn't there I couldn't answer him. Eventually he used, as you say, a script component. -Jamie Phil Brammer wrote: It'd be better to allow for the aggregate functions to work as they are supposed to according to the MS Transact-SQL documentation. Why SSIS is an ETL-tool, not a relational database. Nowhere in the SSIS documentation does it state that there is any adherance to T-SQL, ANSI SQL or any other SQL dialect. I agree that the AGGREGATE should ...Show All

• Jakobdo Automatically open a default project on application launch

  I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches. Perhaps there's a certain registry key I could edit The best place to ask that question is in the following forum " SQL Server Tools General " Thanks Michelle ...Show All

• xlordt JOIN Filters and Non-numeric Keys

  I expect that this is not possible but: I've created a initial filter on our tblLocation. I've created a join filter on the header table for our inventory data. I've create a join filter on the header table for our inventory detail data. The joins between the inventory header table and the inventory details table is on a three field key which are of type nvarchar. When I try to sync a subscription, I receive an error which indicates that it cannot bulk copy into the inventory details table on the subscriber because it would create duplicate keys. There isn't any duplication at the publishing server so, I expect this has something to do with the data type of the key/join fields. Am I correct If so, is there a workaround. ...Show All

• Alexnaldo Santos Issue with checkpoints and Event handlers

  Hi, We are currently facing an issue in ensuring restartability of an SSIS package. The scenario is explained below. Context: The SSIS Package has two Data Flow tasks. The Data Flow task named DFT1 is the predecessor for DFT2 and chained with OnSuccess precedence constraint. OnPreExecute and OnPostExecute event handlers have been implemented for DFT1. Each task in both event handlers as well as DFT1 and DFT2 have FailPackageOnFailure set to True. Scenario1: Task in OnPreExecute of DFT1 fails. DFT1 is attempted and succeeded. OnPostExecute of DFT1 was not attempted. DFT2 was not attempted. Checkpoint file was created; however, no entries were made. When restarted, execution star ...Show All

• Tryin2Bgood Time Series -

  I m using the Time Series Algorithm to forecast sales across regions for various products. Assume the model is built with last 3 years data with the periodicity being monthly. Is it possible that sometimes I can make predictions based on just 1 yr or 2 yrs data for certain products alone or certain regions alone Can this be done without having to retrain the already built model Also, is it possible that using the model, i can predict week-wise / month-wise / quarterly sales as well In general the answer is "no". However are you saying that a) You don't have 3 years of data for all data or b) You have the data, but don't want to use it. If the answer is (a), you can use the Missing Value Substitition paramet ...Show All

• CarlosV auto resizing column

  hi all i am working on sql reorting 2005 how can i set the column width to autoresize depending on the maximum length of data for that column plz help me. As far as I know, there is no way to autoresize column width. The only property to account for adjusting a cell's dimensions is "CanGrow." If this is set to True, the cell will increase vertically to fit all the data. However, this only adjusts the height and not the width. ...Show All

• SydIlBradipo SQL CE and SQL Server 2005

  I have seen some referrences to this on this forum, but nothing specifically dealing with our question. We would like to use SQL Server 2005 on the server side, but need to keep using the SQL CE version on our mobile due to the OS. I'm assuming this is possible, but seem to be unable to find this discussed in any of the publications. Can anyone point me to the appropriate articles Thanks. yes, this is a supported scenario for both RDA and merge replication. See row #4 in the matrix included here: http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx -Darren ...Show All