Unable to import or export data on SQLserver 2005 and 2008

#31

2005:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log

2008:
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

Summary.txt lists the over all status; then you can look at each Log file as
per summary to see what is going on. Importing and Exporting is most likely
in the SSIS (Integration Services) update.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"Andy" wrote:

Quote:

Thanks for the reply Mohit,

Where would I find the install log files please?

Cheers,

@

"Mohit K. Gupta" <mohitkgupta (AT) msn (DOT) com> wrote in message
news:C6F95B2C-AFD7-4C0F-98D5-12D96CD83E42 (AT) microsoft (DOT) com...
Windows Vista ... Really a inconvient when installing SQL Server products
on
the computer.

At least it has been for me so far; I would try to install the product
with
the UAC turned off and install it as Local Administrator to see the
results.

When installing SQL Server 2005; did you by any chance install SP2?
Either
way I would look at the install logs to see if some components were missed
or
not installed at all.

SQL Install can come back successful; but the some components could still
have been missed. Sorry I am dealing with that right with Microsoft; I
still
don't have a solution to it...

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"Andy" wrote:

Hi there,

Hope someone can help me out here. I've had a long running problem with
SQLserver 2005 (Standard, Developers and Express).
When I try to import or export data to or from a database I get the
following message:

TITLE: SQL Server Import and Export Wizard

The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll
is
available and registered. The wizard cannot continue and it will
terminate.

ADDITIONAL INFORMATION:

Cannot create a task with the name "STOCK:PipelineTask". Verify that the
name is correct.
({1A768FBA-F8F7-4147-B1CD-2953FAC6781E})

Yesterday I totally uninstalled 2005 and installed SQLserver express 2008
(with tools), after installing .NET 3.5 sp1, Visual Studio 2008 sp1 and
all
the other stuff you need to install beforehand.

Come to try and import again, and get the same problem.

Arrrrrrrrrrrrrrrrrrrrrrrrrrrr............!!!!!!!!! !!!!!!!!!

I'm running Vista Ultimate if that makes any difference.

I would greatly appreciate any assistance at all.

Cheers,

@ndyB

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Unable to import or export data on SQLserver 2005 and 2008

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Unable to import or export data on SQLserver 2005 and 2008 - 09-26-2008 , 08:56 AM