Good article, and very good idea about planning ahead. This methodology takes more work to set up, but can save you hours or even days of work in a...

How is your source data formatted? Is it Unicode or ASCII?

The filter option works, but it's only static for a single session. When you close and reopen SSMS, the filter is gone.

I'm with you on this one. I've long wished for a way to group objects in SSMS by name, category, etc. Databases with hundreds or even thousands of...

Must be finals week :w00t:

You could take a peek at the underlying XML, since a .dtsx file is just XML under the covers. However, it's not exactly user friendly - open it up...

Glad it's working, thanks for the update.

Thanks for the tension breaker.

Good post. A very creative and useful implementation of DDL triggers.

Is this other staff member getting this error when he tries to save any change in the package? If so, it may be a filesystem permission issue. Check...

What error are you seeing?

I was discussing a similar topic with someone else earlier this week:

http://www.sqlservercentral.com/Forums/Topic720042-148-1.aspx

We were discussing the use of multiple data flows vs. a single data flow, but some of the same...

If you're in an Active Directory environment, you may need to join the VMs to your domain.

There are some client side components that must be installed properly and running - perhaps these are either not installed or not running on the target machines. Check the...

Like most questions database related, it depends. There is a blend for every situation, and that blend will depend on the amount of data involved, the resource intensity of...