Sailor (1/29/2009)

---

I saved a package in BIDS onto a server database. In BIDS, when I try to open the package, I get msdb does not exist. Another database...

henkvisser (1/29/2009)

---

I'm using one main package to execute several other sub-packages. The audit problem is in a sub-package. When a step fails it doesn't execute the on failure step in...

Congratulations! I'm glad to be a part of the best SQL Server site on the web.

What's funny about this thread is if the OP and the people...

What you need to do is add an "on failure" workflow to each task and have it point to a task that does the audit table insert. Then when...

This is getting old.

clperez, can you open the DTS package in DTS Designer?

There's a free tool available here: http://www.sqldts.com/242.aspx that I like for copying a lot of packages at once.

Members of db_ddladmin can run DDL commands in the database so they can create objects (tables, views, stored procedures). It's a bit more restrictive than db_owner which can do...

I'm not sure what your question is. I think you're saying you've created a package (SSIS, not DTS) and you want to know how to deploy it to a...

Gail's right. DTS does not log by default, either to SQL Server or to a file. Logging must be enabled in the package.

He's trying to figure out...

A DTS package will only log execution messages in sysdtspackagelog if you've enabled logging in the package itself. If there's no data in sysdtspackage log, it's probably because you...

You can get the info you need from the sysjobs and sysjobhistory tables in msdb. Look at the sp_help_jobhistory stored procedure to see how it selects the info. ...

It may be that, if you're using Windows authentication in the SMTP Connection Manager in the package, the SQL Agent account doesn't have access to the pdf files. Check...

You're welcome. Pay it forward.:)

Brian Knight also has a product that is advertised to migrate all packages in an instance. http://www.pragmaticworks.com/dtsxchange.htm

I haven't tried it, but I've read the specs and may try the free...