Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS package errors; HELP!

Author  Topic 

madhornist
Starting Member

1 Post

Posted - 2007-02-07 : 08:46:04
I'm a LAMP guy who's stuck with some SQL boxes.

I've got VS figured out enough to create my import packages from some flat files I'm getting off our Mainframe.

When I execute the packages in the designer I get a lengthy log, finishing with the following error:

DTExec: The package execution returned DTSER_FAILURE (1).

I know:

1. SSIS service is installed and running on the box
2. My user ID has dbo role access to the database I'm trying to access.

Can anyone offer some insight? (more extensive error logs available, if it would help).
   

- Advertisement -