dbTalk Databases Forums  

SQL 2005 Import Export ends with Coping to <blanck> Stopped

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


Discuss SQL 2005 Import Export ends with Coping to <blanck> Stopped in the microsoft.public.sqlserver.dts forum.



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

Default SQL 2005 Import Export ends with Coping to <blanck> Stopped - 07-13-2009 , 03:36 PM






I’m running the Import/Export Wizard from SQL 2005 to export data from
a SQL database to another SQL database on the same server.

I select the option “Copy data from one or more tables or views”, and
in the next screen I select all the tables and none view. The
database has almost 500 tables and over 400 views.

So I run the SSIS package and it runs perfectly but when it ends it
says: “The execution was successful” in the top off the screen.

Above the grid it says
“Success 11 total 0 Error”
“10 Success 0 Warning”

But in the last row of the grid it says “Copying to” in the Action
column and “Stopped” in the Status column.

The View Report window it success to all action but the last one. It
says “– Copying to (Stopped)”

Is that the expected result?

As is says 0 Warning, do I have no reason to be concerned?

Thanks in advance.

Marcolorado

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.