Yes, I am currently using a similar type of design in a very specific application where it would not have been feasible (or even possible) to do daily snapshots.

There was...

It is because you are passing a null value of the wrong type. You cannot use DT_WSTR in this case, because the destination field is expecting an integer value.

winston Smith (1/11/2012)

---

I have read the SSIS Package Configurations MSDN Article (http://msdn.microsoft.com/en-us/library/ms141682.aspx) and it states that:

You cannot use the /ConfigFile option to load configurations that replace the configurations that you...

winston Smith (1/11/2012)

---

Ive read online how you can set a variable as "sensitive" in SSIS so that, depending on the protection level, its data will not be stored.

I cannot figure...

manivannan.kariamal (1/11/2012)

---

Thanks for the reply.

My dimension is having 5 billion records and 27 columns(apart from the columns I've given). If we change the relationship to 'flexible', will it affect the...

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...