sql server dts: Hi, All,
I want to edit a package was created by sql server Import and Export Wizard.
It did run great before. but I found there are some files or
innerpackage.dtsx were missing which were located at temp folder later.

this package just do copy data between two database. I want to add some
tasks based on this package, but I can not find any files in temp folder.

another thing I found that Insert Identity always fail by using Imp and Exp
Wizard,
even I checked "Enable identity insert" box, if it uses tableschema.xml loop
through.

Is there any one can help me?

Thanks in advance

Samuel

Hello Samuel,

OK So you are using SSIS then. How is the package stored that was created
by the Imp/Exp wizard? You can use BIDs to open the package and edit it.

Allan

[quoted text, click to view]