Trying to create a custom dts package that imports data from excel spreadsheet to db. One of the issues is that the columns in the main entity tables are not identity columns. So how do you get the appropriate PK?
Well I thought the following would work but it doesn't. Any ideas?
Basically trying to use the variable as the starting point in the temp identity declaration. Is this a syntax error or a "no-no".
declare @maxid int
select @maxid = (select max(objectid)+1 from object)