Answer Questions

• Isythica For Each Container for XML Source Adapter

  I know how to For Each Loop a Flat File...  But there is not File connection to reference for the XML Source adapter. How do I run XML files through my DataFlow from a directory with the For Each Loop Marc, Thank you for the Late Night answer.  It worked perfectly, and I would have not figured that out without you. Your Money! I am going to assume two things: 1. the schema is the same for all of the files, and you have alr ...Show All

• Sando the Imperial Khan Cannot use Large Page Extensions & AWE

  Hi, We are seeing the following line on the sql errorlog  on a Itanium2 server running SQL Server 2005 Enterprise RC1.  Cannot use Large Page Extensions:  lock memory privilege was not granted. Is it something to be alarmed with This server has 16GB memory so it's my understaning that AWE does not have to be enabled on the instance as the 64-bit architecture can directly address more than 3GB ...Show All

• Maojiu Can't install SSIS on an XP machine

  Hi all, Why would I not be able to install SSIS on an XP machine   The option is grayed out.  As a matter of fact, all the options are grayed out, save for the client tools. I'm using the September CTP. Thanks in advance, Anthony Rizzo, MCSE, MCDBA It's SQL 2005 September CTP.  I don't know the SKU or edition.  It's build 9.00.1314. Every single installation option is grayed out except the l ...Show All

• Troy Gerton April CTP installation failed

  I've already installed VSTS 2005 Beta2 and I try to install workstation components of April CTP. What should I try to pass th error The error is at the end of installation: --------------------------- Failed to generate type library 'C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.tlb' for 'Microsoft.SqlServer.MSMQTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. System.EnterpriseServices ...Show All

• Pete Nelson ADO.NET Source Custom Properties - Documentation Wrong?

  Ok, so I've looked near and far and have found nothing but info that says data flow properties can not be changed at runtime....then I see in this in the SSIS documentation under ADO.NET Source Custom Properties: SQLCommand String The SQL statement that the ADO.NET source uses to extract data. The value of this property can be specified by using a property expression. Pray tell me how this property can be specified using a property ...Show All

• Butt3r5 create xml from sql query

  Hi I have a "configuration" table in a SQL database it has the parentid and itemid to create a tree, I need to create another tree froma an xml but i dont know how to relate them in the xml file , because when i create the xmlfile all the items are alike, any hints Thanks and regards. Try something like this: WITH DirectReports ( ManagerID , EmployeeID , Title , Level , Path ) AS ( SELECT Manager ...Show All

• VS Developer text variable in TRIGGER

  recently I wrote a TRIGGER , but I found the text is not allowed to be used. such as: in the trigger: declare @content text Is it illegal   And why thank you! Hi Umachandar, I am dynamically creating a sql query and then executing it using exec command. my problem is my dynamic sql exceeds the limit of 8000 chars. so I am having couple of variables and executing like exec @var1 + @var2 To improve perfo ...Show All

• Iliya IS install after SP1 fails

  Subject says it all; I need to install IS, but the installer says v.2047 of IS is already installed; it it NOT installed. When I go to add/remove programs, under the Sql Server 2005, it allows me to try to install IS, but that also fails, as no components are found for installation. This is SS dev edition, W2003. I can uninstall SS2005 and start over, but is there a quicker way to fix this I'm kind of curio ...Show All

• PUG666 job failed (SSIS). Executed as user: SRVDESASQL2005\SYSTEM.

  Hi everyone, I've made SSIS using domain security and after that it has been scheduled by Sql Server Agent. But that job fails and looking into history job I read: "Executed as user: SRVDESASQL2005\SYSTEM. The package execution failed. The step failed." Mssql Server agent is being used for local system. Is there the problem Nevertheles the aforementioned user have sysadmin role. Does anyone ever faced this kind of issue ...Show All

• Andre Barendse Mission Impossible ? Pivot Table at front end Excel

  I have a table with this field headers Product/Status/USD:- A/Actual/100 A/Budget/90 A/Variance/10 I have created a Pivot Table in Excel with Product as row field (A or B) Status as Column field (Actual, Budget, Variance) USD as Value It looks fine like this but I need to create a column called Variance % which is (Variance/Budget x 100%). Please urgently advise how to create this new % column within Pivot Table. Thanks. Sorry it seems ...Show All

• Kristy2610 raw file source avoid bad data?

  I want to have a data flow like this: 1. raw file source 2. validate data or conditional split 3. sql server destination there is some bad data in my raw file.  by bad data I mean datetimes that are out of the range that sql server can handle. this should be simple right Hi, I'm puzzled by your sceptism of the expression language. Does it not do what you need Access to the entire managed runtime (I pres ...Show All

• Peter S Antal - MSFT Prediction with many attribute states

  I have a large dataset of around 3 million records with accounting data for 2 years. Attributes are transaction amount (cont. / predict), account, cost centre, project, month and a few others. I want to predict any future transaction amount for a certain combination. For example; what will the next salary cost transaction amount in cost centre 123 probably be I have tried Decision trees and Neural nets. But the predictions are not go ...Show All

• Sri_Prad WMI Configuration?

  Hi All, I tried to install SQL Server 2005 Developer Edition RTM version and SCC failed with the message: "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine mymachine Error:2147749917(0x8004101d)." Looking on SQLSetup0032_mymachine_SCC.log I have: " Processing article WMIServiceReadRegWorking Scc Error:  50024 (0xc368) Error code: 2147749917 (0x8004101d) Calling callback function for ...Show All

• web_dev_caci Will run in SSIS Designer but not from DTExec

  Hi all, I have a package that runs fine in SSIS Designer but not from DTExec. I get the following 2 error messages: The task "Reset variables" cannot run on this edition of Integration Services. It requires a higher level edition. The task "Prepare variables" cannot run on this edition of Integration Services. It requires a higher level edition. Those 2 tasks are both script tasks. The version number on both installations is the same (i.e. 9.00 ...Show All

• Shubha Iyer operationg system requirement

  I am in the process of learning SQL from scratch and figure it would be helpful if I can run a local server and experiment with it as I move along some book reading. I have a few questions regarding the operating system requirement for running a localhost server and hope some of you can answer to my novice questions. Can I setup a server under Windows XP when I looked thru the documentation it indicated only windows 2000 and other Microsoft serv ...Show All