Thanks for posting back. Seeing improvements like that winds my clock.

You must be processing a lot of data for it to continue to take 43 minutes. If this is...

I have a suggestion:

Ditch the Upsert Component and instead do this:

1. Add an Execute SQL Task above your Data Flow to truncate a new staging table* in the target...

A workaround is to use a Script Task to generate your "current datestamp" at the beginning of your Package and assign that to a Variable of type String. Then, for...

I think prefixing database objects makes code more difficult to read, initially. Eventually the brain gets used to ignoring prefixes and one could argue maybe even begins to expect it....

I am pretty sure you will not be able to see the Output Column options in the Import/Export Wizard. Before you complete the wizard, is there an option to save...

TAman (1/22/2016)

---

No. I understand variables. That was not my question. I'll try to break it down deeper. My question is how to load an excel that contains sheet$...

it is either character encoding issue or length causing truncation. can you post a Workbook (with sensitive data masked) tha causes the issue on your side that I can use...

Try NVARCHAR(MAX).

What kind of file is it? a CSV you opened in Excel or is it an Excel Workbook (xls or xlsx)?

@ringovski, you're welcome, happy you got something suitable going.

@Eirikur, agreed your solution should improve performance. It took me a second to cull out the test data creation from the...

Funky stuff. Thanks for posting it. I would not expect anything but a scan out of the iTVF query plan even if you could remove the function. If you are...

boettger.andreas (1/21/2016)

---

Sure.

ALTER FUNCTION [dbo].[ICAgeingFuncT]

(

@CutOffDate varchar(6)

)

RETURNS TABLE

AS

RETURN

(

SELECT SUM(TRANSCOST) AS ItemValue, SUM(Quantity) AS Qty

FROM ICIVAL

WHERE LEFT(TRANSDATE,6) <= @CutOffDate

);

SELECT a.ItemValue, a.Qty, p.YearMonth, p.Period

FROM Past12Months as p

CROSS APPLY dbo.ICAgeingFuncT(p.YearMonth)...

I just had a chance to dig up a table-size script. For every 11K rows (30 years of dates) the calendar table I posted occupies 2.75 MB of space in...

Is session 2 still waiting after session 1 is complete? As an aside, in session 1 you do not need an explicit transaction. Statements in SQL Server are atomic meaning...

Convert the function to...