Phil Parkin

Forum Replies Created

Viewing 15 posts - 5,926 through 5,940 (of 13,877 total)

RE: Getting the first of the month based on yesterday's date

SSIS dateadd/datediff syntax is different from that in T-SQL. You could try this:
DATEADD("m", DATEDIFF("m", (DT_DATE) 0, DATEADD("d",-1,getdate())), (DT_DATE) 0)
Replacing Getdate() with your date, of course.

February 16, 2017 at 7:34 am

#1928846
RE: Upgrade from 2014 Enterprise to 2016 Standard

postfix - Thursday, February 16, 2017 5:25 AM
As I can see this upgrade path is supported.

https://msdn.microsoft.com/en-us/library/ms143393.aspx
During in-place upgrade I got...

February 16, 2017 at 5:37 am

#1928811
RE: Getting the first of the month based on yesterday's date

Kazmerelda - Thursday, February 16, 2017 3:49 AM
Hi All,
I have tried several things and it's not doing quite what I need it to.
So...

February 16, 2017 at 5:34 am

#1928810
RE: The value could not be converted because of data loss SSIS

EasyBoy - Wednesday, February 15, 2017 6:08 AM
Hello,
I am working on one SSIS package, which convert CSV file to SQL table. But somehow,...

February 15, 2017 at 6:58 am

#1928612
RE: SQL Server Export Wizard Problem with constraints

Perry Whittle - Wednesday, February 15, 2017 6:20 AM
I could be wrong but I'm guessing the question ishow do I fix it?
There are...

February 15, 2017 at 6:55 am

#1928609
RE: Moving data from Excel file with different name to SQL table using SSIS

Thom A - Wednesday, February 15, 2017 6:34 AM
Phil Parkin - Wednesday, February 15, 2017 5:42 AM

February 15, 2017 at 6:45 am

#1928604
RE: Moving data from Excel file with different name to SQL table using SSIS

Helpseeker - Wednesday, February 15, 2017 1:16 AM
Hi, Am new to SSIS.
i have a requirement.
Everyday Excel file will be uploaded into one folder...

February 15, 2017 at 5:42 am

#1928588
RE: SQL Server Export Wizard Problem with constraints

polo.csit - Wednesday, February 15, 2017 5:05 AM
TITLE: SQL Server Import and Export Wizard
------------------------------
Error 0xc002f210: Preparation SQL Task 1: Executing the query "TRUNCATE...

February 15, 2017 at 5:39 am

#1928587
RE: SET LANGUAGE failed because '' is not an official language name or a language alias on this SQL Server

Maybe this row is missing on the problematic server?

February 14, 2017 at 12:36 pm

#1928467
RE: SET LANGUAGE failed because '' is not an official language name or a language alias on this SQL Server

peter 98284 - Tuesday, February 14, 2017 12:24 PM
sorry, it's special Java based tool for Primavera P6 application, that connects to the source...

February 14, 2017 at 12:32 pm

#1928464
RE: SET LANGUAGE failed because '' is not an official language name or a language alias on this SQL Server

peter 98284 - Tuesday, February 14, 2017 12:13 PM
from the target server which is the Server 2012 R2 running SQL 2014 Standard.
Sorry, I...

February 14, 2017 at 12:16 pm

#1928458
RE: SET LANGUAGE failed because '' is not an official language name or a language alias on this SQL Server

peter 98284 - Tuesday, February 14, 2017 12:02 PM
I'm trying to migrate a DB from SQL 2005 to SQL 2014 Standard. Vendor provided...

February 14, 2017 at 12:06 pm

#1928453
RE: Use variable in the Identity Seed of create table

Welsh Corgi - Tuesday, February 14, 2017 9:24 AM
There are several tables that were created using a lookup Table to get the Primary...

February 14, 2017 at 10:05 am

#1928416
RE: Running date update

Jeff Moden - Tuesday, February 14, 2017 9:12 AM
So how long does the update through the CTE take for 1 million out of...

February 14, 2017 at 10:01 am

#1928413
RE: Running date update

whenriksen - Tuesday, February 14, 2017 7:42 AM
You can update through a CTE, you don't need the join back to the table...

February 14, 2017 at 8:00 am

#1928374

Viewing 15 posts - 5,926 through 5,940 (of 13,877 total)