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.

 

<—Introduction   Change data capture –>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s