I have built a custom SSIS component for connecting to SQL Reporting Services in SSIS - including a custom data source and custom connection.
It works fine using 32bit DTEXEC and dtsdebughost, but I cannot get it to load in a 64bit environment.
Initialy I was compiling the dlls as MSIL (target=any), then I recompiled specifically targetting x64 (copying the dlls to the 64bit location and deploying to the GAC), just to see whether the problem was because of using an MSIL binary.
The 32bit version works as expected - are there any additional registration steps required for a 64bit Connection manager beyond copying to the /connections directory and installing into the GAC?
The output from DTSEXEC:
c:\Program Files\Microsoft SQL Server\90\DTS\Binn>DTExec.exe /f "e:\temp\SSISCus
tomADComponent\TestSSISSolution\Integration Services Project1\Package.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:07:30 p.m.
Error: 2010-09-22 12:07:43.89
Description: The connection type "SSRS" specified for connection manager "SQL
Server Reporting Services" is not recognized as a valid
View Complete Post