PaulB (7/28/2009)

---

Tables are partitioned for just two possible reasons: 1) To help during purging and/or, 2) To help during quering.

If a partitioning strategy does not matches at least one of...

Is this import the only way data is getting inserted into your DB? How long does it take to import your 400,000 rows?

A couple questions for you:

1. Does your table have a clustered index on it? If so, what column/datatype?

2. Why load the data twice, once into a staging table, once...

How do you know the loop is looping w/o doing anything? How can you be sure it is not just stuck in one spot waiting on something? Have...

What all are you doing inside of your loop container?

Query 1 is using an equality comparison which does not allow for the wildcard characater %. Query 2 is eliminating those rows because of the LIKE comparison operator. ...

Just so you know, it looks like your post got cut off mid-sentence.

Jeff Moden (7/22/2009)

Heh... and now we know why I don't even bother with SSIS (or DTS). THAT's supposed to be easier and faster than a nice little ol' BULK...

I agree with the others in that it may be difficult in a shop that small. I also agree with George in that the DBA to developer roles/responsibilities must...

I've not used the FTP task, but you may consider setting up your FTPs to be run by an Exectue Process task. The Execute Process Task allows you to...

Ah, so you only do the comparison if the row already exists? Is this the correct logical flow:

1. Check for Existance of row

2. If not exist, insert.

3. If exist,...

I'm not sure if it would be displayed anywhere when used via a maintenance plan. Maybe if your plan is set up to log the results to a file,...

Keep in mind that the data and log file physical path/names are stored in the backup header so you need to make sure your restore is moving the files to...

Like Gail said, look up ALTER TABLE in BOL. You don't need to use the Script as Alter feature if you know how to write an ALTER TABLE statement.

Where is the backup from, another server? How are you doing the restore, SSMS or script? What are you trying to do, restore a Production DB, create a...