Phil Parkin

Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 13,871 total)

RE: SQL Server Master Data Services not available in SQL Server 2016 Standard edition with SP1?

river1 - Thursday, March 22, 2018 5:44 AM
It seems to me, from reply given by Gila that if we restore a Master...

March 22, 2018 at 6:00 am

#1984250
RE: File Processing Requirement.

durga.palepu - Wednesday, March 21, 2018 9:51 AM
Dear all,
We have small requirement in project. Would like to know how it can be...

March 22, 2018 at 5:26 am

#1984242
RE: SSISDB in SQL 2016

Davekahn - Wednesday, March 21, 2018 3:59 PM
Well, another DBA in office is saying we can't use .bat script with keeping packages...

March 22, 2018 at 5:23 am

#1984241
RE: SQL Server Master Data Services not available in SQL Server 2016 Standard edition with SP1?

river1 - Thursday, March 22, 2018 5:12 AM
Thank you for the link.
It says only enterprise and dev editions support it.
But I have...

March 22, 2018 at 5:21 am

#1984240
RE: Column name gets change in source table SSIS issu

vipin_jha123 - Wednesday, March 21, 2018 11:11 AM
Hi All,
I am facing some serious issue with SSIS package.
In My project, I am...

March 21, 2018 at 11:15 am

#1984181
RE: Error message "Conversion failed when converting the varchar value 'SD8040' to data type int"

patelvoct - Wednesday, March 21, 2018 8:30 AM
Hi Lynn,
It works great without the where clause. I need to have where clause for...

March 21, 2018 at 8:36 am

#1984135
RE: SSISDB in SQL 2016

Davekahn - Wednesday, March 21, 2018 8:23 AM
We are migrating from 2008 to 2016 and developers are running packages from c: drive...

March 21, 2018 at 8:34 am

#1984133
RE: Error message "Conversion failed when converting the varchar value 'SD8040' to data type int"

patelvoct - Wednesday, March 21, 2018 6:54 AM
Hi All,
New to SQL server Management studio and trying to build basic query to extract...

March 21, 2018 at 6:58 am

#1984111
RE: Cursor Update issue

iseedeadpeople - Wednesday, March 21, 2018 6:24 AM
Hi guys i try to update 400 rows with cursor and when i try it...

March 21, 2018 at 6:28 am

#1984108
RE: Why aren't formatting tools working for me in SSMS 2017?

hans.johnson - Tuesday, March 20, 2018 10:34 AM
I'm a long time Data Developer and have been using SSMS quite heavily since 2005....

March 20, 2018 at 11:06 am

#1983999
RE: Spilt a record into 4

Angela4eva - Tuesday, March 20, 2018 10:21 AM
Guys,
have select statement
Select salesid, salesname, salesamount from salestable
ssalesid salesname salesamount
1 ...

March 20, 2018 at 11:02 am

#1983997
RE: SSIS Package Lookup Task - Is not adding the field to the data flow

Paul Giles-Randall - Tuesday, March 20, 2018 10:16 AM
I am in the process of migration data from an old, now unsupported application,...

March 20, 2018 at 10:20 am

#1983988
RE: Using the Name of a CASE STATEMENT later on in a CONCAT

jeffshelix - Tuesday, March 20, 2018 8:56 AM
I understand why i can't do this (using CONCAT with "MOT2". For the same reason...

March 20, 2018 at 9:17 am

#1983958
RE: The type of the value (Int32) being assigned to variable "User::dteNewMaxDate" differs from the current variable type (DateTime). Variables may not change type during execution. Variable types are strict, except for variables of type Object

kartikaya.singh - Tuesday, March 20, 2018 7:16 AM
Hi Phil,
Yes this is happening at the time of deployment.
Wow, that is unusual. Can you...

March 20, 2018 at 8:32 am

#1983936
RE: Setting up CDC

Kris-155042 - Tuesday, March 20, 2018 7:56 AM
Yes
OK, the 2016 Edition Comparison suggests that it should work with SP1 installed,...

March 20, 2018 at 8:31 am

#1983935

Viewing 15 posts - 4,561 through 4,575 (of 13,871 total)