I would suggest looking into using a Foreach Loop Container. You can tie the collection to a particular folder, and if there are no files there, the loop would...

I'm studying for the BI exams now. I haven't taken the Dev tests, but I would suspect that the BI exams are more difficult. They cover some very...

I got mine (Gmail).

Of course, you could always move to a remote ranch and start your own SQL Server community website... 😉

Yes, that can be done and is quite helpful for doing data type changes en masse. However, because the Name characteristic is unique it must be done on a...

Thanks Mike, that will probably speed things up. I'm still fishing around to see if there is a shortcut to take me to the next column definition without leaving...

The book I used was SQL Server 2005 Implementation and Maintenace by Microsoft Press. It touched on all of the required exam topics, and included a large section on...

Use caution when deciding to use the SQL Variant data type. It's one of those things that can be easy to implement but may come back to bite you...

Not that it will help you now, but SQL Server 2008 will reportedly have a DATE data type for this very purpose.

I don't think so, but I've got to ask... why would you want to?

Tim

You can pause the execution by firing off a popup window from within a script task by calling MsgBox("some message here"). However, if you try to do this on...

Max, you didn't specify but I assume that you are using the Execute Task item to run this executable? If so, you should be able to put the entire...

Do you receive any errors or are the intended changes simply discarded? What type of T-SQL statement are you running inside the loop? Is there perchance an open...

This is set at the report level in the report designer in BIDS. Open the report you want to auto refresh and open the Properties window. the AutoRefresh...

If you change an upstream file source (structure, data type, etc.), your downstream components will likely require need new metadata. Double-click each of the components downstream from the one...