I’ve been dabbling with SQL 2005 a lot these days and two features impress me: SSIS and Reporting Services. You might find it difficult to actually deploy a SSIS package. I’m missing something with calling a web service in SSIS… Even when you change the connection manager setting for the HTTP Connection manager to a new value (say we deploy to a live environment), it still reads the WSDL file you provided and calls the wrong web service (Ethereal is the coolest network tracing tool ever btw. [Read More]
sql  ssis