manivannan.kariamal (1/11/2012)

---

Hi,

I have a dimension DimCustomer which has only two Attributes DimCustomerKey(int),Segment(char(10). The data in the dimension table will be as below.

DimCustomerKey STN ...

balbirsinghsodhi (1/11/2012)

---

I am wondering if it is possible to call SSIS objects from stored procedure. I can call dtsx file from stored procedure but like to call objects inside the...

You will have to test it in different scenarios to ensure that it works.

I understand that creating a data conversion task for every package is a little bit of...

Data from an Excel source is always unicode, so unless your destination table's columns are all unicode you have no choice but to use the data conversion task to convert...

Sean Lange (1/5/2012)

---

Evil Kraig F (1/5/2012)

---

You're giving it too much credit. It was cool for about as long as Tickle Me Elmo... then everyone finally realized that giggle is...

That would be better, yes. Flashing text seems a much better idea in theory than it actually works in practice. It usually turns out to be more of a frustration...and...

Christopher West (1/5/2012)

---

Hi Everyone,

Is it possible to display flashing text in Reporting Services? I'm thinking if I could change the color of the text every...

No problem, glad I could help.

Yeah, it does seem pretty strange. Also check for NULLs, because that could also cause some issues when combined with something else.

david.kratz (12/23/2011)

---

Expression is very simple:

=iif(Fields!DEATHSTATUS.Value="DEATH","died "&Fields!DEATH_DATE.Value," ")

The last few hours I tried running my program to obtain an image. Now that I've finally obtained an image I find this...

Capt. Sigerson (12/23/2011)

---

If anybody's still listening, I've run into a small wall in SSIS. I get a quote-delimited CSV file that I want to upload to a SQL Server...

You will have to give more information. Can you post a screenshot, as well as the expression you are using?

jeberhard-623651 (12/23/2011)

---

You would think Microsoft would make getting data from a SQL database to an Excel file easier than this. I still haven't gotten it to work but I'm...

jnawrocki (12/22/2011)

---

I have a parameter in a report (SSAS data source) that is defined as a date range inclusive. In the query designer it only list one parameter. When you...

jeberhard-623651 (12/23/2011)

---

Thanks. I think I tried deleting the excel file first and then got mapping errors in the data flow task. I had manually deleted the file from...