Ed Wagner (10/21/2014)

Sean Lange (10/21/2014)

rodjkidd (10/21/2014)

spaghettidba (10/21/2014)

rodjkidd (10/21/2014)

Welcome back...

spaghettidba (10/21/2014)

It's been a very long time since I last posted on THE thread...

Actually it's been a very long time since I posted regularly on the forums, but now I...

Depending on the kind of error, the entire flat file might be regarded as erroneous.

For example, if a delimiter is missing, it might mess up all the rows that come...

Take a look at this excellent splitter function by Jeff Moden[/url].

You only want data from one patient?

Is patientID the same across all dimensions?

Instead of doing this probably quite costly migration, why don't you create a simple ODS or data warehouse?

Something like this?

DECLARE @CurrentTerm VARCHAR(10) = 'Term5';

SELECT studentID, PrevFailTerm = MAX(Term), CurrentTerm = @CurrentTerm

FROM myTable

WHERE Term < @CurrentTerm AND Result = 'Fail'

GROUP BY studentID;

Very excellent question.

Thanks Sean.

With SSIS package logging you mean the logging you define yourself in the package?

Personally I would store these in a seperate database, not in the SSRS database or the SSIS...

Nice question, thanks.

Is it an indexed view?

If you find that any advice given to you was below your standards of quality, the people that gave you the advice will gladly refund the...

What is the error?

It seems someone's account has expired. Contact the administrator in charge of Active Directory.

A clustered index doesn't need to be of data type int. Typically you would create your clustered index key as small as possible though.

I would just ignore the advisor (as...