Trying to import a excel spreadsheet and I have setup the transform as
such...

Function Main()
DTSDestination("id")=
DTSDestination("fn") = DTSSource("First")
DTSDestination("ln") = DTSSource("Last")
DTSDestination("uid") = DTSSource("Nalphakey")
DTSDestination("bldg") = DTSSource("Building Desc")
DTSDestination("cat") = DTSSource("Cat")
DTSDestination("hiredate") = DTSSource("Hire Date")
......


I don't know how to auto fill the ID field. It is an INT datatype is set
for Identity and the increment is set to 1. But when I run my
transform...usually just leaving out the DTSDestination("id") portion I
get an error stating I can't insert a null value into ID.

As you can tell I am rather new to DTS transforms. Thanks for the info.

Jason

If the identity is set at the table level, take it out of your script
completely.

"JasonMeyer" wrote:

Jeffrey K. Ericson wrote:

The script actually doesn't have the identity in it. I just left it in
there if there was some sort of function that I needed to add to get it
to autoincrement the field.

Jeffrey K. Ericson wrote:
transform and removed the tick in Enable Idenity Insert and removed the
ID field from the available destination columns. Thanks for the help.

Jason

You are suffering from this by the looks of things

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"JasonMeyer" <jason.meyer (AT) nospam (DOT) isd623.org> wrote