Please do some Internet searches to get this basic information and then come back here with any specific questions....

I'm tied up with something else for a while, so cannot try your suggestion Koen, but just responding to a couple of the points:

1) Even though those config file messages...

Thanks for the quick response - this is SSIS 2005.

Here is my command line, edited slightly to protect the innocent:

/FILE "T:\SSIS\Packages\abcde\bin\abcde - ERD.dtsx" /CONFIGFILE "T:\SSIS\ConfigFiles\Common\SMTP.dtsConfig" /CONFIGFILE "T:\SSIS\Packages\abcde\Config\Custom - ERD.dtsConfig"...

sanvekar (5/24/2011)

---

First You can Create a data flow Task.(DFT)

In DFT Add task "Flat File Source" and point it to your input text file.

After that Add a task...

Use a table.

..and all occurrences of occurance with occurrence 😀

Ah yes, seen that one many times - well done on figuring out the answer. As the flow can go down either (but not both) paths, each of those constraints...

I agree - a jpg image of the package control flow screen might be helpful.

One possibility I thought of was...

That's pretty cool, thank you.

Same link as mine;-)

Have a look here[/url] - I'm sure you can adapt it to your needs.

What do you want to happen?

1) Do you want to delete all the rows and re-load them? If yes, just truncate the destination table before doing the load.

2) Or not...

nikishh9 (5/19/2011)

---

Hi All,

i load the data from Staging database to Poststaging but when run package two time at that time i got same rows two time or if i run...

Can you give some background on what you are doing - what method are you using to run DTEXEC?