Ssis vstslavori

Si ricerca un Esperto Business Intelligence/Data Warehousing. Sono richieste le seguenti conoscenze tecniche: SQL Server, T-SQL, SSIS, SSRS, Microsoft DQS, MDS, Data Quality Management. Indispensabili capacità di analisi e problem solving. Completano il profilo buone capacità di lavorare in team, metodicità, gestione delle priorità ed attenzione ai dettagli. La ricerca ha carattere di urgenza ed è rivolta a persone di entrambi i sessi. Luogo attività: Bari

progettista DW in ambiente MS con competenze SSIS

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target da...

I require an experienced SSIS developer to aid in a data transformation project. The key tasks will involve taking data from a Relational Database Management System and transforming it to fit into our data warehouse. Key tasks: - Understand the structure of the source data - Develop an SSIS package tailoring to these requirements - Test the functionality of the SSIS package for effective data transformation Many of these tasks will be dealing with structured data, hence a strong understanding and experience in handling such data type is critical. Only consider participating if you have: - Proven experience with SSIS data transformation processes - An in-depth knowledge of handling structured data - Past experience transforming data from Relational Database ...

Job Title: Senior Master Data Management (MDM) Developer Monday to Friday Remote via Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 INR per month We are seeking a Senior Master Data Management (MDM) Developer with a focus on healthcare. Strong SQL skills for data manipulation and querying. Experience with ETL development and integration...Strong SQL skills for data manipulation and querying. Experience with ETL development and integration. Familiarity with Azure Data Factory and cloud/on-prem migrations is advantageous. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: Master Data Management (MDM) ETL development and integration Strong SQL skills SSIS Azure Data Factory Cloud/on-prem ...

I recently attempted to upgrade my SSIS to the 2019 version, on my Windows Server 2019. However, I am encountering problematic error messages relating to the odbc 64 bit issue. Specific Qualifications and Tasks: - Extensive knowledge and experience with SSIS 2008, 2012, 2016 and most importantly 2019 - Proficient in troubleshooting and upgrading processes on Windows Server 2019 - Ability to pinpoint and rectify the odbc 64 bit issue on SSIS upgrade - Efficiently resolve the emerging error messages Your past experiences with similar issues will be highly beneficial in this project. Your role is to figure out the root cause of these errors, fix the problem and ensure a successful upgrade to SSIS 2019.

I'm looking for an experienced .NET developer with a solid understanding of SQL Server Integration Services (SSIS) to help with critical data integration tasks. The primary objective is to help me understand extract, transform, and load data into a databases. Your responsibilities will include: - Extracting data from multiple sources - Handling data transformation procedures - Loading transformed data into the target destination I need someone who can show me a demo of how to work with SSIS via screen sharing.

More details: ¿Qué tipo de datos desearía cargar desde SQL Server a Sharepoint List? Datos de ventas ¿Con qué frecuencia necesita actualizar los datos en Sharepoint List? Diariamente ¿Desea incluir alguna funcionalidad de automatización o alertas cuando se actualicen los datos? Actualización automática de datos

More details: What specific tasks do you need assistance with in regards to SSIS? Troubleshooting existing packages What data sources are you integrating with SSIS? SQL Server What is the primary goal of troubleshooting these SSIS packages? Resolving connectivity or security errors

I need an ETL developer to streamline and automate an existing manual process. This includes: - Transferring two encrypted *. files from a source server to a local machine. - Decrypting these files into *.csv format. - Running SQL on one file and a PowerShell command on the other file to create a staging table. - Setting up a Microsoft SQL Server database into read-write mode from read-only. - Reverting the database back to read-only upon task completion. - Sending a report to the user upon task completion. Ideal skills for this job include advanced SQL, PowerShell, and ETL development. Familiarity with read/write permissions on Microsoft SQL Server and experience with data transfer and encryption/decryption processes are also highly beneficial.

Looking for an experienced MSBI and powerbi developer. You would be working with me to troubleshoot and optimize an existing MSBI solution and powerbi report. Your tasks include but are not limited to: - Data Modeling - ETL Development - Report Development For this project, your primary tools would be: - SQL Server Integration Services (SSIS) - SQL Server Analysis Services (SSAS) - power bi Your experience and skills in these areas will be critical to the success of our project. Only serious and high-quality professionals need apply. This is a challenging role and previous experience in the given areas is a must. Let's enhance our MSBI solution together and make it the best it can be.

To update ssis pacjage embedded api in ssis

I need an SQL and SSIS developer for my personal project. My primary goal is to optimize my SQL database, which is currently facing several performance issues. Key Problems: - Slow query execution - High resource consumption - Inefficient indexing The ideal candidate should have a strong background in SQL and SSIS for database optimization. A thorough knowledge of SQL query optimization, resource management, and indexing is essential. I am seeking an expert who can effectively address these specific issues and enhance the overall efficiency of my SQL Server development. Any suggestions for further improvements are also welcome.

As the project owner, I urgently need a skilled SQL Server and SSIS (SQL Server Integration Services) Developer to propel my database optimization objectives. Your primary tasks will focus on: - Fine-tuning SQL queries - Carrying out schema optimizations - Development using SQL I'm currently dealing with several performance issues, including slow query execution, high disk I/O, and index fragmentation. Therefore, for this task, the ideal candidate should possess a sharp understanding of query tuning and optimization, as well as practical experience with complex SQL Server and SSIS development projects. If you have proven experience in eliminating these types of issues and know how to implement effective optimizations, I am eager to work with you. Your high-level SQL...

I'm seeking a developer skilled in SSIS, C# and SQL for this project. The task involves fetching JSON data from an API using oauth with a username and password. This data will then need to be written to a SQL table. The main specifications are: - API provides JSON data - Only specific fields are required from the JSON data for the SQL table write operation - These fields are constant and will not change in the future Confident understanding and experience with JSON, C#, API fetch, SSIS, and SQL are paramount. The ideal candidate will be adept at creating smooth integrations, dealing with API provided data and handling SQL scripts.

As an organization, we are aiming for proficient data analysis and reporting using the SQL database, which is below 1GB. We need an experienced professional with skills in: - Writing strong SQL queries - Developing effective SSIS packages - Creating insightful SSRS reports This project primarily focuses on enhancing our data comprehension and subsequent reporting, thus requiring a thorough command of SQL related tasks. The suitable freelancer for this job should possess strong analytical skills and have a proven track record of database management and optimizing results.

I am looking for an advanced Node.js developer to create an integration app between Zendesk and Azure DevOps. This project requires high level knowledge and experience as it involves backend development and API integration. The aim is to build an app comparable to [this one](), with some special customizations, details of which I will provide to successful applicants. Specifically, * The developed application should pre-populate Azure DevOps work item fields. * Functionality to automatically close the associated Zendesk ticket when an Azure DevOps work item is closed. * The app should have a branded user interface. Ideal Candidate: * Advanced level proficiency in Node.js. * Prior experience with Zendesk and Azure DevOps API integration. *

For my project, I require a senior MSBI developer well versed in both SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services). The main focus of the project will be: - Data Integration: Consolidating and transforming data from various sources - Data Analysis: Interpreting the integrated data and turning it into insightful information The ideal candidate should have: - More than five years of experience, with specific skills in SSIS and SSAS - A proven track record of handling complex data integration and analysis efficiently - Demonstrated proficiency in translating business requirements into solutions - Excellent problem-solving skills and the ability to work under stringent timelines.

...messages in designated conversation threads on the Feishu chat application. Key job requirements include: * In-depth knowledge of Feishu API integration * Experience with server-side scripting for automated messaging systems * Familiarity with Feishu chat workspace, channels, and threads The system should be able to send: * Regular text messages * File attachments * Notifications regarding SSIS Job Failure or Success Your work will be instrumental in improving team communications by establishing instant Feishu alerts for both successes and failures. Please take into account that this system must support continuous, long-term operation. Please bid if you can confidently meet these requirements. Your proposal should detail your previous experience and the strategy you propose...

I am in need of an SSIS expert to assist me. I have multiple packages and I am unable to find out which package is loading my main table. Also I need to know the need for service account in running a job. Few other queries related to ssis jobs and package deployment. Can specify the details over call.

I'm in need of experienced assistance for my SSIS 2019 as I'm encountering a buffer allocation error during my data loading activities. Despite having no recent changes to the SSIS package, this persistent issue has perplexed me. I'm in need of a proficient SSIS developer that can: - Diagnose the buffer allocation error - Resolve the issue proficiently to avoid recurrence - Ensure smooth data loading operations in SSIS Your deep-rooted knowledge in SSIS and its working will be critical in solving this complex issue. Any specific experience in dealing with buffer allocation errors in SSIS 2019 would indeed be a plus. You should be able to work without supervision to rectify this issue. Let's collaborate if you fit these requir...

...ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ü Must have ability to conceptualize ideas and data streams to schemas. ü Expert at ETL transformations using SSIS. ü Good knowledge of analytics tool like AWS Quick Sight. ü 4+ Years of proven experience working with high volume multi-client SAAS solutions. ü Must be expert at communicating technical issues to non-business users. ü Must have business-oriented thought process. ü Proven expert at setting up standards and coding process ü Must h...

...must. - Extensive experience with **.Net Core** and **Entity Framework** to efficiently manage our project needs. - Strong knowledge of both **MySQL and SQL** for effective database management. - Fluent in **Bootstrap**, **HTML5/CSS3** to ensure our applications are responsive and visually appealing. - Capable of utilizing **Jquery** and **Angular** for front-end development. - Experience with **SSIS** and **SSRS** for SQL server integration and reporting services. - Proficiency in developing **web services** and willingness to learn or work with **3rd party APIs** as per project needs (precise APIs will be discussed later). **Project Goals:** We aim to enhance our current applications and possibly integrate new functionalities to improve our services. The ideal candidate should...

...Services (SSIS,SSRS,SSAS). While expertise in other MS BI areas is appreciated, SSIS should be your main strength. Tasks will revolve around data modeling and visualization, report creation and customization, as well as data integration and ETL processes depending upon the demand of the projects on hand. Please note, however, that all the mentioned tasks are equally important in this role. Ideal candidate should: - Have proven experience with Power BI and SSIS,SSRS - Be comfortable tackling both the big picture and diving into the details - Provide examples of past work showcasing their expertise in these areas The key to a successful application is a concise, detailed description of your experience with the aforementioned technologies. Draw emphasis on your wor...

I'm seeking a skille...reads the VU Meter (Klanghelm VU Meter) signal with precise level measurement and edits the clip gain to stay around 0 dBVU. - Customizable appearance to align with user preferences - Compatibility across numerous DAWs without disruption to existing workflows - Automatic clip gain adjustment in response to VU Meter levels Ideal Candidate: - Previous experience creating audio plugins, specifically VSTs - A portfolio showcasing relevant projects - Strong communication skills for regular updates - Attention to detail and a focus on quality user experience Please provide examples of previous work in your bid and a brief explanation of how you would approach this project. I'm excited to collaborate with talented individuals passionate about audio techno...

Hello, I've been working as a data engineer at a technology consultancy firm for a year. I'm looking for a men...situations. Apart from that, I will handle the jobs on my own. My goal is to create a win-win strategy by combining the mentor's knowledge with my dedication to work and learning. If interested individuals reach out, we can discuss the details, and I am open to different offers. Regarding my expertise, I have worked on ETL, ELT, and DWH projects. The tools I have used so far include SQL Server, T-SQL, SSIS, Azure Data Factory, Oracle SQL, Apache Airflow, Apache Spark, Power BI, etc. I am an open-minded person eager to learn and extremely enthusiastic about personal development. I believe that by finding the right mentor, we can achieve great things togeth...

!!!!I will not accept anybody who does not post a sample first that sounds like what I need!!! ------------------------- I am looking for somebody who is a real expert at orchestral VSTs or other virtual instruments. I am trying to copy a certain song, and I don't know which orchestral instrument to pick. I have attached an excerpt of the song to this project. If you are interested, please send me an audio of your version so that I can see that you have the right instruments for that. This might become a bigger project. Thank you!

!!!!I will not accept anybody who does not post a sample first that sounds like what I need!!! ------------------------- I am looking for somebody who is a real expert at orchestral VSTs or other virtual instruments. I am trying to copy a certain song, and I don't know which orchestral instrument to pick. I have attached an excerpt of the song to this project. If you are interested, please send me an audio of your version so that I can see that you have the right instruments for that. This might become a bigger project. Thank you!

I need a proficient freelancer who exhibits excellent expertise in SQL Server and SSIS. Key tasks include: - Writing intricate SQL database queries - Designing and implementing ETL processes Specific features for these tasks must include data validation and cleansing to ensure the highest quality and most reliable data possible. You'll be handling structured data such as SQL and spreadsheets. The ideal freelancer would have extensive experience in handling and manipulating structured data, with a strong foundation in error handling, logging, and performance optimization.

We are looking for a . Net Developer with min 5+ of experience, for 06 months contract, who can support us for 8 hours in a day over fixed schedu...package/system evaluation, back-end and front-end development. Nice to have 1-year experience on Angular 2+. Nice to have experience working with MS Azure. C#, Web API Web service .NET core .Net with Web API C# LinkQ Entity framework 6.0 Mock unit testing .Net Framework 4.0 and above, Visual (2019) SQL Server 2016 and above HTML/CSS, AJAX, jQuery, JSON, JavaScript GIT repository, BitBucket SSIS (SQL Server Integration Services) packages Experience working in Scrum teams Familiar with Design patterns. Hands on experience with design pattern will be plus. A Good understanding of OOP principles A good understanding of N-tier architecture

I am in need of a skilled tutor who can help me enhance my abilities in data integration and ETL (SSIS), reporting and visualization (SSRS), and database querying and management (TSQL). My main goal is to improve data integration processes. In this project: - You will support my learning to drive more efficient data integration operations. - In-depth knowledge and practical training on how to generate insightful reports and visualizations will be expected. - The training must cater to an intermediate level familiarity with SSIS for data integration. Ideal Skills and Experience: - Experience in SSIS, SSRS, and TSQL. - Ability to impart knowledge effectively. - Experience working with intermediate learners. - Familiarity with different learning styles.

...with a size of less than 100MB. Preferred Method for Data Import: - I don't have a specific preference for the method of data import. The freelancer can choose between SQL Server Integration Services (SSIS) or Bulk Copy Program (BCP) based on their expertise and recommendation. Project Completion Timeframe: - I need this project to be completed as soon as possible (ASAP). Skills and Experience Required: - Proficiency in working with MS Access and SQL Server databases. - Experience in importing and migrating data from MS Access to SQL Server. - Knowledge of SQL Server Integration Services (SSIS) and/or Bulk Copy Program (BCP) would be beneficial. - Attention to detail and ability to ensure data integrity during the import process. If you have the required skills an...

Hi All, We are looking for resources who can help us with our client project. Requirement 1:- Experience – 12 + yrs Contractor – Long term Start Date – Immediate Budget - 80k Mandatory Skills – Power BI, SSIS,SSRS, CRM application ( Finance , payment gateway modules ) pref MS Dynamics, good knowledge in Snowflake,SQL Requirement 2:- Role 2: SAP Vertex Consultant Type: Contract; 6+ months Location: Remote Exp: 10+Yrs 5PM to 1AM IST Budget - 80k JD: Roles & Responsibilities: Configure and implement SAP Tax Vertex solution to meet the organization's tax compliance requirements. Collaborate with cross-functional teams to gather tax-related requirements and provide expert guidance on tax solutions. Maintain and enhance tax-related configurations withi...

PLEASE READ ATTCHCHD FILE. I am looking for a freelancer who can help me with SSIS and SSRS tasks. Specifically, I need assistance with designing and developing ETL packages. Ideal Skills and Experience: - Strong knowledge and experience with SSIS and SSRS - Proficiency in SQL Server 2019 - Experience in designing and developing ETL packages - Familiarity with creating and managing data sources and reports - Ability to troubleshoot and optimize existing packages and reports In this project, I have existing databases that need to be integrated. Therefore, the freelancer should be able to work with existing databases and ensure smooth integration with the ETL packages and reports.

I am looking for a skilled SSIS developer to assist me with loading data from a CSV flat file into a SQL database. i am Doing first time in my PC and I am getting Error, I am looking some to take my remote and load it. also can understand me why this error was showing so wants to learn as well. Have around 5 table around 200 Mb Size File Format: CSV & Flat File Transformations and Data Cleansing: None required Database Size: Small (less than 1GB) Skills and Experience: - Proficiency in SSIS (SQL Server Integration Services) - Strong knowledge of ETL (Extract, Transform, Load) processes - Experience in loading data from CSV files into SQL databases - Familiarity with data mapping and data validation - Understanding of database structures and SQL queries - Attenti...

...production DAW). Basically, I want a Jarvis that can immediately do what I tell it to do--having to do with music production within my DAW. If I say, "Jarvis, open the EQ on track 4 and shelf the high's at 700Hz by 8dB," I want it to open the EQ on track 4 and lower my high shelf by 8dB starting at 700Hz. It also needs to be able to execute voice commands that involve the parameters of 3rd party VSTs, so it needs to be able to recognize parameters in general, not just parameters native to Logic. Deliverables - AI voice (command) recognition - Custom-tailored for workflow in Logic Pro X - Ability to discern when I'm giving it a command or just talking to someone else or recording - Ability to quickly execute any and all voice commands I give it within the boun...

...production DAW). Basically, I want a Jarvis that can immediately do what I tell it to do--having to do with music production within my DAW. If I say, "Jarvis, open the EQ on track 4 and shelf the high's at 700Hz by 8dB," I want it to open the EQ on track 4 and lower my high shelf by 8dB starting at 700Hz. It also needs to be able to execute voice commands that involve the parameters of 3rd party VSTs, so it needs to be able to recognize parameters in general, not just parameters native to Logic. Deliverables - AI voice (command) recognition - Custom-tailored for workflow in Logic Pro X - Ability to discern when I'm giving it a command or just talking to someone else or recording - Ability to quickly execute any and all voice commands I give it within the boun...

I am in need of help with a SSIS deployment. Specifically, I need help setting up the deployment environment. I have an existing setup of SSIS 2014 or later already set up. I need help troubleshooting any deployment issues, and optimizing performance. Please help me with this project.

...service account called 'saCassAppsPrd' SQL Server, SSIS and SQL Agent services run with this service account. This service account has access network drive where input files are placed. When I run the SSIS package which reads an excel from the network drive, it returns an error message . File System Task:Error: An error occurred with the following error message: "Access to the path ' corpIOOFOperationsMelbourneComplaintsP&I ComplaintsReporting & InsightsConnected Data Sets AtlasDaily_Output' is denied.". Is there anything am I doing wrong, how can I fix this error? Specific requirements for the project include: - Importing data from files using SSIS - Preferred method for importing data is SSIS, specifical...

...combine royalty-free musical or audio elements from the Pro Sound FX or ProTools audio library to help create your episode, but you CANNOT use other elements from the internet / youtube, or commerical libraries like Splice etc. PLEASE only use audio materials which you create/record yourself Cite and link to any of these audio elements included from these websites. Use of virtual instruments / VSTs in Protools is allowed....

...combine royalty-free musical or audio elements from the Pro Sound FX or ProTools audio library to help create your episode, but you CANNOT use other elements from the internet / youtube, or commerical libraries like Splice etc. PLEASE only use audio materials which you create/record yourself Cite and link to any of these audio elements included from these websites. Use of virtual instruments / VSTs in Protools is allowed....

I am looking for a skilled developer who can recreate an old SSIS package that was originally created on SSIS 2008. I have the original source code available for reference. Project Requirements: - Expertise in SSIS 2008 - Ability to recreate the package based on the provided source code - Familiarity with improving efficiency in SSIS packages The desired outcome of the project is to have an updated SSIS package that demonstrates improved efficiency compared to the original version. If you have experience in SSIS 2008 and are confident in your ability to recreate and optimize the package, please submit your proposal.

Interfell CORP está buscando un desarrollador SQL (Bilingüe) Conectamos profesionales de TI con las mejores empresas de Latinoamérica, USA y Europa. ?Compensación: USD 3.3k-3.75k / mes ?Ubicación: En remoto. Lunes a Viernes de 9am a 5pm (US/Eastern) ?Habilidades: ·SSIS (SQL Server Reporting Services) ·Transact-SQL ·Recuperación de datos ·Trabajo en equipo ·Resolución de problemas ⭐Requerimientos: ·Mínimo de 3 años de experiencia trabajando como MS SQL Server Developer ·Dominio avanzado del idioma inglés y español (Excluyente) ·Aplica aquí:

...platform, Student Information System, and related web products such as JICS and eLearning. working with an academic learning management system (LMS) such as Canvas or Blackboard. developing/integrating with Web Services using REST APIs or other web protocols (SOAP, HTTP). proficiency working with a client/server database system such as SQL Server, including T-SQL, SSIS packages, and data reporting tools. developing server and/or client-side data-driven solutions using one or more of the following technologies: ASP.NET, C#, HTML5, CSS, XML, jQuery, Node.js. Required Education/Experience: A Bachelor’s degree in a relevant technology field and a minimum of 2 years of applicable work experience in web design and web programing or an equivalent combination

...platform, Student Information System, and related web products such as JICS and eLearning. working with an academic learning management system (LMS) such as Canvas or Blackboard. developing/integrating with Web Services using REST APIs or other web protocols (SOAP, HTTP). proficiency working with a client/server database system such as SQL Server, including T-SQL, SSIS packages, and data reporting tools. developing server and/or client-side data-driven solutions using one or more of the following technologies: ASP.NET, C#, HTML5, CSS, XML, jQuery, Node.js. Required Education/Experience: A Bachelor’s degree in a relevant technology field and a minimum of 2 years of applicable work experience in web design and web programing or an equivalent combination

Data Engineer with SQL, Powerbi, Cloud experience I am looking for a skilled data engineer...looking for a skilled data engineer with 5+ experience in Microsoft SQL Server to assist me with creating reports and dashboards using PowerBI 5hoursday for 5 days in a week in CST morning time Skills and Experience Needed: - Strong proficiency in Microsoft SQL Server - Experience in creating reports and dashboards using PowerBI - Familiarity with data migration and data analysis. Experience in SSIS - Knowledge of cloud platforms (Azure, AWS, etc.) is a plus Project Requirements: - The main goal of this project is to create reports and dashboards using PowerBI. - The expected deliverable format is a PowerBI Dashboard. If you have the necessary skills and experience, please apply for thi...

...Table. Create the Stored Procedure Transaction to summarize the data to a table (DailySalesChanges table). The table will be used to create an SSIS project to export the data to excel. The table will include a column for RunDate with the current timestamp. Update the DataWarehouse with Sales and add Sales for Persons. Include the current date and time, the member’s name, address, summarized metric name, value before update, value after update Create the Stored Procedure Transaction to summarize the data to a table (SalesPerformance table). The table will include a column for RunDate with the current timestamp. The table will be used to create an SSIS project to export the data to excel. The process needs to run automatic using Sql Server Agent with Sql Server ...

Need someone to build azure pipeline in synapse using rest api. ssis background preferred.

For AdventueWorks add summary for people with sales. Determine which people will be of most interest to managers, export those records to excel, summarize the records, add the people to the people table to retain sales data. Total sales by person for the end of the day. Use T-SQL to add sales for the end of the day to the Data-Warehouse Show changes from day to day, record the changes in a changes by day table. AdventureWorks2008R2 and AdventureWorksDW2008R2 Visual Studio 2022 Sql Server 2019 You can message me if you want the links for the AdventureWorks datbases on the Microsoft Website Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login remote and work on my re...

Add data cleansing to T-SQL scripts for peoples demographic data. Some examples to check for are format for zip code, email address, and proper capitalization. For records with errors add those to the table for InValid records with a comment of what the error is. You can add a column to that table to add the error type. For records that are valid add those to a table for valid records. I have created the tables and have the create scripts for those. I have also created some data cleansing like checking for duplicates. Make recommendations on what further data cleansing should be added. There might be a data cleansing project for AdventureWorks on the web or github you could use that and make any comments on it you think wold be better. Message me and I will send you the scripts I have so f...