two ways of improving your ETL with SQL 2012 #2 – Project deployment

How did you deploy SSIS packages earlier? Well, I went into the project properties, and create a deploymentutility, and then I ran it. I had to do a lot of work.

Now I

  1. setup a SSIS catalog in SQL Server Management Studio.
  2. Right click in Data Tools (Visual studio) and deploy.

Let’s see how that is done in SQL Server 2012. Please don’t mind the quality of the video. I have a son that are sick today, so I had to do a lot of breaks.

[youtube=http://www.youtube.com/watch?v=SsjEftMLswU&w=448&h=252&hd=1]

 

<—Introduction   Change data capture –>

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *