149 How to add uniqueidentifier GUID column in Data Flow in ssis

[@Mahmood-n7s]

Excellent information, thanks for continuously enriching the SSIS knowledge base

[@learnssis]

Thank you Sir.

[@blackisblack22]

Thx Aqil.

[@learnssis]

You are welcome 😀

[@catulopsae]

Thank you

[@learnssis]

You are most welcome.

[@sameerunawane]

sir i am trying incremental load where GUID column is present . each time when i execute the pk is changing and I am getting same record with different GUID (PK) . what can be the solution to avoid replication of data

[@learnssis]

You can not use incremental load with GUID column. You would need to find other columns in the table which can make the row unique.

[@sameerunawane]

@@learnssis with lookup i am able to achieve it. but the rest things i left with updation and deletion of records

[@amrselim2167]

Hello sire, I know this is note related to this video but actually you are my mentor and instructor of ssis, i need you guidance here, I have a package that tooks data from oracle database and insert it to sql database I already installed oracle client And I'm able to connect data from ssrs server for example, not just this I also convert the package from project mode to package deployment mode and make the configuration file as u did, the package works on visual studio sooooo fine, no issues at all but when i deploy it to file and import it from sql as a file system package and even give the configuration file it doesn't work, error is loooon and say something about oledb provider oraoledb oracle is not registered, of the 32 bit driver is not installed, run the package in 64 bit mode, i already tried to change the properties debugging runtime64 to false, but visual studio says only 64bit is supported and not allow me, i tried to change .dtproj by add line for runtime64 but still not working.... Please help 🙏

[@learnssis]

Hi, unfortunately I have not worked on migrating the data from Oracle to SQL Server, thus never been into this kind of error message before. I know when we get this kind of error while migrating data from Excel then what does that mean but don't know what might be the issue when doing this with Oracle.

[@amrselim2167]

@@learnssis okay please tell what it means in excel?!

[@learnssis]

@@amrselim2167When we get this error message in excel, then we download and install below drivers. www.microsoft.com/en-za/download/details.aspx?id=13255 First you can try installing the drivers for 32-bit and test it. If it does not work, then uninstall the Microsoft access 2010 drivers for 32-bit from control panel, you can also check based on installation date like which driver got installed today, thus uninstall it if it does not work, and then install the 64-bit drivers from the same link.