|
Home > Archive > MS SQL Server DTS > January 2006 > How to edit package which was created by Import and Export Wizard
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to edit package which was created by Import and Export Wizard
|
|
| Samuel Bai 2006-01-26, 4:58 pm |
| 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
| |
| Allan Mitchell 2006-01-26, 4:58 pm |
| 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
> 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
>
|
|
|
|
|