Alright,

I figured it out, this is the working version!!

@echo

IF EXIST "C:\myProject\fileDrop\*.csv" (

cd "C:\MypathToproject\Project\bin"

dtexec /f load.dtsx

cd "D:\MyAntPlace\bin"

ant -buildfile D:\MyAntPlace\config\myTest.xml

) ELSE (

echo file does not exist

EXIT

)

It's been a while since I wrote this.

But wanted to follow up and share what I got..

@echo

If Exist "C:\myProject\fileDrop\*.csv" (

cd "C:\MypathToproject\Project\bin"

dtexec /f load.dtsx

cd "D:\MyAntPlace\bin"

ant -buildfile D:\MyAntPlace\config\myTest.xml

) else (

echo file does...

Your question is not very clear.

Are you importing the records to a table?

What have you tried so far...?

If you want please elaborate, or take a look at this, it might...

Welcome,

If you are new to SSIS I would strongly suggest the book:

Professional SQL Server 2005 Integration Services, that should defiantly get you started.

You have to at least attempt to start...

Thanks for all your suggestions.

I ended up using the following command:

dtexec /f packageName.dtsx

...and that works great.

Oohhh, sorry for being such as spazz.

Thanks for clearing that up.

Where do I find this tutorial? And what is BOL?

I have googled this and searched on this site, but...

Thanks Jeff,

I really appreciate your persistence and help.

I understand what you are saying.

And I apologize for not being more clear.

My primary key is a true primary key in another system. Instead of truncating the table and...

As a matter of fact, I am fully capable of inserting new record, that actually are duplicates into this table.

I am not quite sure why you say I would not...

Mypk is supposed to be the primary key but this is not always the case.

This is an integration of multiple sources and ID is the true primary key.

But can not...

Thanks,

It was easier than I thought.

This is sort of what I did....

INSERT INTO DuplicateTable (id, lastname, firstname, Mypk, dateStamp)

SELECTid, lastname, firstname, Mypk, getDate()

FROMINPUT_RECORDS

WHEREMypk is not null

GROUP BY id, lastname, firstname,...