Does the Excel file already exist? I think it needs to. Stick with CSV if you can and save yourself a few headaches 🙂

opc.three (6/5/2012)

---

I do not think you can delete Excel data using an OLE DB connection but I read you can use the DROP TABLE followed by CREATE TABLE syntax to...

Please answer my other questions and justify the use of SSIS.

Nidhi G (6/5/2012)

---

Hi,

I need to create a package in SSIS 2008 for the following task:

I have a database name OMB. In that database i have different schemas like bau,ssi,stg etc..

I...

May I ask why you are not using a fixed-width flat file source connection in SSIS - that will do all of the splitting for you?

To answer your question...

Presumably you keep the files? If so, you can check for yourself, surely?

Or are you saying that the files themselves are fine and that the errors are occuring elsewhere in...

hamsa_apj (6/5/2012)

---

Thanks for your response.

Its is fixed length file and am splitting the data using subString(), to map the data from .dat file to database table columns. Since position of...

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.