PaulB-TheOneAndOnly (4/16/2010)

---

Jitendra Luniya (9/5/2008)

---

I think SQL Server cube data is stored physically on disk. This is because the cube will hold pre-aggregated data across the specified diemnsions. If the data...

nigel. (4/19/2010)

---

Andrew Watson-478275 (4/19/2010)

---

A more interesting result is from this:

DECLARE @sid int

DECLARE @table Table (KeyID int primary key,KeyData varchar(5))

DECLARE @idtable Table (KeyID int identity primary key,KeyData varchar(5))

INSERT INTO @idtable (KeyData)...

Well, that was an easy one 🙂

Good question to start the workweek.

Not 100% sure, but I believe you need the Integretion Services service to run packages. And for that, you need SQL Server...

You could use a configuration table and store your connectionstrings there. That way, every connection is in the same place and easy to view.

But, if you have dozens of packages,...

Ha, of course you're right.

I divised my suggestion from the template that I always use. This template has a conditional split to sort out the insert and the updates. I...

Please don't crosspost into multiple forums.

You'll find some answers here:

http://www.sqlservercentral.com/Forums/Topic903774-148-1.aspx

I think you can just use an OLE DB Source to read the data. Do...

I sure did. Make it a double and have one yourself 😀

Two hours today that is 🙂

(I don't count the hours constructing the package, that...

You could also add Testing, but you can see that as a part of development. It kind of depends if the business is involved...

ps: @original poster: if you can't answer...

<rant>

I just wasted 2 hours on Excel in SSIS, so I can definitely tell you what the disadvantages are 🙂

As said before, the limitation of the rows could be a...

Amol Naik-681410 (4/14/2010)

---

Agreed da-zero. But table variables are meant to hold smaller datasets and having an index doesn't really benefit here and as regards truncation of the table variable, it's...

Hmmm, table variables have some disadvantages that temp tables haven't (and of course the other way around).

You can't truncate a table variable and you can't use DDL statements against a...

I couldn't agree more with Elliot W.

Sure you can build it in .NET, but pass a couple of million rows throught the pipeline, combined with some (complex) logic, and you'll...