Solution found.....Close the package and reopen....

maybe working at 23:30 isnt such a good idea

Thanks for all your responses guys.

Regarding the multiple join table, IO is one of the things that we try our hardest to limit as a development team and having reviewed...

I realised that i could use the lead function to process the next row as a separate column:

Select *

FROM

(

SELECT ID,

[Data],

--Concat('(''',[Data] Collate SQL_Latin1_General_CP1_CI_AS,'''),'),

--Case when [Data] like 'A12b%' then...

Hi Kevin,

Thanks for your response.

The case statement has been my savior in such situations, however when applying the lag function in this instance only yields the next null result...

Unfortunately I cannot post the table or data due to confidentiality reasons, however an extreme simplification of the problem:

CREATE TABLE [dbo].[Team]

(

[FirstName] [varchar](20) NULL,

[LastName] [varchar] (20) NULL,

[Team] Varchar (20) NULL,

[TransactionID] int,

Price...

So ladies and gents....

I found the cause of the validation error :w00t:

Within the File System Task Properties there is a section named "Execution" under which there is an option to...

Still no luck with this gents.

I have changed the query so that the file path is returned in the SQL statement rather than using the variables in SSIS and...

Thanks Aaron, great piece of advice

So what i have done now is to have a SQL task Feeding into a ForEach Loop which will then move the file from source...

I'm attempting to do something very similar at the moment.

My task however is slightly different...

What i am trying to do is move files from one location to another location and...

Sean Lange (5/1/2014)

---

Just an fyi...the code you posted is what is known as a multi statement table valued function (mstvf). These are very poor performers. In fact, a typical scalar...

Thinking about it now maybe a SPROC would have been better to use

Thanks For clearing this up Koen,

with regards to this seperate table i was contemplating creating a table where anything prior to current year is negative, current year is 0 i.e....

Im ever so sorry guys, i didnt see the 2nd page

The best way to show the result would be to see the spreadsheet attached

Update:

I have taken the Type, ID and Date of each of the tables, union'd them and sorted them to give me a chronological view.

The next stage im thinking would be...