SQL Import Help
-
I have a source of a 2007 excel workbook and of the data is there that needs to be there for the import to the SQL 2008 destination table. i.e all "not null" fields are populated and mapped except the primary key which happens to be a unique identifier datatype. I have tried creating a column using the NEWSEQUENTIALID() function in the first row.....that works for inserting nulls into a "shell" db but it fails everytime on the destination table that has a primaery key on the field and unique identifer as the data type. Question: How do I generate the GUIDS (unique identifers) from a DTSX package? Is there a work around? I have spent the whole night trying everything except the right way. Any help is greatly appreciated. Thanks,
Regards, Hulicat
-
I have a source of a 2007 excel workbook and of the data is there that needs to be there for the import to the SQL 2008 destination table. i.e all "not null" fields are populated and mapped except the primary key which happens to be a unique identifier datatype. I have tried creating a column using the NEWSEQUENTIALID() function in the first row.....that works for inserting nulls into a "shell" db but it fails everytime on the destination table that has a primaery key on the field and unique identifer as the data type. Question: How do I generate the GUIDS (unique identifers) from a DTSX package? Is there a work around? I have spent the whole night trying everything except the right way. Any help is greatly appreciated. Thanks,
Regards, Hulicat