dbTalk Databases Forums  

How to edit package which was created by Import and Export Wizard

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How to edit package which was created by Import and Export Wizard in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Samuel Bai
 
Posts: n/a

Default How to edit package which was created by Import and Export Wizard - 01-25-2006 , 04:51 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


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: How to edit package which was created by Import and Export Wizard - 01-25-2006 , 06:19 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

Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.