Viewing 15 posts - 1,201 through 1,215 (of 2,917 total)
Ok, I just misread the error.
If you import into memory (ie have no output step on the Excel import), do you still get the same error?
I am just thinking MAYBE...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 14, 2021 at 3:59 pm
Figured this out for you:
https://data-dev.blogspot.com/2017/03/ssis-export-data-to-excel-with-more.html
It is a limitation of the SSIS Export to Excel that 255 characters is the max. The workaround was to export to a flat file (txt,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 14, 2021 at 3:31 pm
My opinion - you should implement any security based things that you require. Sounds like a dumb response, but think about it from a hacker perspective. If a hacker gets...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 14, 2021 at 3:14 pm
I think the RTFM type responses, when written properly, can be just as helpful as asking the right questions.
I mean, if your response is "RTFM" and nothing more, then I...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 14, 2021 at 2:10 pm
Not sure if C: is the correct location to put SQL files as you are then sharing the disk I/O with the OS.
BUT one way you could do this would...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 14, 2021 at 2:02 pm
Looking at it, it is because you are comparing VARBINARY to VARCHAR. So SQL is implicitly converting your VARBINARY(MAX) to a VARCHAR and VARBINARY 0x0A2E0A is not the same thing...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 13, 2021 at 8:31 pm
You cannot "trick" it; CSV is unformatted data. Excel is trying to be helpful because it THOUGHT it was a numeric value.
I don't think there is any way to convince...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 13, 2021 at 8:17 pm
Not sure if the characters after the period really matter. From reading up on the telnet email approach, I think the mail server is just looking for a line that...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 13, 2021 at 7:56 pm
Probably, but I don't know RegEx very well and I often get it wrong so I prefer to avoid RegEx.
Also, I don't think SQL Server handles RegEx natively.
Do you need...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 13, 2021 at 6:07 pm
That would miss it.
You are getting 0A0A2E0D0A so 0A (CHAR(10) 0A (CHAR(10)) 2E (period) 0D (CHAR(13)) 0A (CHAR(10)) which is weird to me.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 13, 2021 at 4:27 pm
One way (that is a pain in the butt but reliable) would be to cast the string as VARBINARY.
I recommend doing it with selecting the text and have the varbinary...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 13, 2021 at 2:19 pm
If the prefix and suffix you are wanting to remove are static known values, then probably the easiest way to remove them is with REPLACE:
REPLACE(REPLACE(column,'ZZZ ',''),' (left)','')
I...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 12, 2021 at 9:25 pm
Possibly a dumb question but would it be faster to do this on the application side? Not sure how much data you are pulling (in MB/GB) if you just did...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 12, 2021 at 5:50 pm
If it is related to parameter sniffing problem (which it sounds like to me, but I also would not be surprised if I was WAY off on this), adding the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 12, 2021 at 4:05 pm
One thought on how to "fix" this (based on the reply to the thread you indicated) would be to have that column returned inside a CASE statement where you could...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 11, 2021 at 3:32 pm
Viewing 15 posts - 1,201 through 1,215 (of 2,917 total)