Hi All,

I am trying to import data into a table on my SQL Server
2000 SP2 database using a text file source also created
by SQL Server 2000.
I launch the Enterprise Manager Import/Export Wizard and
i go through all the steps for importing the data and as
soon as i click the Finish button to start the import
process the hour glass comes on and about 10 to 20
seconds later the import process crashes and all the
windows including EM closes.
The first thing that came to my mind was may be there
could be something wrong with the text file i am using. I
decided to export data from one of my existing tables
into a text file and see if it works and to my surprise
exporting data to a text file failed too.

I appreciate if someone can help me out and tell my what
could be wrong with my SQL Server 2000 import/export
Wizard.

Thank you so much in advance!

-Mitra

OK so DTS would seem broken. The text file will have little to do with it.
DTS would simply tell you that the import/export failed for reason whatever.

I would have a go at reregistering the DTS dlls.

Does DTS work in Designer?


Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"mitra fatolahi" <mitra928 (AT) hotmail (DOT) com> wrote

Hi Allen,

Thank you for replying to my question.

You asked:
"Does DTS work in Designer?"

After figuring out how to work with the DTS Designer, yes
i was able to import the text data file, that i was not
able to import using the DTS Import/Export Wizard. And I
was also able to export data from a table to a text file
using the DTS Designer which i could not do using the DTS
Import/Export Wizard.

Could you please comment on the difference between using
the DTS import/export Wizard vs. the DTS Designer to
transfer the data? In other words, why would DTS
import/export Wizard fail to transfer the data but not
the DTS Designer?

Thank you very much for your help. Appreciated!

-Mitra

OK so we think the wizard is broken.

I would personally upgrade to SP3 + hotfixes first.

If this does not fix the problem then if you can use the wizard on another
machine against the same files then this would further support the wizard
being broken.

In "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"

there are two files dtswiz.exe and dtswiz.dll.

rename them and then

copy the files in from the box that works.

register the dll

try again.

Do you have anything in Event Viewer on the PC that runs the package?

Try the SP first.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"mitra fatolahi" <mitra928 (AT) hotmail (DOT) com> wrote