krypto69 (6/1/2012)

---

Yes there are no aggregates...

Hmm...

So I'm not sure how to proceed now.

What I really need is everything grouped by year first, then company code, then branch code. But retaining...

It's not totally...

Or maybe this:

SELECT

CmpCompanyCode,

cmpCompanyName,

E.eecCoID,

E.EecEEID, --unique number stays with person, if listed more then once

E.EecOrgLvl2,

E.eecDateOfLastHire,

E.eecDateOfTermination,

E.eecEmplStatus,

E.eecEmpNo,

E.eecLocation,

E.eecFullTimeorPartTime,

E.eecJobCode,

eepNameLast,

eepNameSuffix,

eepNameFirst,

EepNameMiddle

FROM EmpPers JOIN EmpComp E...

I think your problem may be that you are trying to run a batch file on a remote computer - and that just doesn't work, as the batch file always...

Apart from the fact that

MsgBox(DateString).ToString()

looks weird (use MsgBox(DateString) instead), I can't see a problem. But if you post the full text of the error message (just copy & paste), it...

Please post the exact text of the error message.

Consider using a file watcher task with a timeout of 1 hour.

You can configure the task such that a timeout results in a warning or an error.

Use the File System Task & take the copy option.

If you see i have duplicate records in All FIELD and also most seriously Duplicate records between two or more columns....

DISTINCT is not working in my case,here is my code...

What sort of macro?

Koen Verbeeck (5/16/2012)

---

Indeed a strange problem.

Uncached lookups are of course very slow, but I don't really see a reason why the package should hang.

Did you try a cache connection?

How is...

khorkh888 (5/15/2012)

---

Hey All Expertises,

I am facing problem to load a batch of text in Excel into sql table using SSIS. Here is in Excel look like:

Date KPI...

You didn't mention the 'c' word...

Really? Did not know that - thanks for sharing.

Not that I know of.

But there are a couple of things you can do.

1) Find a decent text viewer that will open big files quickly and allow you to navigate...