Answer Questions

• Maxim Michtchenko Propery expressions: Values not updated

  I see some strange behavior when running a package using the SQL Server Agent. The package I run calls a number of child packages, in which I use property expressions to set - among other things - the path to text files I read into a database. The property expressions are in the form: @[User::ThePath] + " \\TheFile.txt ". The variable ThePath is read from an XML configuration file at runtime from the "master" package and passed on to the child packages using a parent package variable configuration. My problem is this: When the package is executed by the SQL Server Agent, the properties for the path of the text files are not updated, and the package fails, as it cannot locate the files. When using DTExecUI to execu ...Show All

• Ruben Leal Printing differences between RTM and SP2

  Using SQL Server 2000 SP4 and SQL Server 2000 Reporting Services I'm using the code from http://blogs.msdn.com/bryanke/articles/71491.aspx and have discovered a problem with the printed report between the RTM version of Reporting Services and SP2. Our development server had not been upgraded to SP2 and using Bryan's code the reports were printing without any issues at all. Now the server has had SP2 applied the report footer is missing and data on the right-hand margin is truncated. Anyone got any ideas why this would be the case What can I check to see why this would be happening Thanks I'm not sure what would have changed to cause this behavior. The only other thing I can think to try i ...Show All

• Bernhard Huemer How to Fail SQL Task...

  I have several packages that I download files using a sql task (I cmd shell out). I use sql task because the file names change everyday.  what I want to know is how can I check to see if the file I downloaded exists either within the same task (preferred) or a task right after I want to fail the package instead of letting it get into the actual loading of the file where it now fails at. I hope this makes sense. I know about doing the script option but what I asked was to do it in a sql task. The reason being that since I cmd shell out to do a process on a file even if the file is not there the task does not fail. I guess my option is to break my process for the file (1 step) into 3 st ...Show All

• Jigar Lakhani BCN service questions

  Hi some questions about BCN service : - WE have several remote clients and we don’t know their addresses. - We create a BCN Service for dynamic routes configuration. - Each time we send a message to a specific user message is sent to BCN asking for a route - Messages for a specific user can have specific conversation group id ( Question : if we send several message to the client with no route does it mean that there will be several messages to BCN . My guess that “missing route” message is sent to BCN for every new conversation but not for several messages inside one conversation. ) - BCN service doesn’t answer immediately because it doesn’t know the address ...Show All

• BuNnY_MoOn Need help with pivot or is this even possible using pivot?

  Hi, I need help with my problem. I have this set of tables that I query that will produce this result set. SeqID Time ProductName DataValue Tag 1 '1/1/2007 10:00' Tea 30 1 1 '1/1/2007 10:00' Soy 25 1 1 '1/1/2007 10:00' Coke 40 1 1 '1/1/2007 10:00' Beer 75 1 2 '1/1/2007 10:05' Tea 38 1 2 '1/1/2007 10:05' Soy 29 0 2 '1/1/2007 10:05' Coke 32 0 2 '1/1/2007 10:05' Beer 44 1 3 '1/1/2007 10:10' Tea 26 0 3 '1/1/2007 10:10' Soy 35 1 3 '1/1/2007 10:10' Coke 28 1 3 '1/1/2007 10:1 ...Show All

• Penny Ong Determine Processor Architecture for SQL Server 2005

  Determine Processor Architecture for SQL Server 2005 I like the new features in SERVERPROPERTY but there's a huge, glaring oversight in my opinion: it doesn't return the processor architecture. I'm trying to write a detailed server info collection script and (1) use only TSQL, and (2) have it return the processor architecture. Here's what I have so far: SELECT SERVERPROPERTY('InstanceName') AS [InstanceName] , SERVERPROPERTY('ServerName') AS [ServerName] , @@VERSION AS Version , CASE WHEN CHARINDEX('Intel X86',@@VERSION)<>0 THEN '32-bit' WHEN CHARINDEX('Intel IA-64',@@VERSION)<>0 THEN '64-bit' -- WHEN CHARINDEX('x86-64',@@VERSION)<>0 THEN '64-bit' -- WHEN CHARINDEX('AMD64',@@VERSION)<>0 THEN '64-bit' -- W ...Show All

• Azaz CY and LY comparison

  Hopefully an easy one: I would like to get a CY comparison vs. a LY comparison of sales between offices. The problem I am running into is the performance of the query. When I try below, it works, but it is painfully slow (I believe the SUM is what is killing it): With Member [Measures].[CY Sales] as Sum (( [Org].[Reg - Pctr - Office]. CurrentMember , [Calendar].[Date].&[20061101] : [Calendar].[Date].&[20070220] ) , [Measures].[Sales] ) Member [Measures].[LY Sales] as Sum (( [Org].[Reg - Pctr - Office]. CurrentMember , [Calendar].[Date].&[20061101]. Lag (52 * 7) : [Calendar].[Date].&[20070220]. Lag (52 * 7) ) , [Measures].[Sales] ) Select { [Measures].[CY Sales] ,[Measures].[LY Sales] } o ...Show All

• wakjah Create Time dimension Year, Week, day problem

  Hi, I have a problem when creation a Time dimension Year, Week, day , The week does not start on the correct date eg. Week 42-2006 should start on 16 th. october and end on 22 th october, but in this case it starts on the 15th october and ends on the 21 october. So what happens is that it starts 1 day before it actually should. This is my Time Dimension: DatePart(year,"dbo"."fCapacityLedgerEntry"."Posting Date") DatePart(week,"dbo"."fCapacityLedgerEntry"."Posting Date") 'Week ' + convert(CHAR, DateName(week, "dbo"."fCapacityLedgerEntry"."Posting Date")) convert(CHAR,"dbo"."fCapacityLedgerEntry"."Posting Date&quo ...Show All

• ivanchain SQL Server performance being a problem.

  I'm porting over a C# web application from MySQL to SQL Server, and so far I've gotten it up and running, but the performance is just terrible! I'm using the following script to connect to the database... <source> string TheConnectionString = "Server=PETER\\SQLEXPRESS;Database=Frostwinds;Trusted_Connection=Yes;"; MySQLConnection = new SqlConnection(TheConnectionString); MySQLConnection.Open();</source> .. and takes seconds to complete. Any ideas why performance is soo bad I guess maybe it is the provider, or app after all... SNMSDN wrote: Once you put it on Apache I'd say there's a fair chance that the problem is with your ap ...Show All

• GrahamY Update and Delete aren't working in Visual Web Developer 2005

  I am using VWD Express to access the SQL database. I can succesfully View and Insert. When I try to update, the form appears and allows me to enter my changes, but when I click the Update button it reverts to the previous table and the changes are lost. No error messages appear. If I press the Delete button, nothing happens. I have tried this with the GridView, DataView, and FormView controls with the same result. I have tried this with an Oracle 10g database table and it works correctly, but I can't get it to work with any tables on the Microsft SQL server. Thanks for your assistance. I found the problem. I had Use Optomistic Concurrency checked. For some reason that caused the problem. ...Show All

• sanaltsk Expression

  Hi, In RunningValue expression, can we able to put the DataSet name. Thanks Mahima, Can you mark this as answer this way other will see our solution. Ham Hi, yeah, The Child male/Female are from the same DataSet as Adult male/female records. Hi, Hammer, Can you look at the following problem.In this case what i have to use in the Runningvalue. Hi, In my report, i have 3 tables joined together.My requirement is the fllowing table Age male Female Total Cumulativetotal 1 40 10 50 50 2 20 5 25 75 .. .. total children 60 15 ...Show All

• Mark Asztalos Invalid Column Error - Any ideas

  Hi, Can anybody point me why I get the error "Invalid Column Name - emp" error. Thanks. Table structures are: Tree create table tree (emp Char(10) Not Null, Boss Char(10)); Stack CREATE TABLE Stack (Stack_top INTEGER Not Null, emp Char(10) Not Null, Lft Integer NOT NULL UNIQUE CHECK (Lft > 0), Rgt Integer NOT NULL UNIQUE CHECK (Rgt > 1)); I am trying to convert the Tree (Adjancency Model) to Stack(Nested Model). CODE BEGIN DECLARE @lft_rgt INTEGER, @stack_pointer INTEGER, @max_lft_rgt INTEGER; SET @max_lft_rgt = 2 * (SELECT COUNT(*) FROM Tree); INSERT INTO Stack SELECT 1, emp, 1, @max_lft_rgt FROM Tree WHERE boss IS NULL; SET @lft_rgt = 2; SET @stack_pointer = 1; DELETE FROM Tree WHERE boss IS NULL; ...Show All

• eitanb Link Report

  I have a report A under FolderA , I created a link report for reportA under Folder B. I am trying to access the names of the reports under FolderB through ASP.Net web application. But when I do this the link report name is not being displayed since it has the path \FolderA\ReportA. But the report is visible in the report manager under folder B. Is there a work around to display the name of the link report.please let me know. Thanks!! SqlNew The link report name "does" appear !! it was problem with refresh. ...Show All

• builtsoftware Using For Each Loop container to pass parameters to command utility

  Hello I want to use a for each loop container to go through all files listed in a particular folder. Each of those file names must be passed as a parameter to the relog.exe command utility example: Folder C:\temp Files in C:\temp: log1.csv, log2.blg, log3.txt The following lines must be executed: c:\relog.exe c:\temp\log1.csv -f SQL -o "SQL:PerfCounters!PerfCounters" c:\relog.exe c:\temp\log2.blg -f SQL -o "SQL:PerfCounters!PerfCounters" c:\relog.exe c:\temp\log3.txt -f SQL -o "SQL:PerfCounters!PerfCounters" The relog utility converts the performance counter logs to sql format and pumps it in the database (DSN:PerfCounters) The idea is that someone drops multiple counter logs in c ...Show All

• Nagu Package abort if sqlserver connection failed

  Hello, I am connecting with various sqlservers in a package to get the information. If connection failed with any sqlserver, package failed after 3 tries. I would like that if connection failed with any sqlserver, package should not end rather move ahead. I already tried to increase the number of error from 3 to 1000 but still package failed as soon sqlserver connection failed. Any help is appreciated. Thanks. ...Show All