Phil Parkin

Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 13,874 total)

Reply To: Use ssis Script Task to send a zip file to an Oracle API

Is there no documentation for this API which explains how to use it?

February 12, 2020 at 5:40 pm

#3725180
Reply To: Excecute dynamic

Steve Collins wrote:
According to the timestamps you answered your own question half a day before it was even asked!
DBCC TIMEWARP at its best.

February 11, 2020 at 1:32 pm

#3724725
Reply To: Blocking during bulk insert between table swaps

Have you considered using SYNONYMs to perform the swaps, rather than sp_rename? Might be worth testing.

February 10, 2020 at 10:31 pm

#3724539
Reply To: getting rid of "OR"

I'd also vote for the temp table option. Makes the code cleaner.

February 10, 2020 at 7:19 pm

#3724491
Reply To: SQL Server 2016 + Visual Studio 2017 Setup for SSIS

In my opinion, this does not sound like a robust development environment.
Your packages, together with projects and solutions, should be in source control. They should also be deployed to servers...

February 10, 2020 at 6:53 pm

#3724484
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
and don't ask why we want to choose the columns in sql - I suggested doing a "select as many as you need" and use a show/hide property in...

February 10, 2020 at 1:43 pm

#3724359
Reply To: Copy latest sql full backup file from one server to another

The OP did in their opening post.
That's twice in two days you've highlighted my inability to comprehend basic English, you scoundrel! 🙂

February 7, 2020 at 2:36 pm

#3723950
Reply To: Copy latest sql full backup file from one server to another

Thom A wrote:
Personally, I would use Powershell to do this, which can be put directly into an Agent Task; thus no need for SSIS
No one mentioned SSIS apart from you!

February 7, 2020 at 2:26 pm

#3723946
Reply To: Error in SSIS Foreach Loop

Run the package in debug mode so that you can inspect the variables for every trip round the loop. That should help you track down the issue.

February 7, 2020 at 2:10 pm

#3723944
Reply To: Copy latest sql full backup file from one server to another
Put the latest file name in a variable and then use that variable for your copy. Here is some code which does that, for any file in c:\temp:
February 6, 2020 at 8:36 pm

#3723762

Reply To: Getting only MM/DD from the Column of type varchar(50)

Like this?

DECLARE @x VARCHAR(50) = '2020-02-06'

SELECT @x, REPLACE(RIGHT(@x,5),'-','/')

February 6, 2020 at 6:49 pm

#3723724

Reply To: DATEFROMPARTS and CONVERT failing but only when inside an SP

MVDBA (Mike Vessey) wrote:

Phil Parkin wrote:

MVDBA (Mike Vessey) wrote:
upgrade quickly, then you can use querystore and plan guides
Yeah, just wing it. I'm sure everything will be OK 🙂

that is what my IT director keeps telling...

February 6, 2020 at 6:46 pm

#3723721

Reply To: Getting only MM/DD from the Column of type varchar(50)

What format is it in now? YYYYMMDD? MM/DD/YYYY? etc

Also, why not use a DATE (or DATETIME) column to store dates? That's what they're for. Makes everything so much easier.

February 6, 2020 at 6:44 pm

#3723719

Reply To: Copy latest sql full backup file from one server to another

What command are you running from SSMS to perform a file copy?

February 6, 2020 at 6:38 pm

#3723717

Reply To: Copy latest sql full backup file from one server to another

Have you configured the job to run as you?

What errors do you get with a straight copy?

February 6, 2020 at 5:30 pm

#3723696

Viewing 15 posts - 2,956 through 2,970 (of 13,874 total)