Please explain what...

There is an alternative way of doing this - you might like to check to see whether it performs any better:

with maxJournal

as (

select ClientId

,JournalId = MIN(JournalId)

from Journal

group by ClientId

)

select *

from...

mrtrich99 (6/11/2013)

---

I have not. I just manually rename the...

sarah.cook (6/6/2013)

---

Hi,

I need to create an id from a nvarchar value that is repeatable, sort of like a checksum or a hash, except that it needs to be unique...

I would add an OUTPUT clause to your DELETE query. Have a look at the examples here.

No problem and thanks for posting back.

You could try something like this:

delete a

from TableA a

where exists ( select 1

...

Here is the code for a script task to check for the existence of c:\temp1. If it does not exist, it is created.

public void Main()

{

string folderCheck...

Hello

You will find that you will get a much better response if you take the time to post your sample data and desired results in the form of readily...

How does the NULL appear in the flat file? Presumably one of

,"",

,,

,NULL,

eylenh (6/11/2013)

---

about the StreamReaders : I inherited this project and apparently they are used here because the import is done using SqlBulkCopy which should be faster than a dataflow component...

The StreamReader.Close() command calls the Dispose() command, passing a value of true (the Using() construct does the same thing). I have tried calling Dispose() and while it executed successfully it...

homebrew01 (6/10/2013)

---

Good question .... not part of a solution that I know of .... (But I am part of the problem it seems

Do I need to save it as part...

Is your package part of a solution? You need to open the solution, not just the package.

The fact that the larger files do not have the problem suggests that this is a timing issue rather than a logic/coding issue.

You could try calling .Dispose() rather than .Close()....