Sorry to hear you're not involved with Apress anymore. I like their stuff and have always liked your stuff. Did I understand correctly, though, that you are involved in teaching/writing about SSIS?

I know what you mean about the wizard. I am already at that stage - hence trying to figure out what the wizard was going to do in the final dtsx. Really like the integration with VS. Playing with dataviewers now.

I had done a bit with DTS previously, but your comments about how far the tool had come inspired me to take a fresh look at SSIS and I thank you for that as this is going to be a big part of my development world from here on.


>Hi...yes, correct, you'd use the Execute SQL Task on the Control flow to truncate a table first.
>
>SSIS is such an awesome tool....however, the learning curve is in figuring how all the spots where you can "hook" in your code. To date, there's little I haven't been able to do in SSIS....though sometimes it's required a bit of elbow grease. The scripting model in 2008 is better than 2005.
>
>The book you mentioned is good...the most complicated example in the book was maybe still a bit simpler than I expected, given some of Brian Knight's other works...but still, it's a good place to start.
>
>MS re-wrote the pipeline model in 2008, which means things that were discouraged in 2005 are now possible.
>
>Now...most people use the wizard at the very very beginning, which is fine for getting started. Ultimately, you'll find yourself going right into the package.
>
>I'm no longer involved in any Apress books.