Post New Web Links

Propagating Logging Details from child packages to parent packages

Posted By: Posted Date: September 03, 2010 Points: 0 Category :Sql Server

From MSDN I found the following: "The child package that the Execute Package task runs may or may not be configured to use logging, but the child package will always forward the log details to the parent package. If the Execute Package task is configured to use logging, the task logs the log details from the child package." It appears this only works one level deep. My parent package is receiving log details from its child, but not from its grand child (package that the child executes). How can I get the parent to receive log information all of its decendants?

View Complete Post

More Related Resource Links

Logging Information from Nested SSIS Packages

Hi All -

I have packages that contain other packages. I run my packages using dtexec. Currently I am doing my logging from the batch that calls dtexec. This does not seem to capture any information on the child packages, other than their call from the parent. Can someone suggest a good general resource on logging that includes advice on how to capture logging on nested packages?

TIA - G

GridView Parent Child View with JQuery Effects

I was just checked how to add some more cool effects to the GridView control using JQuery. In this post I will display parent-child data in the GridView control with some help of the wonderful JQuery library.

Let's first populate the GridView control.

How to keep the hover for Parent menu and set the selected menu item css for child menu item?

Hi,

I'm using cssfriendly control adapter for menu. My asp.net menu control's datasource is a sitemap file I'm using which contains all the urls.

I have the following questions:

Is there a way to keep the parent menu item hovered while hovering over the respective child menu items?
Is there a way to keep the child menu item selected? I am able to set the css for the parent menu, however I was wondering if the same is possible with the child items.

Please help!

Thanks,

Moneka

Data Points: Saving Parent-child Data in a Multitiered App Using ADO.NET

John Papa

MSDN Magazine May 2004

C++ Q&A: Parent and Child Window Captions, More MoveDlg

Paul DiLascia

MSDN Magazine July 2003

way of calling "javascript function of parent window from child window."

The article way of calling "javascript function of parent window from child window." was added by raja.s on Sunday, June 06, 2010.

Hi,Here i am going to explain how to call the javascript function of a parent window from the child window(pop-Up).Some may know before reading this post.Parent Java Script Function:script language="Javascript" type="text/javascript">

Two modalpopups as a parent-child

When I open two modalpopups, one over another, there is unexpected order.

After click on "Open Parent Panel", and click on "Open Child Panel",

Child Panel (newone) is under the Parent.

Uploaded with ImageShack.us

What should I do to get it in "normal order"?

The code is:

<asp:ScriptManager ID="A" runat="Server">

</asp:ScriptManager>

<asp:Button id="Z1" runat="server" Text="Open Parent Panel"

Display a nested child ListView on PostBack while using DataPager on parent ListView

Hello ASP.NET community,

I am having trouble finding how to solve the following issue :

I am using nested listviews to display Sales and Sales details.

The main ListView displays General Information about Sales and the child ListView displays the detailed information about one sale. the child listview is shown only when the user clicks on a link (see included code, DataBind is made on PageLoad) :

ASPX Markup Code :

<asp:listview id="lvSales" runat="server" onitemdatabound="lvSales_ItemDataBound">
	<layouttemplate>
		<table cellspacing="0" border="1" width="250" style="border-collapse:collapse;">
			<tr runat="server" id="headerRow">
				<th scope="col" style="width:30px;"></th>
				<th scope="col">SaleNumber</th>
			</tr>
			<tr id="itemPlaceHolder" runat="server" enableviewstate="true"/>
		</table>
	</layouttemplate>
	<itemtemplate>
		<tr id="row" runat="server">
			<td style="text-align:center;"><asp:button id="btnShowHideDetails" runat="server" oncommand=&qu

InfoPath and Access - two parent tables and one child table

Hi there,

I'm trying to link an InfoPath form to an Access database, I want to connect the InfoPath form to 3 tables in the Access database but InfoPath will only recognise parent-child relationships in a series (e.g. the "Company" table is the parent to the "Customer" table, which is again parent to the "Orders" table)

I need to have two parent tables and one child table, though (e.g. "Customer" is parent to "Orders", but "Inventory_Item" is also parent to "Orders"). Is there any way to establish this in InfoPath? I'm using Windows XP, InfoPath 2007 and Access 2007.

Cheers, Patrick

parent and child items

I have to create a aspx page where end users can create, edit and delete category and their subCategory from it.

Please suggest what is simple way to do above? using .Net

PS: a category can have zero or more subcategory and subcategory will not have any of its own subcategory, i.e. there are only two levels.

Transactions in SSIS packages

Hi guys - I've been working in ssis for a bit but never have encountered the need for transactions - until I realized that I really need them. Here's my setup. I have a master package that has a sequence container in it. In that sequence container are 3 execute package tasks (Insert - Update - Delete). Each execute package task points to a child package which contains 50 execute package tasks (to perform the tasks on my different tables). From there - the actual work is done. (default everything on transaction/isolation etc) My problem/question is that I need to make it where if the insert fails, the update/delete do not happen and everything gets rolled back. Right now if something fails it just stops there and gives me half changed records. Is there a way to do this or am I just hoping for un-doable? Thanks!

How to assign data from 1 DataReader into Parent/Child object??

Hi I have a parent & child table. Parent - User UserID UserName Status 1 Shallin A 2 How A Child - UserAccess UserID Country Default 1 US 0 1 UK 0 1 MY 1 2 SG 0 2 HK 0 2 MY 1 I also have parent & child object class. I would like to use 1 C# function and 1 SP to handle the retrieve portion but I have 1 problem. I'm not sure how to assign the value from Reader to the object. I do something like this but I only get 1 country which is the last country. if (dr.HasRows) { while (dr.Read()) { User objUser = new User(); objUser.UserID = dr["User_ID"].ToString().Trim(); objUser.UserName = dr["UserName"].ToString().Trim(); objUser.UserStatus = dr["Status"].ToString().Trim(); UserAccess objUserAccess = new UserAccess(); objUserAccess.Country = dr["Country"].ToString().Trim(); objUserAccess.Default = dr["Default"].ToString().Trim(); objUser.UserAccessCollection = new UserA

MDX Query - Get (Parent-Child) Dimension member regarding another Parent-Child Dimension, then, get

Hi there, I got the following MDX issue. My cube structure looks like that : DIMENSION CATEGORY (Parent-Child) --> (Many to many) FCTLESS_CategoryNode <-- DIMENSION NODE (Parent-Child) ___ DIMENSION NODE (Parent-Child) --> (Many to many) FCTLESS_NodeVariable <-- DIMENSION VARIABLE ___ DIMENSION VARIABLE <-- FACT (Supposed with only one value called VALUE) I'd like aggregate for N nodes linked to a specific category. For example, with the next content : DIMENSION CATEGORY - COUNTRY - SITE - BUILDING DIMENSION NODE US (Category Country) - Site US_A (Category Site) - Building US_A_A (Category Building) FR (Category Country) - Site FR_A (Category Site) - Building FR_A_A (Category Building) - Site FR_A (Category Site) - Building FR_A_B (Category Building) - Site FR_B (Category Site)

can this be done OOB (parent - child related lists)?

Hello, I'm brand new to sharepoint. Can I do the following out of the box, or will I need custom code? I need to create 2 related lists to form a master - detail relationship. 1. need to enter new parent and child list items on the same input form (like when adding a new parent item, also add new child items on the same screen) 2. need to have a view where when a parent item is selected the related child items display in a grid underneath can this be done out of the box? if yes, how? could someone provide an example or links to a 'how to'? thanks!

How to Bind a child control with properties of the parent control in Silverlight and WPF?

Dear Experts, I have a usercontrol in Silverlight and I want to enable the update button inside the usercontrol with property defined in the usercontrol. For the proof of concept sake I have defined the usercontrol xaml and the code behind in VB.NETBelow is the XAML and VB.NET Code. ----------------------------------------------------------------------- <UserControl x:Class="SLBAppAssementQuestions.SilverlightControl1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="d" d:DesignHeight="300" d:DesignWidth="400"> <StackPanel> <CheckBox x:Name="chkBox1" Margin="10" Checked="chkBox1_Checked" >Checkbox1</CheckBox> <CheckBox x:Name="chkBox2" Margin="10" Checked="chkBox2_Checked">Checkbox1</CheckBox> <Button x:Name="BtnUpdate&q

Need Best Practices for SSI packages (dtsx-files + ONE config)

Please advice hot to keep connection string for many packages at one place. Idea is to have one .dtsConfig-file for each iteas is not acceptable. DEV, TEST and PROD - different virtual computers. Each one can have it's own config-file lying in one and the same folder (c:\bi\configs\)

Help about cascadin M2M with parent child hierachy custom rollup for one measure

Dear MSAS Experts, My name is Andre and i am writing my thesis about data quality which needs to be finished in about 3 weeks.:-( For my thesis i needed to develop a Schema which store data quality issues. This is a part of my schema which includes a cascading M2M: Facttabele: ErrorFact / ChecksFact / RULE ID / ... DT_RULE: Rule_ID / ..... RULE_ATTRIBUTE_BRIDGE: RULE_ID / Attribut_ID => M2M beetween Rule and Attribut(Rules can belong to multiple Attributes) DT_Attribut: Attribut_ID / .... Attribut_KPI_Bridge: Atribute_ID / KPI_ID => M2M beetween Attribute and KPI (Attributes can be used for multible KPI calc) DT_KPI: KPI_ID, KPI_Name, KPI_PARENT => Parent Child Since MSAS do not provide a Agrgatefunction I have a calculated Measure (lets say its called 'EC') which calculates the average of ErrorFact/ChecksFact. Now the problem I do have is that the 'EC' Measure should be aggregated within and only in the DT_KPI dimension that every child which belongs to the same parent should be muliplicated ('*') with each other till we reach the all member node. So if we have the following PC-Hierachy: -A --B ---C ---D --E The result of A would be (C*D)*E = A. B of course would show the result of C*D. On the other hand all the other facts should use the normal aggregation for this dimension. Also EC should be aggregated normal in all other dimensions. I tried usin


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All