We are now just evaluating its use in our shop. We would not have big data to work with though.

Thanks...Chris

Thanks, Tom.

OK...so just logistics...I was just thinking of someone (other than you who gets BETA exam invites) just sitting the MCITP, without sitting the MCTS. Thanks for the quick reply.

-...

Hmmm...that's interesting, Gail. What would be the point of that scenario -- sitting the MCITP before the MCTS? Just to test your knowledge?

Thanks...Chris

Thanks, guys.

Thanks, SteveB.

Ensure that you have declared the variable at the correct scope...not just within the ExecuteSQL task, but at the package level.

Hope that this helps.

Thanks,

Chris

No worries on the delay, Scott. I understand how it can be with the deluge of e-mails.

The behavior that you mentioned, not having the ability to use a command-line...

As far as exporting to XML, that is fairly easy. Look at Books Online at the FOR XML clause.

With regard to importing an XML file, you can use a...

Thanks for the post. I've attended one of the SQL Saturdays, as well (in Columbia, SC in early 2011). It was a great experience! There is one...

I do not think that you would want new rows. Adding a new column to hold the sum YTD would suffice. Search the forum for rolling sum posts....

A few options:

1. At the beginning of the processing of a file, enter it into a database table. At the end of processing, set a flag, as you suggested,...

Hi, Craig. I know that suggested practice is using environment variables, but that is not an option right now. It would be hard for me to convince the...

Hi, Stefan. I want to over-ride the configuration because I am deploying the SSIS package in a different environment (moving from DEV to QA, QA to STG, etc.).

Thanks...Chris

I'm sorry...I don't know why I can't get clarity on this situation, but I guess I am not understanding the following statement correctly.

"...After the utility applies the run-time options, the...