I was under the impression DB Mail will only work with SMTP. Is SMTP enabled on the Exchange server and is it set up to accept annonymous connections?

Looks like someone goofed on this one 😉

Dejan,

Is it really necessary to get delegation to work? From my experience and from what I've read here and elsewhere, if there is a reasonable alternative, it does not seem...

I can't help you with the double hop. I'm sure there are many of us who are frustrated with that limitation. If you have some really sharp network people, you...

Where are you running the query from? If it is your desktop, you have the classic "double hop". Try logging onto to one of the servers and run the query....

The debugger still requires sysadmin and unlike previous versions, there are no extended stored procedures to grant execute on. In a lot of environments, sysadmin can't be granted for various...

CU1 was released 9/23 (Tuesday) and brings the version to 10.0.1763

http://support.microsoft.com/kb/956717/

SSMS 2005 can NOT connect to SSIS 2008

SSMS 2008 can NOT connect to SSIS 2005

Thus the need to maintain both sets of client tools

Sorry - I meant to post this when I got it:

From Buck Woody:

No, the SSIS team has a different connection method that doesn’t allow us to connect with SSMS. I...

Create a job with step that uses the type Operating System Command (CmdExec) and schedule it.

This is some code I cut out in pieces from a .Net program I cobbled together. We script out everything on a server every evening for recovery and DR. This...

If you have an environment with more than SQL Server in it, you may need to use linked servers to connect to Oracle, DB2, etc for data.

There is actually a very good article on this site and the author also added few other links:

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2795/

For the source columns that are numeric, you could use a Derived Column Transform in between the source and destination. Change the data type there rather than scripting.

DTS and SSIS sample X number of rows to determine column widths. If the columns in the initial sampling are smaller than a column in later rows, the later data...