Viewing 15 posts - 556 through 570 (of 5,109 total)
Jeff Moden wrote:What would you use to run the PowerShell script on a scheduled basis? Please don't say the "Windows Task Scheduler".
SQL Server Agent can run Powershell tasks natively.
Can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 2:21 pm
What would you use to run the PowerShell script on a scheduled basis? Please don't say the "Windows Task Scheduler".
SQL Server Agent can run Powershell tasks natively.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 2:02 pm
What do you mean by "won't let you copy it"? What are you actually doing with the xml, as opening view code and copying it out for each package seem...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 12:55 pm
One idea, using Powershell, would be something like this.
Firstly set up some test objects:
CREATE TABLE dbo.ServerList (ServerID int IDENTITY PRIMARY KEY,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2020 at 10:24 am
Are you actually trying to test if the server is online or if a service on the server is online? Just because you can ping a server, doesn't mean that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 18, 2020 at 2:38 pm
You can call an SP without using EXEC, however, it must be the first thing you do in the batch. From SQL Server Utilities Statements - GO:
Users must follow...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 18, 2020 at 12:59 pm
FYI, Cross post on Stack Overflow. not sure why The OP posted this here, when they already had 2 answers on there...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 18, 2020 at 12:38 pm
Ahh, there we go. Your column, in the Flat File, is defined as string (DT_STR) not unicode string (DT_WSTR) as a result you get the error you got, as you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 18, 2020 at 12:27 pm
The error is in the Flat File, not the Data Conversion Transformation. Seems like you've defined the column to be smaller than 250 characters in there. By default, a Flat...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 18, 2020 at 11:22 am
Out of interest - by 'later', are you saying that the CAST/ TRY_CAST is being executed in the SELECT before the WHERE?
That shouldn't be possible. Per Logical Processing...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 10, 2020 at 2:55 pm
apparently there are just over 1,000 fields in the table ….select * is a bit of a no-go
we do advise, but often we are not heard
Over 1,000 fields; so...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 10, 2020 at 2:34 pm
going back to the original topic - are the questions getting stupider
i got asked if this represents a sql injection risk 🙁
It honestly terrifies me how frequently...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 10, 2020 at 12:40 pm
Just download and install the correct Microsoft Access Database Engine 2016 Redistributable file.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 10, 2020 at 8:54 am
Can anyone recommend a powershell forum? Invoke-webrequest loses some of its parsing in powershell 6 (especially the forms part)
I tend to google things if I'm honest, not really found...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 4:58 pm
The OP did in their opening post.
That's twice in two days you've highlighted my inability to comprehend basic English, you scoundrel! 🙂
Don't worry, I'm pretty sure you see my...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 2:38 pm
Viewing 15 posts - 556 through 570 (of 5,109 total)