1) Yes. Although I wouldn't use the SQL Server Destination. The performance gain is neglible and it has certains downsides: it only works if the package runs on the same...

What name did you specify for the server in the configuration?

If the Excel file contains the whole set of records, truncate the table and load it from scratch, as crazy4SQL suggested.

If it doesn't, you need to find the business key....

Where do you store the names of those 3 sheets?

You cannot put "unknown" in an integer column. You need to cast it to a string column.

ISNULL(DepartmentID) ? (DT_STR,7,1252)"Unknown" : (DT_STR,7,1252)DepartmentID

You can set this in the Advanced Editor of the Excel Source component.

Right click on the source, choose Advanced Editor.

Input and Output properties --> source output --> output columns.

Choose the...

By what logic do you want that last row.

Is it always the last row, or the one...

Nice question, thanks!

Lynn Pettis (2/24/2012)

---

Any way, I was offered and accepted a new position with a company in Colorado Springs. It is a full time permanant position so I won't have...

Have you ever used it before and made it dynamic with expressions?

It can be a nightmare, and .NET is easier, more...

SQLRNNR (2/24/2012)

---

Jeff Moden (2/24/2012)

---

I finally started doing the same thing and had to stop. They really took serious offense to me hitting the server with a...

Maybe SSAS gets only a really small portion of your 3.5GB?

Fragmented? There are barely 3 report building applications. (4 if you...

No problem Madagul. 😉

Raghavendra Mudugal (2/24/2012)

---

anthony.green (2/24/2012)

---

Raghavendra Mudugal (2/24/2012)

---

SQL Version

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation ...