Channel Title: Learn SSIS Channel Description: By learn SSIS channel we will learn how to use SSIS for ETL purpose. SQL Server Integration Services is an ETL tool provided by Microsoft for ETL purpose. ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. If we want to load data from flat file or from excel file to SQL Server then we need some ETL tool like SSIS for this purpose. This channel Learn SSIS is aimed at providing professionals with knowledge on SQL Server Integration Services. If you regularly see videos in this channel, you will be able to • Design and Understand the SSIS Solutions • Import and Export Data from and to different Sources • Create, manage and maintain SSIS Packages • Import and Export Data from and to different Sources using SSIS • Use different Transformations to change the data on the fly You can contact me on aqil33@gmail.com <video> How to convert JSON file to Excel file Description: convert json file to excel Download files: https://drive.google.com/drive/folders/1XBFQ47FQmmzUfFNLxQnMngipskgxqjtz convert json file to excel How do I convert a JSON file to Excel? How to JSON file open in Excel? Online JSON to EXCEL Converter https://jsonviewer.stack.hu/ If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> How to migrate data from SnowFlake to SQL Server using SSIS Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components. https://drive.google.com/drive/folders/18-zJbeab4iIh3ISLedB0rqNV_S0wNM6x In this video, I will show you how to migrate data from Snowflake to SQL Server using Devart SSIS Data Flow components. This tutorial covers all the necessary steps to ensure a smooth data migration process without complicated coding. I demonstrate the entire process of migrating data between Snowflake and SQL Server. Timestamps: 0:00 Introduction 1:22 Snowflake overview 4:53 Migrating data from Snowflake to SQL Server 5:48 Connection to Snowflake from SSIS 8:33 Making data migration task 9:53 Testing the results 10:34 Migrating data from SQL Server to Snowflake 🔥 You can download SSIS Data Flow Components for Snowflake Trial here: https://www.devart.com/ssis/snowflake/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-snowflake 💰 You can compare pricing options of SSIS Data Flow Components for Snowflake here: https://www.devart.com/ssis/snowflake/ordering.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-snowflake 👉 Check full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-snowflake Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video> <video> 162 How to get the record count of a file in SSIS Description: How to get the record count of a file in SSIS Download files and scripts: https://drive.google.com/drive/folders/1BrgVGFDLP1YniUrYjG25-6mGVKAH_ixz SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF--8vjjEVEXMf2hEFn0D5tEJV9kRqi SSIS real time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 How to get the record count of a file in SSIS How to get the record count of a file in C# how to get row count in .csv file in c# Happy Learning. If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> How to convert CSV file to Excel file Description: convert csv file to excel convert csv file to excel How to convert CSV file to Excel spreadsheet? How do I open a CSV file in Excel? How do I open a CSV file with a comma in Excel? If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> How to migrate data from Amazon Redshift to Oracle using SSIS Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components https://www.devart.com/ssis/universal-bundle/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-redshift-oracle In this video, I’ll guide you through migrating data from Amazon Redshift to Oracle using Devart SSIS Data Flow Components. This tutorial walks you through each essential step to ensure a smooth and seamless migration, all without complex coding. You'll see the complete process of transferring data from Amazon Redshift to Oracle and from Oracle to MySQL. Timestamps: 0:00 Introduction 2:44 Set up Amazon Redshift source 6:11 Set up Oracle destination 9:15 Running and checking SSIS project 9:40 Migration data from Oracle to MySQL 🔥 You can download a trial of SSIS Data Flow Components here: https://www.devart.com/ssis/universal-bundle/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-redshift-oracle 👉 Check the full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-redshift-oracle Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real-time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video> <video> 92 How to generate insert statements from an existing table in sql server Description: How to generate insert statements from an existing table in sql server SQL Server tutorials: https://www.youtube.com/playlist?list=PL_YF--8vjjEVLxcpk2gcc_r5BpNeG6Yym SQL Server Developer Interview questions: https://www.youtube.com/playlist?list=PL_YF--8vjjEXlKdZv4ogROrGgfaQ0aTYg How to generate insert statements from an existing table in sql server Generate INSERT statement in Management Studio What is the best way to auto-generate INSERT statements How can I generate an INSERT script for an existing SQL table If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> 90 How to delete duplicate records in a sql server table Description: How to delete duplicate records in a sql server table Download the scripts used in the video from here: https://drive.google.com/drive/folders/1vRE04hNOu6bqoMNkXX7i8DHL9B3rPVj- SQL Server tutorials: https://www.youtube.com/playlist?list=PL_YF--8vjjEVLxcpk2gcc_r5BpNeG6Yym SQL Server Developer Interview questions: https://www.youtube.com/playlist?list=PL_YF--8vjjEXlKdZv4ogROrGgfaQ0aTYg How to delete duplicate records in a sql server table How can I delete duplicate records? How to delete duplicate records in SQL with condition? How to delete duplicate rows in SQL but keep one? If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> How to migrate data from Zoho CRM and PostgreSQL to SQL Server Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components https://www.devart.com/ssis/universal-bundle/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-zoho-pg In this video, I’ll guide you through migrating data from Zoho CRM and PostgreSQL to SQL Server using Devart SSIS Data Flow Components. This tutorial walks you through each essential step to ensure a smooth and seamless migration, all without complex coding. You'll see the complete process of transferring data from Zoho CRM and PostgreSQL to SQL Server. Timestamps: 0:00 Introduction 4:14 Fetch data from Zoho CRM 8:26 Fetch data from PostgreSQL 11:16 Merge data 14:57 Derived column transformation 18:06 Data conversion configuration 20:02 Pull data to SQL Server 🔥 You can download a trial of SSIS Data Flow Components here: https://www.devart.com/ssis/universal-bundle/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-zoho-pg 👉 Check the full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-zoho-pg Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video> <video> How to migrate data from Salesforce to SQL Server using SSIS Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components https://www.devart.com/ssis/universal-bundle/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-salesforce-sqlserver In this video, I will show you how to migrate data from Salesforce to SQL Server using Devart SSIS Data Flow components. This tutorial covers all the necessary steps to ensure a smooth data migration process without complicated coding. I demonstrate the entire process of migrating data between Salesforce and SQL Server. Timestamps: 0:00 Introduction 0:44 Installing Devart SSIS Components 1:48 Checking Salesforce Account data 3:29 Creation SSIS project 4:40 Connect to Salesforce 8:09 Connect to SQL Server 9:21 Run migration using SSIS 9:50 Migrating data from SQL Server to Salesforce 13:59 Checking migration results 14:43 Delete Salesforce data using Developer console 16:30 Summary 👉 Check full overview of SSIS Data Flow Components for Salesforce here: https://www.devart.com/ssis/salesforce/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-salesforce-sqlserver 🔥 You can download SSIS Data Flow Components for Salesforce Trial here: https://www.devart.com/ssis/salesforce/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-salesforce-sqlserver 💰 You can compare pricing options of SSIS Data Flow Components for Salesforce here: https://www.devart.com/ssis/salesforce/ordering.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-salesforce-sqlserver 👉 Check full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-salesforce-sqlserver Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real-time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video> <video> How to register the dll to GAC | How to register the assembly to GAC Description: How to register the dll to GAC Download files: https://drive.google.com/drive/folders/1c-UcVD59h5gmZ3K1hdXIjthjtN5eKD65 How to register the dll to GAC How do I register a .NET DLL file in the GAC? How to put dll in GAC? How to register a .dll file? If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> 91 What is a schema in sql server Description: What is a schema in sql server Download the scripts used in the video from here: https://drive.google.com/drive/folders/1UrKe3YX0tMFw7PTAsgp8jtPgUqw-1Fhi SQL Server tutorials: https://www.youtube.com/playlist?list=PL_YF--8vjjEVLxcpk2gcc_r5BpNeG6Yym SQL Server Developer Interview questions: https://www.youtube.com/playlist?list=PL_YF--8vjjEXlKdZv4ogROrGgfaQ0aTYg What is a schema in sql server What is schema mean in SQL Server? What are schemas in a database? What is the difference between a schema and a table in SQL Server? If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> How to migrate data from Mailchimp to SQL Server using SSIS Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components. https://drive.google.com/drive/folders/1LHS9Qbqiv0bAn9jzhubmGQglCZY6j0j4 In this video, I will show you how to migrate data from Mailchimp to SQL Server using Devart SSIS Data Flow components. This tutorial covers all the necessary steps to ensure a smooth data migration process without complicated coding. I demonstrate the entire process of migrating data between Mailchimp and SQL Server. Timestamps: 0:00 Introduction 1:15 Mailchimp account overview 2:19 Migrating Data from Mailchimp to SQL Server 6:35 Migrating Data from SQL Server to Mailchimp 🔥 You can download SSIS Data Flow Components for Mailchimp Trial here: https://www.devart.com/ssis/mailchimp/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-mailchimp 💰 You can compare pricing options of SSIS Data Flow Components for Mailchimp here: https://www.devart.com/ssis/mailchimp/ordering.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-mailchimp 👉 Check full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-mailchimp Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video> <video> 163 SSIS excel source is truncated 255 characters Description: Open regedit 1. I changed the value of the registry key TypeGuessRows from 8 to 0. This key is going to be in either of these locations: i) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel ii) HKEY_LOCAL_MACHINE - SOFTWARE - Wow6432Node - Microsoft - Jet - 4.0 - Engines - Excel ------- 2. I changed the value of the registry key TypeGuessRows from 8 to 0. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel Download files and scripts: https://drive.google.com/drive/folders/1M_eFJeDGjsyIj24TPXClLm9P7Id0u_Dd SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF--8vjjEVEXMf2hEFn0D5tEJV9kRqi SSIS real time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 SSIS excel source is truncated 255 characters How do I fix truncation error in SSIS? Excel source having more than 255 characters How do I remove the 255 character limit in Excel? What is the 255 limit in Excel? Happy Learning. If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” </video> <video> How to migrate data from Google BigQuery to SQL Server using SSIS Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components https://www.devart.com/ssis/universal-bundle/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-bigquery-sqlserver Ready to simplify your data migration process? In this video, I’ll demonstrate how to seamlessly transfer data from Google BigQuery to SQL Server using Devart SSIS Data Flow components—no coding skills required! Timestamps: 0:00 Introduction 0:58 Making Google BigQuery DataSet 6:05 Connect to Google BigQuery 9:21 Connect to SQL Server 10:08 Run migration using SSIS 11:50 Migrating data from SQL Server to Google BigQuery 14:29 Summary 👉 Check full overview of SSIS Data Flow Components for Oracle here: https://www.devart.com/ssis/bigquery/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-bigquery-sqlserver 🔥 You can download SSIS Data Flow Components for Oracle Trial here: https://www.devart.com/ssis/bigquery/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-bigquery-sqlserver 💰 You can compare pricing options of SSIS Data Flow Components for Oracle here: https://www.devart.com/ssis/bigquery/ordering.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-bigquery-sqlserver 👉 Check full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-bigquery-sqlserver Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real-time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video> <video> How to migrate data from HubSpot to SnowFlake using SSIS Description: Use promo code LEARNSSIS10 to unlock a 10% discount on Devart SSIS Data Flow Components https://www.devart.com/ssis/universal-bundle/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-hubspot-SnowFlake In this video, I’ll guide you through migrating data from Zoho CRM and PostgreSQL to SQL Server using Devart SSIS Data Flow Components. This tutorial walks you through each essential step to ensure a smooth and seamless migration, all without complex coding. You'll see the complete process of transferring data from Zoho CRM and PostgreSQL to SQL Server. In this tutorial, we'll guide you through the process of migrating data from HubSpot to Snowflake using SQL Server Integration Services (SSIS). Migrating data between platforms can be complex, but with SSIS and the right approach, it can be done efficiently and seamlessly. Timestamps: 0:00 Introduction 1:18 Set up and configure Hubspot account 2:44 Set up and configure Snowflake account 7:36 Configure Hubspot source component 10:06 Derived column transformation 11:32 Configure Snowflake destination component 14:39 Test SSIS package This step-by-step guide will help you streamline your data migration process and ensure smooth integration between HubSpot and Snowflake. 🔥 You can download a trial of SSIS Data Flow Components here: https://www.devart.com/ssis/universal-bundle/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-hubspot-SnowFlake 👉 Check the full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=learn-ssis-hubspot-SnowFlake Happy Learning. If you have any questions or suggestions, please comment on the video or write to me at “aqil33@gmail.com” ⬇️ Download files and scripts: https://drive.google.com/drive/folders/1-zmuKbL643Ea1nCTVFJzMAyYp8YATZWH ➡️ SSIS Tutorials: https://www.youtube.com/playlist?list=PL_YF%E2%80%938vjjEVEXMf2hEFn0D5tEJV9kRqi ➡️ SSIS real time scenarios examples: https://www.youtube.com/playlist?list=PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY ➡️ SSIS Interview questions and answers: https://www.youtube.com/playlist?list=PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7 </video>

Contacts and Links

Description

By learn SSIS channel we will learn how to use SSIS for ETL purpose. SQL Server Integration Services is an ETL tool provided by Microsoft for ETL purpose.

ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. If we want to load data from flat file or from excel file to SQL Server then we need some ETL tool like SSIS for this purpose.
This channel Learn SSIS is aimed at providing professionals with knowledge on SQL Server Integration Services. If you regularly see videos in this channel, you will be able to

• Design and Understand the SSIS Solutions
• Import and Export Data from and to different Sources
• Create, manage and maintain SSIS Packages
• Import and Export Data from and to different Sources using SSIS
• Use different Transformations to change the data on the fly

You can contact me on aqil33@gmail.com

Videos from channel