I do not understand...

If you used an OLE DB connection manager, use an OLE DB Destination for the Excel sheet. Not the Excel Destination.

The table or view name will be your sheet name.

The easiest way to check for the file is to embed your FTP task in a ForEach container that looks for the file. If the file doesn't exist, the container...

Please give us more information on the connection manager which points to your flat files.

Also, does the flat file have any header rows or titles?

If you don't need dynamic destinations (like the above post points you to), just create an OLE DB Connection Manager for your Excel sheet using the Jet 4.0 connection and...

How's this for a motivational poster?

http://icanhascheezburger.com/2010/09/27/funny-pictures-teamwork-pandas/%5B/url%5D

Okay, so is the dynamically generated table a temp table or a "real" table?

You shouldn't have to use OpenDataSource in SSIS. I've been able to direct "traffic" to specific worksheets...

Chris Morris-439714 (9/28/2010)

---

Brandie Tarvin (9/27/2010)

---

Kit G (9/27/2010)

---

The part makes my head hurt is the joining the table to itself. Know of any articles about that which might help make...

The worst thing a DBA can be told is "not all...

GilaMonster (9/28/2010)

---

Stefan Krzywicki (9/27/2010)

---

GilaMonster (9/27/2010)

---

Tom.Thomson (9/27/2010)

---

Sturgeon got it wrong. He should have said 95%. At least of the developers I have interviewed I regard 95% as unemployable in...

Have you looked into DDL triggers yet?

You can use them to rollback transactions (in this case for INSERT statements). The only caveat is that I can't remember whether they...

Deadline

It's not a domain issue. This was entirely local to the server. See my last post.

You're posting in the wrong forum group. This is the 2005 group and your BOL reference refers to 2008. Try posting there.

It sounds like your user is possibly confused. But here's a quick Replication primer that might help you speak to him about his needs.

In every version of replication (Merge, Transactional,...