SSIS: Unable to execute web service task

del.icio.us Tags: TECH,SSIS

Error Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not generate the proxy for the specified Web service. The following errors were encountered while generating the proxy: Source file 'C:\Windows\TEMP\xyz.cs' could not be found . No inputs specified

Solution Make sure that the account that the job is running under (the proxy account) has permissions to C:\Windows\TEMP.

Source http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3249cb4e-00ea-419b-be90-d47394630673

64bit ODBC Driver

Scenario: Consume MySQL data in a report or in a SSIS package

- Install 64bit version of ODBC driver

- Create a User/System DSN on the machine

- Use the DSN in place of Buid Command

SSIS Package on 64 bit machine

debugging

http://blogs.msdn.com/amitlale/archive/2007/12/11/ssis-64-bit-setting.aspx

For the SSIS packages that really don't make use of the 64-bit processor, the SSIS project property Run64BitRuntime can be set to False. This is a instruction to load 32-bit runtime environment rather than 64-bit, and your packages would still run without doing any plumbing work. The property can be found under SSIS Project Property Pages -> Configuration Properties -> Debugging.

Run as SQL Agent Job

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

JobType: Operating system (CmdExec).

Package Path: "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

Other Links

http://bi-polar23.blogspot.com/2008/06/ssis-and-sql-server-agent-choosing.html

http://www.sqlservercentral.com/Forums/Topic541317-148-1.aspx

http://msdn.microsoft.com/en-us/library/ms141766.aspx