Works brilliantly from SSDT 2012 but not with DTEXEC on the same workstation

Jun 25, 2014 at 2:38 PM
Edited Jun 25, 2014 at 2:41 PM
Hi All,
I am hoping somebody can help me. I am doing a PoC with the SharePoint List adapter. I could get this to work from Visual Studio 2012 (SSDT) designer. However, when I execute the same package from command line using DTEXEC.EXE the error message shown on the CMD console is
Error: 2014-06-25 14:18:03.10
   Code: 0xC000F427
   Source: Data Flow Task SSIS.Pipeline
   Description: To run a SSIS package outside of SQL Server Data Tools you must install SPList001 of Integration Services or higher.
End Error
Here the 'SPList001' denotes the name of my SharePoint List source component on the Data Flow tab

I am aware that SSIS Integration Services is required for things like Script components. Is it a must that I have SSIS Integration Services installed on my workstation?

thanks,
Saurabh
Jun 27, 2014 at 11:24 AM
Problem got solved after running SQL installation with SSIS option ticked.

Regards,
Saurabh
Oct 7, 2014 at 5:11 PM
Hi Saurabh,

How did you get the "SharePoint Source" and "SharePoint Destination" tasks to show up in Visual Studio 2012?

Thank you.

Renan
Nov 21, 2014 at 5:28 AM
Edited Nov 21, 2014 at 5:31 AM
I had simular problem, but with lots of other missed components to make my SSIS packages to be runned remotely. Full installation of MS SQL Server (Select All components from Feature list during the installation) resolved that problem:
__
Install Sql server integration service pack Locally from the setup pack