Your blog describes data validation on data types,...

Oh yeah, I forgot: SSIS does play nicely with temp tables, you just need to use the RetainSameConnection property I mentioned earlier.

You can mimic a transaction in SSIS by using an Execute SQL task at the beginning of your package with the command BEGIN TRAN.

At the end of the control flow,...

I don't think there's built-in capacity for that, so you'll probably have to resort to a script task for that.

What happens if you change the ODBC connection to SQL Server to an OLE DB connection?

Why exactly would you want to do that?

What if I spend some of my time researching this topic and typing in...

What is the datatype of the source?

What is the datatype of the destination?

Also, be aware that using the conversion component doesn't actually convert the column, it rather makes a copy...

It would suprise me that right-clicking on a task and selecting "Execute Task" would also start other tasks.

And here's a link: http://msdn.microsoft.com/en-us/library/ms167456.aspx

You have two options:

1. You have only one time dimension, but with different attributes that describe the "various possibilities." If needed, you can use role-playing dimensions to split that singe...

Thanks for the article, I learned something new.

Nice question, thanks.

Nice question, thanks.

Nice question, thanks.