How to Find the Greater than the Average Salary using SSIS 2008 r2

Hello, How to Find Which Employee has the Greater than the Average Salary based on their Department using SSIS 2008 r2? I found the link on this page: https://msftisprodsamples.codeplex.com/ Ca...

Id #22287 | Release: None | Updated: Jun 4 at 8:20 PM by Girivasan_E | Created: Jun 4 at 8:19 PM by Girivasan_E

Synchronizing Adventure Works DW Partitions Package Sample: The package doesn't work beacause the Script Task is empty

Could you check the Script Task in this package? There is no code.

Id #14544 | Release: None | Updated: Jul 18, 2014 at 8:25 AM by qq858899177 | Created: Oct 26, 2010 at 12:04 PM by heaven8585

ForEachDirectory loop fails when it cannot access a folder (access denied due to custimized NTFS permission)

The control is what I need exactly. However, when the for each loop encounters a folder with "access denied", the for each directory loop throws an error and do not continue to scan further folders...

Id #14460 | Release: None | Updated: Feb 22, 2013 at 12:03 AM by GeorgeQiao | Created: Oct 14, 2010 at 3:56 AM by GeorgeQiao

Lesson 5 gets a "ErrorDescription" (149) on " Output 0"(138)

I'am using VB and Visual Studio 2008 with Sql Server 2008 and the routine in "Get Error Description"'s Edit Script only allows for C# code, eventhough the sample tutorial provides both VB and C#. I...

Id #12508 | Release: None | Updated: Feb 22, 2013 at 12:03 AM by sabottaca | Created: Apr 5, 2010 at 7:49 PM by Hlpearl

Change Data Capture for Specified Interval Package Sample: There are 2 connections using databases not supported by Database Installer in 5 packages

Environment: Windows 7 ENU x86 KJ 10.50.1352.12 Sample build 91118   Repro Steps: 1.Open "…\Integration Services\Package Samples\Change Data Capture for Specified Interval Package Sample\Change D...

Id #10972 | Release: None | Updated: Feb 22, 2013 at 12:03 AM by libinzhao | Created: Nov 20, 2009 at 1:46 AM by libinzhao

CaptureDataLineage Sample: Failed to execute package with errors about “Load Data into Lineage_Fact_Table”.

Environment: Windows XP SP3 CHS x86 Katmai 10.0.1600.22 Sample 90810   Repro Steps: 1.Open "...\Integration Services\Package Samples\CaptureDataLineage Sample\CaptureDataLineage.sln" with BI. 2....

Id #10467 | Release: None | Updated: Feb 22, 2013 at 12:03 AM by libinzhao | Created: Aug 18, 2009 at 5:50 AM by libinzhao

IncrementTask Sample: There are 2 path errors in the readme.

Environment: Sample 90315   Repro Step: Open and read the sample readme file "...\Integration Services\Programming Samples\Control Flow\IncrementTask Sample\Readme_CreatingCustomTask.htm".   Expect...

Id #9527 | Release: None | Updated: Feb 22, 2013 at 12:03 AM by sabottaca | Created: Mar 17, 2009 at 6:23 AM by libinzhao

Change Data Capture since Last Request Package Sample: "Create Tables and Enable Change Data Capture" Execute T-SQL Stagement Task error when execute the package "SetupCDCSample.dtsx".

Environment: Windows XP SP2 DEU Katmai DEU 10.00.1600.22 Sample build 90306   Repro Steps: 1.Open "…\Integration Services\Package Samples\Change Data Capture since Last Request Package Sample\Cha...

Id #9489 | Release: None | Updated: Jun 14, 2013 at 7:30 AM by SandraWard | Created: Mar 12, 2009 at 8:18 AM by libinzhao

Change Data Capture since Last Request Package Sample: "Load Target Customer Table From Snapshot" Data Flow Task error when execute the package "SetupCDCSample.dtsx".

Environment: WindowsVista CHS Katmai CHS 10.00.1600.22 Sample build 90306   Repro Steps: 1.Open "…\Integration Services\Package Samples\Change Data Capture since Last Request Package Sample\Chang...

Id #9488 | Release: None | Updated: Feb 22, 2013 at 12:03 AM by SandraWard | Created: Mar 12, 2009 at 8:16 AM by libinzhao

Change Data Capture for Specified Interval Package Sample: "Create Tables and Enable Change Data Capture" Execute T-SQL Statement Task error when execute the package "SetupCDCSample.dtsx".

Environment: Windows XP SP2 DEU Katmai DEU 10.00.1600.22 Sample build 90306   Repro Steps: 1.Open "…\Integration Services\Package Samples\Change Data Capture for Specified Interval Package Sample...

Id #9487 | Release: None | Updated: Jun 14, 2013 at 7:30 AM by SandraWard | Created: Mar 12, 2009 at 8:14 AM by libinzhao