The TypeID returned from the lookup is what I then want to use in the DefinedTermID field in the destination table which is an int. The source DefinedTerm is a string which I use in the lookup query to find the TypeID which returns the ID e.g. IntDT = DTSLookups("lkup_DefinedTerm").Execute(DTSSource(" DefinedTerm")) Invalid data value for 'DefinedTermID' in destination column.ĭTSDestination("DefinedTermID") = DTSSource("DefinedTerm") I am stuck on the following transformation error message: Some of the fields are foreign keys in other tables therefore I am using the DTS lookup functionality. I am trying to import an excel spreadsheet into a SQL database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |