Viewing 15 posts - 1,786 through 1,800 (of 13,838 total)
Are you referring to the output generated by the SQL PRINT statement?
October 27, 2021 at 2:23 pm
Scott's solution was correct, with the possible exception of the ordering of results. Here is code to prove it.
DECLARE @x TABLE
(
FileName VARCHAR(50) NOT...
October 27, 2021 at 2:19 pm
Well you could do two sets of replaces, so something like replace all the numbers with a letter first then replace all the letters with the new number 🙂
I...
October 23, 2021 at 11:35 am
Removed
October 22, 2021 at 2:13 pm
They meant column-level encryption, perhaps? My head would explode if I had to do that on an entire database though.
October 22, 2021 at 11:02 am
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...
October 21, 2021 at 1:57 pm
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.
October 21, 2021 at 11:48 am
Each loop in a cursor can be thought of as a transaction
..Can be thought of? Are you saying that if a loop in a cursor contains multiple actions, and...
October 20, 2021 at 10:06 am
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.
October 20, 2021 at 8:29 am
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...
October 20, 2021 at 8:17 am
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...
October 20, 2021 at 5:31 am
Yes, I see it. But my C# is not advanced enough to know how to fix that, apologies.
October 19, 2021 at 3:11 pm
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
,...
October 19, 2021 at 3:07 pm
Yes, I already did the test from CMD and on a dedicated API platform.
I added a screen shot from the debug to the preceding post..
Please try again, as I...
October 19, 2021 at 2:44 pm
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/)?
October 19, 2021 at 2:14 pm
Viewing 15 posts - 1,786 through 1,800 (of 13,838 total)