Viewing 15 posts - 2,956 through 2,970 (of 13,877 total)
If you want help with actual T-SQL, please take the time to post your data in a format which we can all consume (with CREATE TABLE DDL and INSERT ......
February 13, 2020 at 4:02 pm
#3725660
I created an expression for Argument and that worked
Good idea, well done.
February 12, 2020 at 8:41 pm
#3725381
Can you try the same thing, but using a file path which does not contain spaces?
February 12, 2020 at 6:38 pm
#3725198
Is there no documentation for this API which explains how to use it?
February 12, 2020 at 5:40 pm
#3725180
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
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
I'd also vote for the temp table option. Makes the code cleaner.
February 10, 2020 at 7:19 pm
#3724491
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
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
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
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
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
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
Like this?
DECLARE @x VARCHAR(50) = '2020-02-06'SELECT @x, REPLACE(RIGHT(@x,5),'-','/')
February 6, 2020 at 6:49 pm
#3723724
MVDBA (Mike Vessey) wrote:upgrade quickly, then you can use querystore and plan guidesYeah, just wing it. I'm sure everything will be OK 🙂
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