Ok, so I think what you want to do is after your truncate table step, add an activex script. After the table load, add a another activexscrip that will determine...

At which point are you truncating the table?

You really just need to implement a looping mechanism

get file

load file

get next file

repeat until no files remain

continue processing

Correct?

Gun Control, as stated by another...

This is a dangerous thing. Who is "we". If it's the government that's a bad idea....

A couple of options depending on your version of SQL to exclude microsoft objects.

In SQL 2005, there is a field called is_ms_shipped. It's a bit value. 1 means it's a...

CDC is new with SQL 2008. You may be able to implement a similar mechanism through triggers on...

I pulled in the scripts and hit an error on the disable cdc call from the scripts document referenced at the bottom of the article.

EXEC sys.sp_cdc_disable_table

@source_schema =...

Do you have a server administrator for your reporting services box?

The permissions you need is View Definition.

Click on properties

Click on security

Click the "Edit item Security" button

Click "New Role Assignment"

Enter...

The likely cause of ENCRYTPED is explained on a response on page 2.

Like the others said, you can export it, but you really want to do is keep a copy in a development environment and always make your changes there, test, and...

DDL Triggers are only available in 2005 and above.

Steven Mann (10/2/2008)

---

In my environment I have 20 databases that are constantly updated 24 hours a day. The application uses one user account so my question has two parts.

1....

You hate change my friend. How long did it take you before you used SSMS? LOL

Adam, As I said in my email, I think you need two passes at the data but one of which is an Exception process that may need manual intervention. John...

If you aren't using source control, I would look into it asap. It will prevent issues like this from occurring in the future. If your company does not have the...