Personally, I like running the following, and adding the specific table name in the where clause if I need it.

Note the (nolock) on the tables. If you are importing large...

I personally LOVE using the XML format. One thing that I found cumbersome however, is viewing the XML. If you right click on the .dtsConfig file, choose to open it...

I disagree that it is easier to send mail from inside a script task.

I use a script task to set addresses, conditionally attach multiple files, modify the content of the...

Wow, that is a lot of work. I've been using multi-value parameters for a while now. I created a split function on the SQL Server that I use for every...

Same here, have many in each compatibility mode, no issues. 😎

I agree completely. I don't have anything against those companies, but I don't want to work there. I have no desire to go into management, and want to be comfortable...

I don't think so. I did quite a bit of research on timed subscription exporting to excel, because my users LOVE excel. It is also not possible to rename tabs...