Look up FOR XML in Books Online.

A domain move is pretty easy. The Windows authentication users and service accounts are the only real problem. You may want to drop the logins first, they can...

What are the data types of HandleID and ID?

Querying the database directly is not a good idea. Use the web services made public through the report server. MS may (and does) change the database structure you...

To run an SSIS package, the machine needs to be an SSIS Server. Which also means you would need to buy a SQL Server license for every laptop. ...

I have a "travel" laptop. It's basically a dumb terminal and I can rdp into machines on my home network and into my workstation at work.

So, I could basically...

The UNION ALL is probably the best solution. You may also be able to simply set the "RetainSameConnection" property on the file connection manager to True.

If that is the behavior you really want, how about creating a persisted computed column concatenating the make and model together and create a fulltext index on that? I...

Not really well. Bad data like this is a problem with most parsing software.

If you only have one field that the problem can happen in, you are not in...

You could use a ForEach and a script component. In the script component, you could include the logic to determine which variable to put each row into.

It may be...

Look for some information on the ForEach component. In the available enumerators, there is a ForEach File enumerator that you just point at a directory. It will loop...

A data type error happens in SSIS - because your data does not match the destination definition. The NULL is failing due to a database constraint - which happens...

Yes, you are misunderstanding the UNION ALL entirely.

I would suggest you take a look at Books Online or pick up an SSIS book before you get into anything complicated. ...

This is an area that MSSQL Server is pretty lacking. It would be nice to have something built in, but even using VSS, differencing anythng is pretty ugly.

I like...

If you are going to use a UNION ALL, it would go after the MULTICAST so you only need a single Destination component.

None of the components you are using should...