November 13, 2012 at 6:58 am
Hello everybody,
I need someone to point me in the right direction:
We are in the process of converting SSIS packages from 2005 to 2012. Some of them have ActiveX scripts in them and when converting them over they fail. (I have no experience with SSIS yet).
I see there is a Script Task in SSIS 2012 and I am thinking I have to rewrite the script in .NET? Is this the only option?
My question is what options (I am sure there is more than the above mentioned one) I have to upgrade ActiveX Scripts? Time is realy tight too. 🙂
Thank you!
November 13, 2012 at 9:47 pm
You'll need to rewrite the functionality. Exploring .NET Script Tasks is a good place to start.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 13, 2012 at 11:42 pm
ActiveX was present in SSIS 2005 and 2008 to support legacy DTS. You could convert DTS into SSIS and the ActiveX would still be there. However, DTS is removed in SQL Server 2012 and thus ActiveX as well.
The idea is that logic should now be incorperated in the Script Tasks, as opc.three mentioned.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2012 at 8:12 am
Thank you for confirming this.
Do you know if there is a way to get a list of all packages which have an ActiveX Script Task?
I have hundreeds of packages I need to move, some of them with ActiveX -- I it would be easier to identify them first and prioritize them.
Thanks!
November 14, 2012 at 11:58 am
Indeed there is:
SELECT [name] AS SSISPackageName
, CONVERT(XML, CONVERT(VARBINARY(MAX), packagedata)) AS SSISPackageXML
FROM msdb.dbo.sysdtspackages90
where CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), packagedata)) LIKE '%ActiveX%' --'%sub main()%'
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70011/
September 3, 2013 at 11:09 pm
...or run the SQL Server 2012 Upgrade Analyser against your SSIS packages 😀
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply