I have ended up with:

SELECT u.FirstName + ' ' + LastName AS UserName, LoggedInDate, LoggedOutDate,

DATEPART(YEAR, LoggedInDate) AS YearLoggedIn,

DATEPART(YEAR, LoggedOutDate) AS YearLoggedOut,

DATENAME(MONTH,ual.LoggedInDate) AS [MonthIn],

DATENAME(MONTH,ual.LoggedOutDate) AS [MonthOut],

DATEPART(WEEK, LoggedInDate) AS...

Thanks for the link I will have a read.

Phil.

It would appear this works.

Now to test it as a scheduled task.

Phil.

Hi Ed. I am all up and running with SSIS now but thanks for your input.

Phil.

So the solution for me was to follow this article with the addition of the odd tweak to suit my environment.

http://sqlage.blogspot.co.uk/2015/05/how-to-download-file-from-ftp-site-and.html

I tweaked the following:

SSIS package variable FileName:

I amended...

I have now implemented a solution. I will post when I find time 🙂

Phil.

Thanks for the feedback.

Kind Regards,

Phil.

Old dog, new tricks... 🙂

Phil.

Hi Phil. Indeed I can have multiple variables!

I found I had to perform an additional step within the SSIS project. On the FTP Connection Manager I chose Parameterize then created...

Phil one last question. If individual environment variables are created for Server Name / User / Password the subsequent SQL Agent Job appears to be only able to reference a...

Well you learn something new every day. I was having a blonde moment. I have now correctly applied the environment variable.

Many thanks for your input.

Phil.

Hi Phil. I have attempted your method. I built project then deployed project. I then selected configure 'references' 'Add'. I then selected the environment I created with FTP connection string....

Hi Phil. I was not prompted for the password. After importing the package into SSIDB I selected configure. I then selected 'Connection Managers'. I selected the connection manager of interest...

Hi Phil.

Are you using the project deployment model, or the package deployment model?

You need to use the former if you want to use environments. If you are not, I recommend...

I now have it working. The resolution.

Flat File Destination > Flat File Connection Manager >

ConnectionString = C:\pathFormat = Ragged right

Expressions = System Variables 'MyVariableName' (for path location)

To run as...