Never figured out how to get it to work. I'm doing my MCSE for business intelligence, so I'm sure I'll figure it out some day.

Yup, I actually tried out the default values script and it works awesome. No settings, just sraight insert statements.

Thanks for the input. Hopefully someone else gained additional understanding as well.

Later,

Sweet!

Excellent article. I must admit that I was extreemly skeptical at first as I am used to writing catch all phrases in my code which I thought was so clever...

Right, there is no FROM FROM.

Just wanted to bounce that off of somebody.

The practice exam is full of weird little errors like that.

Thanks 😀

I could absolutely see how using multiple instances of SQL server would improve performance if say most of the tables in one instance were being read and the other instance...

That sounds like quite a job. 500,000 records in one day is no small order of information to deal with.

It would pobably help if you provided a general breakdown of...

Great test. I'm flattered that you took the time to check this out. It's just the kind of information I need to either push the replication concept or show them...

That was great. I'm preparing for the 70-433 ms sql 2008 exam and the whole time I'm thinking, "Huh, I know the book leaves out details here and there, but...

Any luck getting that to work. I'm about to attempt something almost identical and would like to know how it turned out. Currently, the only idea has been to forward...

I'm curious to see how your project went. I'm starting on something relatively similar shortly and cannot find any information on what's been attempted.

You are awesome... Gold Star!

Later,

😀

That's the thing. I select the Edit the Command Line radio button, click OK to confirm changes and next time I go back to edit the step, it's reset to...

I appreciate the primer on the terminology, it is an alphabet soup sometimes. As you can see from the screenshot, I am running an SSIS package inside SQL Server Agent....

You're probably confused because I created a confusing post. 😀

The purpose: Run an SSIS package on a nightly basis.

The package: Handles processes like XML file creation on a remote server,...