Yes, Jason's right, I tried it, was getting the same error.

Better for you, if you test the script before posting..

I know doing it manually is not possible every day. Try the suggestion given earlier, does that help?

This is not the solution, but something to start with.

In the DataFlow task, select the OLE DB source, Right click and choose edit choose error output and there you have...

I'm not in front of BIDS, but I can remember that in the DataFlow task, select the OLE DB source, Right click and choose edit choose error output and there...

Good work Greg !

I spent sometime last evening in solving the issue, but could not move forward after a certain point.

You are Welcome !

Well a first look at the article properties does not show if there is something to change the column names as well. All I can do...

As I have mentioned earlier, you don't need to be panicked just by the # of rows reaching 10 Million after 18 months.

We have multiple tables having something around 300...

Go to the Publication, and choose properties and change the destination object name.

Find the attachment for the screenshot.

Does that help?

Yes you can install SSIS/SSRS/SSAS in Developer Edition and all features are supported.

If yes, could anyone show me where to...

Going by the # of rows, (5 Million a Year) is not something to worry about.

What Apurva has suggested would be my suggestion, use database partitioning and have proper indexes...

Does the group Mydomin\QA_Group has SQL Permissions assigned? Check in Security node in Object Explorer.

Not sure this would solve, trying to help..

You are Welcome !

Trooper09 (12/16/2009)

---

How can the applications be tested after applying a service pack on sql server 2005? We have few access applications and was wondering what needs to be tested and...

To get cleared of that confusion, set up a test system and try creating couple of snapshots, and...

May I suggest you go to this link

View SQL Server Error Logs through T-SQL code

Use the code mentioned there.