Bulk insert MS SQL : error with GUID field

Support
1

Hello,

To copy data from one table to another (not same database and not same server), I use bulk export;
When inserting data, uniqueidentifier/GUID type doesn’t work.

Here error with field GUID empty (00000000-0000-0000-0000-000000000000).

image
image768×224 7.5 KB

Several tables are copied and I use automatic mapping.
image

How can I do ?

Thanks for your help.

2

Hello Florent,

The uniqueidentifier/GUID column type is not supported by the Bulk export to database action.

You can try to import GUIDs as strings to another column or table and then convert them with an additional SQL query.

3

I don’t understand where the difficulty is. Bulk function detects issue and should be able to deal with it. I’ll see if the insert function manages to process data.

I can’t do what you ask me to do. Goal is precisely to copy a large amount of valued into many tables without changing tables structures.

4

Bulk export works differently than regular export to DB. It doesn’t use SQL under the hood, but instead uses proprietary commands provided by the database driver. We can’t change how these commands are executed.

5

I was able to get everything up and running in acceptable time.

Thanks for help.