If you know your header and footer will always be the same size and never the same as any of the detail, you can use the conditional split. This could...

No such luck... SSIS will run all tasks which do not have any preceding tasks first. You would have to build your own logic into handle this.

nooooooooooooooooooooo Do not use the OLE DB component for inserts.

It'll be a dog. SQL is set based. Rbar (Pronounced ReeBar) is Row By Agonising Row.

The OLE Source and OLE Component...

What have you tried so far? The data flow task and excel destination will do it for you.

What pray tell is the syntax error?

To be honest, I don't think you can. I seem to remember doing it through script, not SQL. I may be wrong though.

Not the w rong way. What were the errors????

You can execute a ssis package with CLR. dtxec.exe. Invoke it in VB.

Use a proc for the update. Advantages are plan cache, cleaner oh, and it shows you the param name. Not Param0 etc. Will show you MyParamName 🙂 But mostly for...

Well, in your lookup you are obviously mapping on the key. So you have the correct values in the source (else it would be deemed missing and become an insert)

So,...

Matt Miller (1/30/2008)

---

I'm not sure I understand why you say lookup wouldn't work with a text source (or a text reference). Albeit slower thanks to the lack of indexing,...

Your syntax is correct. Use the OLE DB component.

Rather than redirecting the not found rows, rather ignore them and use a conditional split. It's a cleaner option.

For the problem above, you could not use the lookup as the source for the lookup is a text file.

A tip on the sort and cleaning: Do what you...

Nope - pretty much bang on. Use the join, with sorted inputs, and left outer it.

For the inverse, you can use a lookup component.

To open an old can of worms,...

Don't think that has anythign to do with the lookup. Can you execute the lookup statement from SQL when connected tot he same DB as the lookup connection?

Firstly, it's a SSIS package, not DTS. SSIS is to DTS what SQL 2005 is to Access.

Rule 101 of anything: Never hard-code anything parameters.

You could get the environmental variable...

It's a "feature" of bids. Worst is tasks inside containers. Most times, the green lines totally vanish. You have to "nudge" a task to get the lines back.

Also. when you...