It could also be a firewall issue. Check the list below.

http://technet.microsoft.com/en-us/library/ms190181%28v=sql.105%29.aspx

Also check the native client version. Depending on the SSIS version you might need version 10.1 instead of...

Don't use the instance name in the SETSPN command. Just make sure the machine name (NETBIOS and FQDN) and port is correct.

This part was giving me some headaches too in...

Always use the fixed roles of MSDB[/url] instead of granting permissions directly.

I believe for job controlling from the SQL Agent you need sysadmin permissions.

Oops I see I am in the...

In addition I found a login trigger example on the forum.

http://www.sqlservercentral.com/Forums/Topic848826-1550-1.aspx

Make sure you understand the concept of server level triggers first before copy-pasting 😉

From where is the package called?

If the SSIS package is called from a SQL Agent job you will need a proxy account to access the SSIS subsystem.

The article below explains...

What is the error you are getting from your package? When coded properly a File Exists in a Script Task shouldn't result into an error.

Maybe you should post the code...

I don't know TSM software. Is this some 3rd party backup software? LOG truncation is an essential feature. Without truncation your LOG files would keep on growing even if a...

I know this is an old topic, but I have the proposed solution. I have contacted Microsoft about this issue and we figured out the solution for this problem.

Install the...

I run into this problem often. Databasename filter is based on the database name specified in the connection Initial Catalog. Maybe you can use a host name or application name...

Just some additional info.

No mails are missing when using CSV as Render method. The message size is about 1 MB per mail when using PDF and seems to be a...

Yes you can span your backup into multiple files. Check the backup database syntax in booksonline.

http://msdn.microsoft.com/en-us/library/ms186865(v=sql.100).aspx/css

Check also this page for an example.

http://www.mssqltips.com/sqlservertip/935/backup-to-multiple-files-for-faster-and-smaller-sql-server-files/

Hard to say as it also depends on your indexes. My experience however is that derived tables can cause performance penalties. As soon as you filter on a derived table...

Well I am also investigating the pros and cons of placing SSIS on the DB server.

http://www.sqlservercentral.com/Forums/Topic1459119-391-1.aspx#bm1459772

I think most of the pro's of putting SSIS on the DB server have been...

Thanks for your feedback. Well it's good to see that my assumptions were right.

I think we have a license for System Center Orchestrator which can handle the scheduling....

An ALTER needs a TABLE lock so you need to work around this.

I usually do it like this.

- First create a duplicate table based on the table that needs to...