Dear all

I'm trying to in import a excell-table to my MSSQL-database. Problem is that I have a auto increment field of record id. If I import the table I tried to <ignore> the ID-field but with the conversion it won't use auto increment. Now the wizard reports that BLABLA_ID can't be NULL, cause i'm ignoring it

How can I use auto increment on Excell Import? some VBS code for it . I'm a dummy on DTS and VBS

Current generated code from the wizard

Function Main(
<here I need a function on OMZET_ID to auto increment
DTSDestination("OMZET_FILIAAL_ID") = DTSSource("F1"
DTSDestination("OMZET_JAAR") = DTSSource("2004"
DTSDestination("OMZET_WEEKNR") = DTSSource("F4"
DTSDestination("OMZET_OMZET") = DTSSource("F1"
DTSDestination("OMZET_OMSCHR") = DTSSource("F5"
Main = DTSTransformStat_O
End Functio

Thanks in advance

Dan Neleman

Does this article give you any pointers?

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.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Danny Neleman | Eye2i" <d.neleman (AT) eye2id (DOT) nl> wrote

tried to <ignore> the ID-field but with the conversion it won't use auto
increment. Now the wizard reports that BLABLA_ID can't be NULL, cause i'm
ignoring it.