For scheduled processing of cubes, you might find it simpler to write XMLA scripts & then simply call them from SQL Agent job steps (link).

Fine for small files, but -

Reading the entire file into memory as a single string will not scale.

... Script Component as Source. You can read the file once, line...

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

If you were running this package as a SQL Server Agent scheduled task, what account does the script task actually run under? I have a similar job set up...

Can you confirm that all of the files are in .XLS format?

Probably unrelated, but I saw this error when I tried to open a .XLSB file using a (ACE) .XLSX...

Returning a decimal is easy:

SELECT CAST(COUNT(*) AS DECIMAL(19,6)) / COUNT(DISTINCT p.postid)

My mind-reading capabilities are lacking today, so please state your question here.

By the way, questions end with a question mark (?)

Is this a blog post, or do you have a question?

Like this?

SELECT CONVERT(VARCHAR(10), GETDATE(), 101);

Formatting of DATE and DATETIME columns for cosmetic reasons should be left to the client & not performed in SSMS.

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

Does this work?

SELECT COUNT(*) / COUNT(DISTINCT p.postid)
FROM postlinks p;

SSIS assumes a default length of 50 for CSV columns. You need to increase that ... do you need help in understanding how to do that?

you need to run the SSIS Service

This is not correct. The SSIS service does very little, in fact, and is not required for package execution. Have a read here...

I think you need to use FINDSTRING().

FINDSTRING(nomchamps, "Administra",1) > 0

should work.

So ... you think that 'calculations and filling temp tables' are not DML?

Sounds like you have little choice. But I'm surprised that a new manager would go to the effort of changing something which was working fine (based on what you've said)....

How can this be achieved as ?*2 doesn't work.

With nearly 9000 points, you should be able to do better than this.