You can definitely use SSIS to connect to different databases. We pull data from SQL, Oracle, DB2, and Informix. You can even utilize SSIS without using SQL as a source...

This is not a trigger to require a WHERE clause. It is a trigger that will require some filtering. However, you can also do a DELETE TOP 1000. A couple...

Thanks. Once I turned off all of the validation and ignored the error worked fine. Appreciate the help.

That's what I was afraid of. I had tried that. Mine seems to be more on the ODBC side of things that SSIS doesn't like.

I can connect and return...

Just trying to see if anyone has found a solution to this. I am also trying to update a package to run on a Windows Server 2008/SQL Server 2008 64-bit...