Viewing 15 posts - 556 through 570 (of 5,111 total)
If you're using SSIS, I assume Visual Studio, you need to download and install the 32bit version. Visual Studio is still only a 32bit application, so only supports the 32...
February 19, 2020 at 4:52 pm
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...
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.
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...
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,
...
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...
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...
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...
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...
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...
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...
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...
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...
February 10, 2020 at 12:40 pm
Just download and install the correct Microsoft Access Database Engine 2016 Redistributable file.
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...
February 7, 2020 at 4:58 pm
Viewing 15 posts - 556 through 570 (of 5,111 total)