Dird (6/5/2013)

---

floresg2 (6/5/2013)

---

How often have you used...

Concur with one pkg = one table, whether fact or dimension. the times I have bundled more than one process/table population into a package, I wound up regretting it....

we host clients using our own app so we also have multiple servers, multiple databases, all identical.

We built a source component that "makes the rounds" to run the same query...

My understanding is that there is not the ability to have dynamic connections. I have split packages into mult pkgs to get around it.

Koen Verbeeck (3/28/2013)

---

Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.

Because someone has to answer all those BI questions on this forum...

grasshopper26 (10/29/2012)

---

Scott Murray-240410 (10/29/2012)

---

grasshopper26 (10/28/2012)

---

I am new to SQL Server OLAP Cubes. I am having the following issue like

ex I have purchase order and invoice tables which are used in...

I'd look at the job step carefully as maybe someone accidentally made a change to T.

You also might consider running it via command line. Sometimes just looking at what...

I think it will likely be a driver issue but honestly have not worked in '97 for a very long time.

As a workaround, you might try exporting to csv and...

Wouldn't you already know which was faster?

I do not know which is Better, as that could have much to do with your environment.

First off, this isn't a great place to post issues with SQL 2005 as DTS is 2000 and previous.

Try the SQL 2005 / Integration Services forum UNLESS these are actually...

SQL_Surfer (10/17/2012)

---

1) Scheduling the processing of the full cube was working fine until

I disabled one of the columns from browsing and re deploy the cube.....

2) Now the issue is I...

Sorry, I was referring to the Process Cube window ("Process Progress") that I believe is generated no matter how you attempt to process. Bottom part is all gray, shows...

jtc900502 (9/14/2012)

---

Is it insane to have SSIS to use a Stored Procedures to do incremental loads into DW, if the frequency is like every 5 minutes?

Here is the bacground. We...

I'm not a guy, but I can tell you that there is no provision for dynamic source out of the box.

den_sidr (10/18/2012)

---

Gentlemen,

i use DataFlow Task in a 'foreach...

Not quite sure what is in your variables, but try using double slashes \\ as there is some weirdness in the way SSIS reads pathing.