Brandie Tarvin (8/25/2010)

---

Alvin Ramard (8/25/2010)

---

OP was complaining about PK violation while uploading text file using SSIS.

Someone replied with:

How do you get a PK violation?

Are you inserting the PK values yourself?...

OP was complaining about PK violation while uploading text file using SSIS.

Someone replied with:

How do you get a PK violation?

Are you inserting the PK values yourself?

Please remind me,...

Send her by...

I don't see anything wrong.

Try this:

1 - Add a new For Each Loop to the package and configure it to read the same files. (DO NOT use copy...

Ross McMicken (8/25/2010)

---

Jack Corbett (8/23/2010)

---

Steve Jones - Editor (8/23/2010)

---

I saw that from Brent. Paul is garnering lots of respect from the other gurus.

We need to get Paul out here in...

Question for the User Group leaders on here:

Have any of you tried to export the list of members from the new and improved (and possibly sucks more than before) UserGroupSupportServices...

Traverse sub folders has no affect on the root folder.

Greg Edwards-268690 (8/25/2010)

---

Alvin Ramard (8/24/2010)

---

Yep.

I'm clueless...

I guess that 6 tables would be one hex of a join. 😎

I'm afraid that there's not much more I can do without seeing the what the package/loop looks like.

I think I see your problem. It looks like you do not have a proper "search string" for your ForEach container.

Open up the ForEach Editor and look at the...

Yep.

I'm clueless about what kind of...

anavill (8/24/2010)

---

Sorry it was a typo , I wanted to say Overwrite option NOT checked", so it is APPENDÏNG data to the file.

I already tried adding in the VB code...

J.D. Gonzalez (8/24/2010)

---

Alvin Ramard (8/24/2010)

---

Then you might try to add a VB (or C#) Script Task a the first task to execute in the For Each container. Pass the...

First, double check that both files match the wildcard that you entered in the "Files:" box.

Then you might try to add a VB (or C#) Script Task a the first...