Answer Questions

• James2007 The task Transfer SQL Server Objects Task cannot run on this edition of Integration Services. It requires higher level edition.

  Error code: 0xc0012024 Using "Integration Services Project" template in Business Intelligence Studio. Using platforms Visual Studio 2005 along with SQL Server 2005. Getting the error while trying to execute package after loading it programmaticaly. I've just one task "Transfer SQL Server Objects Task" on my Integration Services package. But when I try to execute it from VS 2005 project programmaticaly, it gives the above mentioned error. The commands I use: Package pkg = new Package(); pkg = a.LoadPackage(@"C:\Documents and Settings\abc\My Documents\Visual Studio 2005Projects\lSSIS\SSIS\Package.dtsx", null, true); DTSExecResult dResult = pkg.Execute(); The the error comes like: error: ...Show All

• Dr.Virusi YTD summation after a pivot.

  I have an appropriate pivot query for my report that gets the sumation of all items and puts them into these columns. lineItem Jan Feb Mar Apr ... Dec item1 1 2 3 4 ... 12 item2 2 4 6 8 ... 24 I need to get the following lineItem Jan Feb Mar Apr ... Dec YTD item1 1 2 3 4 ... 12 78 item2 2 4 6 8 ... 24 156 Is this possible My querry looks something like the following WITH ProductSales(ProductID, OrderYear, OrderTotal) AS ( SELECT det.productID, YEAR(hdr.orderdate), det.linetotal FROM sales.salesorderdetail det JOIN sales.salesorderheader hdr ON det.salesorderid = hdr.salesorderid ) SELECT ProductSalesPivot.productID, Total_Sales_2001 = ISNULL([2001], 0), Total_Sales_2002 = ISNULL([2002], 0), T ...Show All

• daniel.youlussusskind Can't run SSRS Projects SSBIDS

  I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it... Package Load Failure Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future you may use 'devenv /resetskippkgs' to re-enable package loading. I also tried to create a new Reporting services project and I got the following error.... Could not lo ...Show All

• linzbfc Programmatically Create a Lookup Transform

  Hi, i'm creating a Lookup programmatically. But i can't find out how to assign the ConnectionManager that references the lookup data. Do you have an example for me Many thanks in advance. Stefan L. I am new to SSIS programming and having trouble using JoinToReferenceColumns ( http://msdn2.microsoft.com/en-us/library/ms136014.aspx#lookup ) property of lookup transformation. Can you please post a code sample Hi, Great! It works! Thank you very much! Stefan L. Use the RuntimeConnectionCollection of the component (IDTSComponentMetaData90). This is the same pattern as a you use for a source or destination, but any component can ...Show All

• cOngx External Activation with "n" servers processing messages.

  I am attempting to use Service Broker to distribute message processing across multiple machines. I have mulitple queues setup to all notify a single service with the QUEUE_ACTIVATION event. My external application then sits in a "WAITFOR RECEIVE" on that event queue and when it receives a message for a particular queue, will begin processing the messages in that queue if that particular server is configured to process messages of that type. My problem is that once one server starts receiving messages, the others don't always start processing and I end up with one server attempting to process all the messages by itself. What is the best way to notify multiple servers that there are messages in a particular queue which need process ...Show All

• Neil Ault Best Protocol?

  What is the best protocol (Named Pipes, TCP/IP or VIA) to use when connecting to a SQL Server 2005 on: a) LAN (100MBps+) b) VPN (via Internet) c) Internet And why I do not believe the article about choosing a connection type to the server answers the question. In my opinion it is ovbious that the LAN is the best just because of the TCP/IP connection method being able to take advantage of low overhead, hi bandwidth connections. VPN is guaranteed to be slower than the LAN because the protocol is sitting on top of TCP/IP and will inherently add more overhead. As far as Internet goes, I am not sure what the difference b/w LAN and Internet is going to be as far as which protocol to u ...Show All

• dtlinker printing reports without previewing in a .NET app

  hi, i need to print reports without having a preview. i.e batch printing. with regards suresh babu Could someone please elaborate on this I don't have the 2000 sample. Thank you! Enter a tag in your page such as using which you can diffrentiate in part which is for printing and which is for not printing and the part of page which is for printing make its tag cssclass on and for rest part make cssclass off and than call window.print() and after that just make all class on. it will work as per your requirement. Hi, there is a sample for delivering reports to other locations than printers / files shares (Look in the samples folder of Reporting Services, I remember th ...Show All

• byronfromwesleyan Silent Installation Setup Problem

  Hi, I'm trying to create a silent installation which will create a new instance of the express version on my clients machine, the problem is that i can't set the service account to local service i.e AGTACCOUNT="NT AUTHORITY\LOCAL SERVICE" if im running the normal setup (GUI) i can set this property easly, but from the command line all i get is "NT AUTHORITY\LOCAL SYSTEM" which is the default i think how can i do it from the command line Thanks If you're trying to set the SQL Service account, use the command line parameter SQLACCOUNT as well as AGTACCOUNT. SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE" From template.ini: ;-------------------------------------------- ...Show All

• eclipse150gt sql connection

  hello, Is it possible to use TELNET(from the client in LAN A) and access database instance at(sql Server at LAN B) . I meann to say is, can we use TElnet over the internet to access the instance. can anybody helps me Thanks in advance hello sir, i want to access the instance over the internet, thats why i am thinking to move on telnet . using this i will access the intance over the internet. can u suggest me a best approach for the above case thanks for ur help YOu can open a port to SQL Server via telnet, it questionable what you can do with telnet on the instance. You can also use any query tool to access the appropiate port on ...Show All

• Abbbbbs Controlling flow in ForEach Container

  I have a few hundred data files that I need to process in groups from oldest to most recent. To that end, I have created staging folders for each date that appears in the file names (example: 20060213) and moved all of the data files to the appropriate folders. I also have these folder names in a recordset that has been sorted in ascending order, so the oldest date should be the first record, the second-oldest date should be second and so on. My thinking is to use this recordset with a ForEach Loop Container to loop through each folder, but I am not sure if Integration Services will necessarily loop through the records in order. Can someone tell me whether the records will be processed in order or suggest a better alternative to make ...Show All

• Shepherd Please vote/validate SQL SSAS bugs on connect.microsoft.com

  Folks, It might help to get SQL 2005 issues addressed in more expedited fashion if we go to https://connect.microsoft.com/SQLServer (Click where it says "1. Click Feedback here " to enter feedback area. search for analysis services bugs review bugs that are filed rate bugs by voting validate bugs that you've seen. This is an excellent suggestion. If you have any problem you are seeing, please go to the Connect ( http://connect.microsoft.com/sql ) and please file it. Please make sure you describe problem in much detail as possible so we can reproduce it. Every problem filed is getting looked at. It is very important that problem description is accurate. Leave your contact information ...Show All

• pat_seo SSAS CPU usage sky-rockets!

  Hi all, I have read all threads about SSAS cpu usage and saw that many people experience the same situation as we do. When we access reports which uses a cube as data source the CPU usage sky rockets to 99-100%. Resulting in a freeze of the server till the request is finished. Ofcourse the SSAS service is using all the resources. Unfortunately I am not able to find a solution to limit the CPU usage of SSAS or tracking the source of the problem. Using the SQL profiler I see loads of commands asking high CPU time. In another thread I read that SP2 might resolve this kind of behaviour but I am not sure if the solution should be SP2 or the solution should be found in a different approach. [edit]. Ok I have tested the reports on a di ...Show All

• Glenn Wilson query 2 server at the same time

  can some one please tell me with an example,how to query data from two db server in the same tsql query. Thanks in advace You have to setup a linked server and then use full 4 parts to query the linked server. SELECT * FROM linkserver.dbname.schema.tablename JOIN tablename ...Show All

• Ravishesh editing xml files generated by ssis for data transfer

  How do i edit the the files where do i get the definations of the various fields in the xml file... My specific probelm is to edit the xml file generate to transfer sql data to to a fixed width file. I want to append a <cr><lf> at the end of each transferred line. I presume that i can edit the SSISxml file generated and insert some value for the <Row delimiter> ... ...Show All

• yanivpinhas how can I substract a SUM from a SUM?

  first, I am using stiored procedure and here is my table structure: [item_id] [int] IDENTITY(1,1) NOT NULL, [item_guid] [uniqueidentifier] [company_reg_number] [int] , [file_no] [int] , [visit_id] [int] , [item_code] [varchar](50), [item_price] [decimal](6, 3) [created_date] [datetime] [created_user] [varchar](50) and I have debit and credits in the same table but I want to get the difference.. my stored procedure to return the result is: USE shefa set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================ ...Show All