Sorry Thom, you are right. My brain transformed this

you can use a Derived Column Transformation, and just have the expression for said column be the variable the path is in

into...

It is available only in the Data Flow.

That means that the derived column needs to be recalculated for every row in the file ... potentially not very efficient, given the unchanging file name....

Just a guess as to my strategy - I'm using variables to hold the values of each field as the process iterates through each row of...

A script is probably not necessary. A calculated variable, using the variable holding...

I'm going to assume that wine or beer...

It should update.

SSRS does cache data between report executions, but (as far as I know) this caching is only at the session level.

Activation Date is a runtime parameter, is that...

Sorry, I'm being an idiot.

I'm getting the following error

Msg 15151, Level 16, State 1, Line 1 Cannot alter the schema 'Config', because it does not exist or you do...

Your code is merely returning results. If you want to run the code, you need to paste those results into SSMS and hit F5 ... very carefully and having backed...

This is a good start, but there's more that I suggest you do.

1. Create INSERT statements for some sample data to populate your Football_Matches table.
2. Provide two or three alternative...

How about providing some data in the form of CREATE TABLE / INSERT statements, so that people here have something to work with?

I can't see your data, so it's hard to tell. Can you post some sample data... CREATE TABLE script, INSERTS... so we have some idea what your data looks...

With >2,000 points, you should know how to submit formatted SQL by now.

CREATE VIEW dbo.vwTEST --
AS

WITH t
AS (
   SELECT er.Ece_ID
     ...

• This reply was modified 4 years, 9 months ago by Phil Parkin.

Hi Phil,

That's exactly what I was looking for!

I did find the Profiling Node in SSIS which gave me similar stats to what you extracted in Python.

I also like the...

As far as I know, there is no fixed way of doing this.

I used to have a series of files which were loaded every month and we had to be...