If you can get the browser window to highlight (shift click each column, or drag the mouse across the entire result set), copy it and paste it into Excel. ...

I would most likely put it all in a single table that will become something like your product dimension. Then in SSAS you can configure some or all of...

Is there any additional detail in the Execution Results tab?

In a Script Task you are essentially writing code. So if you write code to send one email you can just write more code to send another. That...

What permissions is SSIS running under? Does it have rights to the file?

I have been a DBA in the past, although I have never considered my skill set up to true DBA standards. In my current job (just started a few...

Latency

Ugh.

Although I agree the wording/typos in this question had me a bit confused at first, this was a great question.

The best questions IMHO are those that make me want...

Well you could use the Execute SQL Task to create a couple of temporary use tables and then drop them when all your data transformations are completed and still do...

Date manipulation is always something I have to lookup. Hopefully this can help me remember it so I can just write it.

Thanks,

ptjj (4/7/2010)

---

Table1:

Clo1(PK)Col2Col3

1AX

2BNull

3CZ

4DNull

Table2:

Clo1(PK)Col2Col3

1PP

2RY

5GZ

Result:

Clo1(PK)Col2Col3

1AX

2BY

3CZ

4DNull

5GZ

Conditions:

1.If a record with the same primary key is found in both the tables (table1 and table 2), then the Table1 records should be used. All the columns...

I am not in a position to test this, but I think you can add a scoping component to your sum where the scope is the grouping you are referring...

Meetings...

Where minutes are kept, and hours are lost.

If you have an existing database you already have a Datawarehouse. It is just not what traditional BI or datawarehouse people would consider a datawarehouse. Almost all reporting...

Ray,

I expect to join the same train in Hudson (First stop south of Rensselaer). Is there a way to contact you offline?

Dan