Study guides are not out and neither the test engines or the dumps, if you mean.

Once you read the resource shared by Koen, come up with a design to join 3 tables. 🙂

I want to do one. One fo you and one for me 😛

Is this article live on SSC?

I can take one on 'File Watcher Task", but will this article describe more about .NET classe "FileSystemWatcher" or any other task or .NET class in particular?

You may also consider a SSIS solution using Bulk Insert Task

Good one.

Hi,

have you considered a Integration Solution(SSIS) wherein the excel file would act as a source and you can later introduce a MERGE transformation to join data as required.

AIRWALKER-375999 (4/19/2012)

---

Hello all,

I need help modifying this query so that it watches for the creation of 2 (or more) files:

Dim query1 As New WqlEventQuery( _

...

sachdeva.purnima (4/17/2012)

---

I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis

1. When both branches are same ,

2....

Run the desired SQL and store the value(s) in SSIS variable(s). Use a Script Task or a Flat File destination.

Remember to create a dynamic file connection manager if you...

Anamika,

Get the YEAR part of MAX(date_column)

Hi Anamika,

Get the month part of MAX(date_column) and use a SWITCH case in the script to name the file accordingly.

Give more info in terms of:

Kind of hardware, number of rows, full load or incremental load, and lastly a snapshot of the package design.

Also see this thread

http://forum.kimballgroup.com/t24-role-playing-dimensions-when-is-it-appropriate