Alright! I have successfully made it through your tutorial and have learned much! Thank you for your initial handholding, I think I can actually build something in SSIS now!...

You are very correct on my trying to do it using SSMS instead of SSIS. I had just learned that you can view an existing SSIS package through SSMS by...

Thank you so much! 🙂

What version of AdventureWorks are you using? This example fails with AdventureWorks for SQL Server R2.

Person.Contact doesn't exist anymore, it's been broken into separate tables for EmailAddress, etc.

OK, I am fully confused. I created a "First_SSIS_Project" project, and now have an empty solution that looks like:

First_SSIS_Project

- Connections

...

Oops, just noticed a previous reply about the same thing.

However, in the link in your reply, it just takes me to Step One of the SSIS Stairway. I still...

Hello, could you tell me what you are referring to (under "Play Along at home") by "Open (or create) the SSIS project named My_First_SSIS_Project from SSIS Quickstart: Business Intelligence Development...

I can sorta barely make sense of that, but not a CF guy, so taking your word for how it communicates with the back end SQL server. 🙂

My statement was...

Oh wow!

I was just getting ready to say "Wait, WUT?" to your statement about being able to use more than 4000 characters in nvarchar(max). Somehow, I have always had it...

OK, maybe I shouldn't have used the term 'overloaded', as that has connotations that I did not mean to imply. I meant it more like they have stuck so many...

Seems a good example of how tired and overloaded SQL syntax has become.

SQL syntax has become too obtuse for what we need it to do these days. Need a more...