Hi,

I have a question regarding an error message when running
a saved DTS package that copies a database through the
Import/Export function. When I run the package, it runs
for a little while. I can see the objects being copied
and while it is copying the table the "Package Result
Execution" window pops up and says 1 task failed during
execution. I then hit "okay" and then it says the for the
status of the Copy SQL Server Objects step that an error
occurred. You click on the error and it says "Bulk Copy
Execution Failed". Is there a detailed reason why this
failed? How do I fix this? I'm trying to figure out what
happened. Any help would be much appreciated!

Thank you,
Aaron

Can you enable logging at the package level

Right click whitespace | Package Properties | Logging

This will hopefully give you a better idea.

--
--

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


"Aaron" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

What was you message? I can't see what you had typed.....

Does this come through

Can you enable logging at the package level

Right click whitespace | Package Properties | Logging

This will hopefully give you a better idea.

--
--

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


"Aaron" <anonymous (AT) discussions (DOT) microsoft.com> wrote