Answer Questions

• aDarren Using a parent-child dimension where you track and report as per the history

  Hi, At this point, I'm simply trying to see if what I'm trying to do is possible. If anyone has tried this before, I'd appreciate to know how they've done it. Say I have a single DSV with a single table such as the following: TABLE Members ( ChildID int, ParentID int, Period datetime ) which contains data like this: ChildID ParentID Period 1 4 2006-10-01 2 4 2006-10-01 3 4 2006-10-01 4 5 2006-10-01 5 6 2006-10-01 6 NULL 2006-10-01 1 5 2006-11-01 2 4 2006-11-01 3 4 2006-11-01 4 5 2006-11-01 5 6 2006-11-01 6 NULL 2006-11-01 In words: In 2006-10-01, 4 has three childs and is under 5 which is under 6. In 2006-11-01, 4 has two childs and 1 is ...Show All

• macroplay SSIS - AcquireConnection method call to the connection manager failed

  Hi all, I am facing a problem with the connection method, it says, "[Store [10069]] Error: The AcquireConnection method call to the connection manager "Data Source Destination" failed with error code 0xC001A004. " (Store - Look up component.) This problem occurs only when i am using Transaction option, all the component(Look up,Destination etc) says the same error message in the Pre-Execute phase. But i can open the component and can able to see the data in preview. And also this is not occuring in our testing environment. We have copied the same pakages in our production, the package failed stating the above. I can not simulate the same problem in my testing server. Has anyone faced this kind of probl ...Show All

• esb SQL 2005 express permissions

  Can I use (an) active directory group(s) to allow clients to connect to a server running sql server with windows authenticion   Is there an article that explains how to do something like this that someone can point me two Thanks One more, How can I set up and SQL login to work. I set up the login the same way, and I thought I set up the permissions, but in my C# code all I get exceptions that say the connection doesn't have permissions to insert, delete, etc. The only permission my login has is to select. Is there a step by step procedure to setting up a login in SQL express 2005 Thanks. Add a security principal for the Windows Group and you are done: ...Show All

• Jon Langdon - MSFT SSIS and temporary tables

  Does SSIS (other than, maybe, via the Execute SQL task) support the idea of temporary tables (I want to make a backup of production data (in temproary tables), truncate the production tables, and populate them with new data. If an error happens in the process, I'd copy the temporary backup tables back into the production tables. When the process has ended the temporary tables should "vanish") TIA, barkingdog TGnat wrote: Jamie Thomson wrote: Alternatively you *could* use a raw file destination as these have the advantage that the data just "vanishes" after execution as you require... but as I point out here: http://blo ...Show All

• winstonSmith CASE Returning NULL

  Hello, I have a query that contains six derived columns; FirstPerYr; The current year FirstPerMo; The current month FirstPeriodRevenue; CASE the current year, use the CurrentYearSalesTable (CY). CASE the current month, match the correct column (JanRev, FebRev, etc) of the CurrentYearSalesTable to get the correct data. FirstPeriodYrAnnum; Last year FirstPeriodMoAnnum; The current month, last year FirstPeriodAnnumRev; Same as FirstPeriodRevenue, but from the year and month before. In the following query, I get the correct FirstPeriodRev value, but FirstPeriodAnnumRev comes up NULL. I know I have data for January 2006. The query is as follows; --************************** DECLARE @FirstPerYr Int DECLARE @FirstPerMo Int DECLARE ...Show All

• Alexandre Martins "Copy" within a table - plain SQL

  Hi. I'm quit new into SQL - have a problem - and hope someone here ca n help me. I have a table TABLE1 with different fields. A part of it looks like this: FIELD1 FIELD2 FIELD3 111111 121212 0 111111 121212 91 222222 232323 0 222222 232323 73 etc. etc. I want to "copy"/write over '0' in FIELD3 with the number in FIELD3 from the line that has the same numbers (and unique for these two lines) in FIELD1 and FIELD2. The table will then look like this: FIELD1 FIELD2 FIELD3 111111 121212 91 111111 121212 91 222222 232323 73 222222 232323 73 I can make a temporary table or a new field if necessary. I j ...Show All

• Dorian Dechant Security problems in the initial synchronization

  Hello everybody, I would be thankful if you try to help me with my problem, I am using merge replication under SQL Server 2005. In our system there is a central database running SQL Server 2005 Enterprise Edition with a big database published for merge replication. There are too a lot of clients running SQL Server 2005 Express Edition that pull subscriptions to the central database. How the clients create subscriptions and run the synchronization process is posted below (RMO Progamming). When running the syncrhonization process, the Distributor connects OK, the Publisher Connects OK... but when the snapshot copy process starts, the execution is halted with an init session error "unknown user name or wrong password" (more ...Show All

• bhavu Loading tables with Foriegn Key contraints

  Hi, I am having trouble loading tables (within the same data flow) that have a foriegn key relationship defined between them. For instance: Table A is a parent (one side of the relationship) to Table B (many side of the relationship). I am trying to load Table A first within the data flow and then Table B after, but I get the following error: [OCMD EntityRole Insert [2666]] Error: An OLE DB error has occurred. Error code: 0x80040E2F. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E2F Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E2F Description: "The INSERT statement ...Show All

• Z.Z.C Flatfiles with garbage data

  I was testing my packages today and my packages were running sucessfully when I didnt have any valid data in the flat file. One the reason was as not rows were returned from the flat file none of the validation script components returned any err. How do I count the # of rows which were read from flat file from the package and continue only if there is more than one row. I tried using conditional split but as I wont have the row count value availble till the dataflow task runs this didnt help. Is it best for me to have two dataflow tasks one resturns the count of records from flat file and the other starts if there are any rows. Now my problem is if I have rows to process how to I transfer the flatfile data to validate from DataFlo ...Show All

• Philippe Monnet failed insert because of duplicate rows and still locks held by application

  Hi, we are using SQL Server 2005. We have a problem because of an application which tries to insert a duplicate row in a table with primary key. This insert fails of course but the locks are not released within this transcation. This is not locking up on MS SQL Server 2000. But we can see the lock is still applied there. Can someone help me on this Thanks, Try looking at the output of this query: select login_name, case des.transaction_isolation_level when 0 then 'Unspecified' when 1 then 'ReadUncomitted' when 2 then 'ReadCommitted' when 3 then 'Repeatable' when 4 then 'Serializable' when 5 then 'Snapshot' end as transaction_isolation_level, request_sessi ...Show All

• asalcedo Contextual Relationship mappings

  Is there a 'best practice' method within BID to constrain a relationship path when different contexts are available For example: tbl.Revenues provides data for both tbl.Rentals and tbl.Sales, and aggregates/totals are provided for both Rentals and Sales (via relationships to tbl.Revenues from each of the two other tables). How can I assure that values for Rentals are _not_ shown when the path to Revenue was via the Revenue-Sales relation Thanks in Advance. If you want to selectively show items based on the user or user group then you should use model item security (in Management Studio, select to secure items separately and grant access to those who you want to see specific items in th ...Show All

• Fulankazu Logging difference between Designer and SQL Agent package executions

  After fine-tuning my package logging, I built a query against SYSDTSLOG9 that uses the combination of the OnPreExecute events and any subsequent event for each task to build a nice view of a package in progress, including the duration of each event. (Running tasks would have a row with a NULL EndTime.) When running the package within the Designer, everything works as expected. Events are logged at the task level and everything bubbles-up to the package level. However, when I run the package from SQL Agent (using the SSIS job step), none of my OnPreExecute or sub-component events are written. That is, I only get package-level OnInformation, OnPostExecute and OnError events. This means when the job/package is executing, I can't directly see ...Show All

• createdbyx Help With CLuster Install

  2 issues: 1. have 4 drives and all are within the SQL resource group but can see only 1 drive through management studio when doing a backup 2. Is restore only possible through the /backup folder on the default installation path as it is a small drive so can a restore be possible from any other locations Any help You must be running Management Studio on the same machine which is physically hosting the database at the moment. I suspect that the reason you cannot see all disks available to SQL is that you are not running on the same node. Backups must be done locally. (using scheduled Maintenance Plans will ensure that the backups always run on the same node as the database is running.) You can backup to ...Show All

• shangan Get the variable from Execute Process Task to C#

  Hi! I need help with some C# code. I have build a SSIS package with an Execute Process Task. I need to send dynamic variables in to my C# program so I thought it was a good idea to use the StandardInputVariable. How do I get the variable in my C# code Thanks Carl Thanks for your help. I tried to get the variable through the main method but it dont work, the only thing I got was the argument. My test code: static void Main(string[] args) { for (int i=0; i<args.Length; i++) { Console.WriteLine(args ); Console.ReadLine(); } Carl ctsand wrote: I have a static argument and a variable in StandardInputVarable. I put a ...Show All

• DiasVFX Storing query results in SQL table

  Hey guys/girls, I was wondering if there is a way to store the report query results into a SQL database for use within an application. I would like to have the query information used in the report updated to a SQL table for later use. The other catch would be to deploy the information to a separate datasource location than the report is using (because the information will be stored in a different location than where the report is gathering information. Thanks! BJ I got this to work: INSERT INTO TestTable (Test) SELECT Test2 FROM TestTable2 Now my new issue is that I can't set up a datasource to point only to the server, so I can SELECT from one database and INSERT to anoth ...Show All