Gary Varga (3/27/2015)

---

dwain.c (3/26/2015)

---

-- Whilst I'm a consultant named Jack

-- I swear that I'll never be back

-- Removing this code

-- Causes server overload

-- Despite you're thinking its a hack.

See what...

vipin_jha123 (3/26/2015)

---

Hi ,

I am working on SSIS package where I have to implement logging for records count.

In my package I have 20 Data Flow Task, now my requirement is to...

It's been that sort of a day here too. I'm going for a cleansing ale to...

It's a really cool way of managing config settings in SSIS 2012+. Including sensitive data, like...

Drenlin (3/26/2015)

---

Phil Parkin (3/26/2015)That's exactly what the compatibility level is for, though it does come with downsides: all of the new features in 2014 are turned off for the databases...

Have a read through of this[/url] Stairway article and see whether you can begin to get to grips with the use of SSISDB environments, then feel free to post back.

Are you using Don't Save Sensitive as the package isolation level and then passing the password to the package as a 'sensitive' SSISDB environment parameter?

If not, try that.

wendy elizabeth (3/26/2015)

---

In t-sql 2012 there is the coalesce statement being used twice in a where clause. I do not understand what the where clause is doing. Thus can you...

Drenlin (3/26/2015)

---

I am late to this discussion but reading with interest. I also see there is no answer/solution yet.

From the description it sounds similar to what we are experiencing...

The error message suggests that the problem is with the output, not the input.

What is the column width, in the output file spec, for column 'My Column'?

Here's an example:

declare @FileList table

(

SubDir varchar(500)

,Depth int

,IsFile int

);

insert @FileList

(SubDir

...

For example:

create function internal.get_execution_perf_counters

(

@execution_id bigint

,@execution_guid uniqueidentifier

)

returns table

(

execution_id bigint null

,counter_name nvarchar(128) null

,counter_value bigint...

dwain.c (3/26/2015)

---

Gary Varga (3/26/2015)

---

dwain.c (3/25/2015)

---

...I beginning to think that when I wrote this article (based on a quotation from Jeff):

Make it Work, Make it Fast, Make it Pretty[/url]

Maybe I should...

If Provider_Id is an IDENTITY column and you want to generate new values in it, try un-setting 'Insert Identity values'.

This setting is used where you want to override the...

Hmm. What about this?

declare @Name varchar(50) = 'Diane Watson';

select Name = @Name, Result = case when @Name = 'Diane Watson' then 'One Space'

...