I would pay money to see the look on my own face if I heard any of that stuff come out of anybody's mouth in an SSIS discusion. Priceless....

That one will go down as one of the best threads ever. One could only hope the OP memorized the answers actually uses them in...

Crapwand

Ah, now I see. You cannot use an IF construct with an INSERT statement. Look in BOL for INSERT; it must be INSERT INTO....VALUES or INSERT INTO.....SELECT.

The syntax looks fine to me. You are using variables in your SQL, did you declare them first?

It sounds to me like the problem is not the SSIS packge, but transferring data over the WAN. You mentioned that the packge was very fast when used over...

Tom.Thomson (4/6/2010)

---

John Rowan (4/6/2010)

---

This was actually SS2000 EM and my meaning is that he was completely unaware of how to use the GUI to backup a database. Not that...

This was actually SS2000 EM and my meaning is that he was completely unaware of how to use the GUI to backup a database. Not that I'm that proficient...

For the record, no certs or degrees here. The only people that I've run accross that have certs and actually know what they are talking about is out here...

I'm with Elliot here, we need more info on what you've already done. In addition to what Elliot has asked for, can you give us an explanation of how...

Bill, your explanation of how app locks work is accurate. App locks do nothing more than allow you to micro-manage an application 'resource' using SQL Server's locking memory space....

Here comes the Son! Have a Happy Easter weekend everyone!

No problem.

Yea, that may work. If you set up a DB on your SSIS server to use for this. You could also do this in 2 data flows. ...

SQL Server 2000 will not support ROW_NUMBER(). Is your destination a SS2005 box?