mildofly45 (12/16/2011)

---

It's SSIS 2008 and I've set the Lookup for full cache, redirect rows to no match output. It does work but takes a long to time to cache as...

ChiragNS (12/16/2011)

---

Hi

Does the source table that you populate your data from have a identity column as the primary key ?

If so you can take the max of that in the...

Are you trying to connect to SSAS from an Excel sheet, or are you trying to connect from SSAS to an Excel file?

How did you configure the Lookup transformation? (which version of SSIS are you using?)

NOT IN is actually not a good option, as it is not really scalable. If ReportTable has...

How did you configure the child package connection manager? With an expression?

Are you sure you deployed the last version to the server?

sqlfriends (12/15/2011)

---

We have a table for a column called FTE, its data type is decimal (6,2). it stored values of 1.00, 0.33, 0.50.

Now I have a flat file source which...

There are multiple options:

* you can use the MERGE JOIN to join the two datasets together. The input needs to be sorted, so if your flat file has a lot...

If you cannot type them, how are...

What is this "nill" feature of SQL Server 2000? I want it too! 🙂

edit: that list is a bit short. Spatial data is not mentioned, the FOR XML PATH is...

GSquared (12/15/2011)

---

It does not use SQL Server Database Mail.

However, if all you want to know is does SSIS use Database Mail, the answer is no. Nor does it use...

Thanks for the question Steve.

Good way to close the work week.

Does it work in BIDS?

How did you configure the analytical dataset and how do you link it with the map?

ALZDBA (12/15/2011)

---

Darned, I loved that series.

You've just made my day even better. #Goodtimes

The IT crowd - Truest moment...

Dev (12/15/2011)

---

I don’t think there are organizations (even the giants) which employ BI DBAs or HA DBAs. If you are a PROD DBA, you are assumed to be...

Annoying...