Viewing 15 posts - 16 through 30 (of 4,949 total)
Doesn't SSIS allow you to run a CMD Task where you could issue the following simple DIR command and capture the output to a table? It'll give you the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 30, 2022 at 8:35 am
Sorry, I was wrong with what my needed output should be, I needed this, in other words keeping those with just one date:
123548, '2022-02-21'
985254, '2022-03-19'
774589, '2022-01-17'
754512, '2022-04-04'
All the information...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 27, 2022 at 8:20 am
The standard approach for this is to use a CTE and ROW_NUMBER
to get the "top 1" in each group. You can also use a windowed COUNT
to allow you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 26, 2022 at 4:09 pm
Then it seems that what you want, as I mentioned, is a Foreach Loop container; that can loop on the contents (including subfolders) of D:/Employees
and you can filter to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 26, 2022 at 8:38 am
What is the end goal here? You could, for example, easily use a Foreach Loop Container to go through the folders recursive and filter to zip files. Why does it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 25, 2022 at 3:19 pm
Considering that Office 365 didn't exist in 2012, then it might not be able to, if I am honest. If you know support is on SQL Server 2016+, however, and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 24, 2022 at 3:16 pm
it would be 7
But why would it be 7? You haven't explained the logic for 4_5
and 4_2
either.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 20, 2022 at 2:32 pm
The short answer is yes, you can do this in SSIS. It has a range of connection managers, and you would be able to connect to MySQL and SQL Server...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 20, 2022 at 2:11 pm
What about the rows which have a value of 'Prod10000'
? How do you determine what value of Prodstatusid
is returned; is that the MIN
too? What is the logic for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 20, 2022 at 1:56 pm
SSAS for Visual Studio 2022 is also now available. So SSIS is the only one that is missing.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2022 at 9:15 am
You've been around enough to know by know that images of data don't help us help you, and that DDL and DML is much better for making it easier for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2022 at 1:59 pm
or should I use the TRIM's then the LEFT?
That is what you are doing; the LTRIM
would be processed first, then the RTRIM
, and finally LEFT
. Perhaps you mean...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2022 at 3:33 pm
With that said, how do you choose to leave "notes" in an .rdl?
You don't. This is exactly what Version Control is for; so you can note what you have changed....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 9, 2022 at 5:20 pm
Also, an nvarchar(max)
is the wrong choice of data type. HASHBYTES
returns a varbinary
with a length of up to 8000
.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 9, 2022 at 1:33 pm
If you are trying to, perhaps compare the hashed value to the user input, what you should be doing is rehashing the value (in the application) and then comparing it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 9, 2022 at 1:31 pm
Viewing 15 posts - 16 through 30 (of 4,949 total)