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()....

Chris, reading this has made me feel queasy :sick: :hehe:

Something like this?

with msgTypes as (select distinct msgType from #t1)

select m.msgType, ADAM = a.MsgType, CDM = c.msgType

from msgTypes m

left join #T1 a on m.msgType = a.MsgType and a.Provider = 'ADAM'

left...

Do you know in advance what the column names will be? That is, does this have to be a dynamic query? The static version is easier to write ...