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'

...

Those additional spaces seem to have been collapsed/removed somehow.

Are you questioning the results of the following?

if 'Diane Watson' = 'Diane Watson'

select 'Matched'

else

select 'No...

That's pretty much...

Actual rows and Est rows are very different. Are your statistics up to date?

We really need to see the DDL for the table and its indexes.

Also, can you explain what you mean by this:

..which results on half the table for first part of...

Perhaps you can run some SQL after the transfer to set the job statuses?

Vertigo44 (3/23/2015)

---

My Source connection was set to look for 5 columns with the last column delimiter expecting a CR/LF. However, our vendor continues to add additional columns to the flat...