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

How to add uniqueidentifier GUID column in Data Flow in ssis

How to add uniqueidentifier GUID column in Data Flow in ssis
How can I add a GUID column in SSIS from a Flat File
Create a GUID column in SSIS
How to insert uniqueidentifier in SQL?
How to create a GUID in SSIS?

Happy Learning.

[Mahmood-ns]

Excellent information, thanks for continuously enriching the SSIS knowledge base

[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

[amrselim]

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 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 🙏

[vishroxx]

This particular problem can be easily solved by making the EmpId column table set to default value so that we don't have to implement anything in SSIS or via derived column.

EmpId UNIQUEIDENTIFIER DEFAULT NEWID()

CREATE TABLE Employee(
EmpId UNIQUEIDENTIFIER DEFAULT NEWID()
);