Viewing 15 posts - 226 through 240 (of 430 total)
Whether STRING_SPLIT() works for you is not dependent on your SSMS version. Instead, it depends on the version of SQL Server engine you are running against and the Compatibility...
July 28, 2022 at 9:23 pm
Need the sample data in a directly usable format, not in a picture, which we can't write T-SQL against.
Show me how to make this better, if you don't mind....
July 28, 2022 at 5:34 pm
I don't fully understand what you're saying, but have you tried using a for each loop based on the values of an SSIS object variable? Typically this is used for...
July 25, 2022 at 9:09 pm
or a script task with a Thread.Sleep().
Cheers for that. I assumed there was a better way of adding a delay, but never looked into it.
July 25, 2022 at 3:52 pm
- How do you get the package to automatically try the failed file again?
- Do I need to set the MaxErrorCount on the Data Flow or the Package?
I put...
July 25, 2022 at 3:03 pm
If your query contains Team = 'Illinois', those are the only rows that will be evaluated.
Lag(Score,1) over ORDER By Score) will give you the next lowest score, regardless of team...
July 22, 2022 at 9:50 pm
If it is in a for each loop, you can make it try again on failure.
There are instructions here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/
The key points are:
July 22, 2022 at 6:14 pm
You can definitely set up a single column source and create a derived column based on the first two characters and then do the conditional split. I believe you can...
July 21, 2022 at 4:01 pm
Does this do what you need?
UPDATE a
SET a.Value1 = b.Value1,
a.Date1 = b.Date1
FROM Table2 AS a
JOIN...
July 21, 2022 at 1:51 am
Not sure what you mean "Please correct the script so that it has the right columns with the right data"
.
I meant correct any mistakes I may have made in...
July 20, 2022 at 10:37 pm
I had a go at creating some sample data based on your text files dumps. Please correct the script so that it has the right columns with the right data,...
July 20, 2022 at 9:03 pm
The first suggestion was to explicitly cast or convert the Report column to xml or to try varchar/nvarchar. Have you tried that? Does something like this work? or give a...
July 19, 2022 at 10:42 pm
why its geting data from dbo table but not from user1?
The previous statement about schema scope was incorrect, the user default schema is ignored. The compiled code first looks...
July 19, 2022 at 3:19 pm
I could, perhaps, just be not finding it but they don't appear to offer any certifications on just SQL Server anymore. They keep pushing "Azure" even if you aren't...
July 18, 2022 at 6:34 pm
but the problem is it must search for tables in shcema "s2" which is default of "logins2", that is what it is not doing , and i want to...
July 18, 2022 at 4:21 pm
Viewing 15 posts - 226 through 240 (of 430 total)