I take it.. from your reply... that it is possible to put triggers on Instance level settings.. like Linked Servers, Job Log settings, ect... not sure how to do that,...

Thanks... our roles are simple, but that does save a bunch of key strokes.

Yep that is it. Thanks.

Thanks.. our web development team uses VSS, so maybe I can get connected long enough to do the install.

Thanks, I will download those and give them a test drive. Yep, I agree... tracking xml changes means that simple changes get flagged as a new version. But you then...

Hey Andy,

I wonder if I could talk you into writing an article about Log files. From this series we were just writing everything to the end of the log file....

Nice Article, Andy... thanks. You know the process you describe is the process you should go through to scope any project... not just DW! Look forward to reading more. Hey...

Andy,

I have a question about the operation and flow of records. Let's make the following change to your data.. Let's assume that the data coming in was using a super...

Ok, got lost, but I just realized you ment to go back and click SSIS then Logging then Details tab. (Advanced Log Configuration)

Why does the error log show the date/time twice?

OnError Script Task 4,{04e1dba6-4a2e-43cb-b9d6-f394c0692a3a},{9CB1DB86-1E0D-4B07-84EC-FEA89DBAAFAD},2/19/2013 4:31:50 PM,2/19/2013 4:31:50 PM,-1001,0x,Script Task 4 failed!

Andy,

I am just about done.... yea. Got a question, are you going to write a level 13 - Batching SSIS Packages? I can already see a good bit of improvement,...

Hey Andy,

I realy love this group of articles, but I would request you make a slight change to Step 8. Under the section "Copying and Disabling to Preserve Existing Work"...

Hello Andy,

Well I have made it to the 6th article in your series. Am I correct, that you could set six objects AND change the MaxConcurrentExecutables to 6. Then have...

I changed to PK, thanks. I will have to look back and see if he stated anything about using PK... I would not think that e-mail would be a PK,...

Andy,

Both tables are in SQL Server 2005.. different servers. However I did find a way to fix the problem...

In SSIS I went to Tools > Database Tools > Table and...