What you need to do next is add a data flow task to the control Flow. Data flow should be in the Toolbox. Add that, double-click the icon,...

Yes, that's what I was looking for, but couldn't find it because I was looking in BOL under "Table" instead of "Database".

And in BOL 2000, they actually list "statement" as...

You can also use the COALESCE() function to pull everything together.

Declare @cols varchar(4000);

Select @cols = COALESCE(@cols + ', ' + MyColName, MyColName)

from MyTable Order by MyDate;

Select @cols;

The order by...

You want scary documentation?

Google "SA Account" or "SA Account best practices". This should come up with plenty. Especially since so many worms & viruses use the SA account...

And then there are global temp tables that start with 2 pound signs (##d). These tables are available to any connection using the database so long as there are...

You're also going to have to create your destination data source before you do anything. Once you've done that, add a Data Flow Task to the Control Flow. ...

You know, it occurs to me to add a few more replies to the original post.

RE Q#2) Yes & no. If you're new to SQL 2k5 or haven't used...

The only way that kind of lazy works IRL is if you have a boss that doesn't care if you can actually adminster or develop on SQL Server and allows...

I'm glad someone found them useful. @=)

Thanks for the response, Steve. I'll just use the general search again, then.

As far as question # 1 goes, make sure you download the errata for the book (regardless of version) before studying. Every version of the book has its...

FORFILES?

I haven't heard of that command. It works in the command shell?

To address the original question (though xp_cmdshell can be a major security hole)...

-- This code removes the previous day's backup from this folder

--BIG NOTE: This code is dependent on the...

Well, I updated my Batch size and Max Commit to 10000 and set my sources as queries. Started the run about 1 & 1/2 hours ago and already I...

I am filtering in the source by Deselecting all the columns. DIdn't think about the effect that would have... I should probably change that to a query instead.

I did...