sql server dts: I'm getting the following error when I tried to run a dts under 2005. (I did
get the sql server 2000 dts designer components downloaded)-CANNOT INSERT THE
VALUE NULL INTO COLUMN 'ID' COLUMN DOES NOT ALLOW NULLS. We have the ID as
an identity, so there is always values. What should I do, to get this to run?
Also when I put the DTS in the legacy directory, and run the migrate is this
converted to 2005(ssis)?
thanks

Hello Sue,


In DTS do you have a mapping going from a source column to this identity
column. You shouldn't

Have a look here

http://www.sqldts.com/293.aspx


In SQL Server 2K5 DTS packages are kept in sysdtspackages (as they were in
2K)

You can import packages into there by going to

Management | Legacy | Data Transformation Services

Right click on this folder and choose to "Import Package File"

If you migrate a package to 2K5 then you migrate it but simply importing
the package into this folder does not upgrade it to 2K5

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]