Are you able to break down the load times for the different components?

I'm guessing that it's the fact table reload that takes most time. Have you tried using (cached) lookups...

So do you truncate your fact table every load too?

Anjan Wahwar (4/15/2014)

---

Hi All,

I have the requirement to load source txt file and perform incremental update on my destination table. As I was not allowed to create any table to...

I mean are you redirecting error rows - have you checked...

Resender (4/14/2014)

---

yes I changed them both from string DT_STR to DT_WSTR & that leads...

Did you modify the datatype of the column in both 'External Columns' and 'Output Columns'?

a4apple (4/10/2014)

---

Unnati, see this.. You will be needing to use a Select statement like this and capture the result.

DECLARE @String VARCHAR(MAX) = 'SourceFile1_20140803073209.txt'

DECLARE @String1 VARCHAR(MAX) ='SourceFile1_2014073209.txt'

SELECT @String AS [String] ,...

The complexity of the problem means that a derived column solution is unlikely to be practical.

A Script Component would allow you to write code with as much complexity as you...

Can you post the error...

Resender (4/11/2014)

---

Ok, I've been confronted by this problem during the week where I'm the only guy not on break on our SQL team.

I got a series of databases that have...

From this I understand that the package format is upgraded - does it mean that the package (& functionality contained) will not run against 2008 when using the dtexec command...

peter 89731 (4/10/2014)

---

Hi,

The company I am working for has a 2008r2 server and packages developed using bids 2008. They are also using TFS, and because of some of the...

..along with >99% of others, I would guess 😀

Phil, you're really a great resource on these forums and have...

And regardless of where those servers are, you can still get rid of SORT components if you decide to keep the Merge Joins.

Note also that SSIS may do some caching to the...