Forum Replies Created
Viewing 15 posts - 2,446 through 2,460 (of 2,917 total)
-
RE: SSIS Security Accounts
Could you provide more information such as the error and information from your logs?
I do not have that problem. I have my SSIS packages run as a job where...
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. -
RE: Need to move the file from client's ftp to local server using powershell
SSL makes this a whole new beast actually. You need to encrypt the data before sending it out to the FTP server and decrypt it upon reciept.
I suggest...
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. -
RE: Need to move the file from client's ftp to local server using powershell
newdba2017 - Monday, July 10, 2017 11:55 AMThe 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.RE: Fast Query - Slow Report Generation - Why?
You also say you are doing this through visual studio. Have you tried closing visual studio, removing (or renaming) the .data file related to that report. If memory serves, 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.RE: Replicate process from excel to sql
Radders - Monday, July 10, 2017 7:57 AMHi sgmunson,
the Case statement will not accept the code, I get
unless I'm...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.RE: Need to move the file from client's ftp to local server using powershell
I think your URI is wrong.
Was doing a bit more snooping (as I'm not 100% familiar with how that works) and I THINK you are missing the URI...
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.RE: Index Usage Details.
My only comment on that is your last line: "and i.name in ('')". that'll remove all of the indexes, no?
but the last_user_* columns can be interesting too. I mean,...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.RE: Create Multiple SSRS Subscriptions for a Parameterised SSRS Report - Programmatically / Dynamically / Quickly
Any update on this?
I am curious if you found a different solution to the problem that we didn't think of or if you just manually re-created all of...
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.RE: Data flow concept - Thoughts wanted
Depending on how your relationship with your customers is, you could push back and tell the customer to provide the document in a specific format?
Failing that, 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.RE: SQL Server backup error. Operating system error 3(The system cannot find the path specified
I am willing to bet the drive is mapped at logon.
So when the service account runs the job, it is not mapped as the account doesn't initiate a logon.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.RE: Reading from a view intoa table is taking forever!
As another thought, does inserting it into a temporary table have the same slowness as inserting into the a real table?
That is you indicated that this:
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. -
RE: Download SQL patch Info
Adding to Theo Ekelmans's comment, I did do a little snooping to see how this could work and found this powershell module:
https://gallery.technet.microsoft.com/scriptcenter/2d191bcd-3308-4edd-9de2-88dff796b0bcThis would be using a...
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. -
RE: Reading from a view intoa table is taking forever!
how many indexes do you have on the table?
If there are a lot, maybe try disabling the indexes before you do the insert. It may even be faster...
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. -
RE: Download SQL patch Info
robert.sterbal 56890 - Friday, July 7, 2017 6:10 AM