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

KoldCoffee (6/5/2013)

---

The field remains red. The field goes black if it is parsing. Well folks, it appears that, none of the regulars on this forum know how to write SSIS...

I don't like it either, but can't see any way of turning it off.

I know it's a bit OTT, but I've actually written a program to automate certain 'tweaks' to...

No problem & post back with any specific questions about the implementation. It takes a while to get to grips with the SSIS way of doing things.