YouTube Connection

Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.

Step 2. From drop-down menu Configuration select YouTube. Click New in the Token File parameter to create a new token file.

Step 3: Modify the requested application Scope or leave the default.

Step 4: Provide Username and Password

Step 5: Click 'Allow' button to authorize access to your YouTube account.

Step 6: Save generated access token to file. Specify token protection password. Click OK.

Step 7. Click "Test Connection" to test your connection.

Congratulations! You have now established a connection to your YouTube instance.

Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".

Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.

Step 3. Double click on the "REST Source" component and select YouTube connection from the combo. Select from available YouTube resources listed in the second combo below.

Optionally you can include extra parameters in the grid below if needed.

Step 4. Click on the "Columns tab" and select YouTube resource columns you want to read.

Step 5. Click Preview to make sure all necessary resource columns are included.

Bravo! You have now learned how to read data from YouTube service.

Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".

Step 2. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.

Step 3. Double click on the "REST Destination" component and select YouTube connection from the combo. Also, select resource action and YouTube resource you want to work on.

Step 4. Click on the "Mapping" tab and map the input columns for the process you are configuring.

If you want to provide input for other resource composite objects, change the input above and map the columns.

Done. You have now learned how to write data into the YouTube resource.

Step 1. You have to provide input for the following required columns:

• snippet.title - The video's title.
• snippet.description - The video's description.
• snippet.tags - A list of keyword tags associated with the video.
• snippet.categoryId - The YouTube video category associated with the video.
• status.privacyStatus - The video's privacy status. Valid values: private, public, unlisted
• content - the video file content. Use the standard "Import Column" transformation to load the file content into a data flow column. Here you can find one reference how to configure the "Import Column" transformation.

Step 2. Set the YouTube connection.
Step 3. Set the resource to "Video".
Step 4. Set the action to Create.
Step 5. Set batch size to 1.

Step 6. Click on the "Mapping" tab and connect the required input columns.