Data Validation & Transformation using SSIS Packages - 23/07/2018 05:44 EDT

Dear Employer, I specialize in SSIS - I know how to use it, I know how to extend it, and I teach it too. The sample transformation you describe is done in the data flow, and can be implemented in several ways. You can use: conditional Split and "Fork" your code with the expressions engine there You (sometimes) can use the same expression engine with the the ProductVersion == @Version? ProductVersion : @Version syntax to transform data based on conditions you can use scripting capabilities and write .net functions doing it you can even write your own component if you have complex logic, that does necessary parsing, comparison and transforms in code - and this component will install into the dataflow folder. I would like to hear the scope of the project to understand how best develop it to suit your needs and whether it could be done within your budget. I am open for the dialogue. I am in the pacific time zone. I will have availability to start on Wednesday. I prefer written communication, although I can meet with you on Zoom - video conferencing software. Upon establishing the plan I suggest to release code/money in stages. Sincerely, Virginia

hi I am expertise in etl part and can do whatever needed please let me know more info and can also discuss

currently i am working with vb.net application. We are creating ERP and POS system. So we are using SSIS package for sync Items in POS system and sync orders to ERp system from POS system.

I have 5+ years of experience in MSBI

Have more than 5 years of experience in SSIS, Sql Relevant Skills and Experience SSIS, SQL,

Worked on very similar task with my previous employer , I have complete knowledge on SSIS, Informatica,Sql Server and Teradata in addition with it I can write Unix Bash script if needed.

Hi, I am microsft certified database developer . havening better knowlege of SSMS, SSIS. having two years of experience . Regards Raghvendra

I am having experience of working with Canadian bank client in same technology. I am having brief knowledge of ETL tools like SSIS and Pentaho, where I have implemented these kind of validations and functionalities.

The project sounds very interesting. I had developed similar ETL packages in past for similar business requirements and few of them even had flat files/XML files as data source (compared to traditional database to database ETL). Looking forward to hearing from you

I am having experience of 5 + years in SSIS and SQL automation projects and deals with complex SQL codes on daily basis.. So I can be ideal choice for you. Test my work and then pay on satisfaction.

I've been a SQL Server DBA for the last 16 years. During this time I've worked in operations as well as in development spaces where I focused mainly on writing SSIS packages for iHeartRadio and UnitedHealthGroup in the USA. I'm very familiar with error handling, writing enough comments in the packages so it wont be difficult for another person to make changes/enhancements to the package later on.

I have one and half years experience on SSIS and ETL. At present i don't have much work so i can assure you that i can complete your requirement well before the deadline.