sql server dts: DTS Import/Export -- sql server dts

DTS Import/Export

Aaron
2/20/2004 1:09:05 PM

sql server dts:

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,

Can't see your message

Aaron
2/20/2004 5:20:09 PM

Hi Allan,

What was you message? I can't see what you had typed.....
[quoted text, click to view]

Re: DTS Import/Export

Allan Mitchell
2/20/2004 9:18:23 PM

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

[quoted text, click to view]

Re: Can't see your message

Allan Mitchell
2/21/2004 7:52:31 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.