They meant column-level encryption, perhaps? My head would explode if I had to do that on an entire database though.

What is the datatype of Length?

What datatype would you like the calculation to return?

Your problem is likely to be integer mathematics. Why not just use

Length * 0.75

in any case? This...

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

Not a direct answer, as I never use the FST, but maybe try doing the file move in a Script Task and see whether the outcome is any different.

..Can be thought of? Are you saying that if a loop in a cursor contains multiple actions, and...

To get the tables in a database, use sys.Tables:

SELECT Schma = SCHEMA_NAME(t.schema_id), TabName = t.name
FROM sys.tables t;

I'm sure that you can work out the rest by yourself.

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

Phil:

After playing with that query, I notice it gives me all the "Step_Names" as being "(Job Outcome)" and the Job_Descriptions are all of the job itself, but not the...

When you have to manage hundreds of scheduled jobs on busy production servers, inevitably situations arise when jobs take too long to complete, causing substantial waits or affecting the...

Yes, I see it. But my C# is not advanced enough to know how to fix that, apologies.

Does this get you anywhere? Haven't got any failed jobs to test it on at the moment.

WITH OrderedJobs
AS
 (SELECT
      j.job_id
  ,...

Please try again, as I...

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

Have you verified that the web service call using exactly the same URL as in your code works properly outside of SSIS, using something like Insomnia (https://insomnia.rest/)?

This is a script component source, presumably? (Rather than a transformation.) Is the code part of the CreateNewOutputRows() sub?

Does the version of SSDT you are using allow you to debug...

If the code is not too lengthy, perhaps you could post it here? (Sanitised as necessary.)

You've given us lengthy pieces of code and a description of what you are trying to do, which is good.

But you have not described the problem in enough detail. What...

This is good advice, as far as it goes, but I suggest there's more that could have been covered here, including

a) Sample loop code, including a discussion about whether to...