Hi, I want to 'translate' this ActiceX script to a regular SSIS scripttask: Function Main() Dim oVal Dim isSystem, varType, varName Dim str MSGBOX "Total Variable = " & DTSGlobalVariables.Count For each oVal in DTSGlobalVariables isSystem = oVal.SystemVariable varType = oVal.DataType varName = oVal.QualifiedName MSGBOX varName & " / " & varType & " / " & "System:" & isSystem Next Main = DTSTaskExecResult_Success End Function Any suggestions? Regards H.

1. Double click the Stript Task to open the Script Task Editor. 2. Select Microsoft Visual Basic 2008 in the ScriptLanguage list box (not necessary for SSIS 2005) 3. Click Edit Script. 4. Paste your code under Public Sub Main() BTW, it appears that your missing the As clause in the variable declarations and a declaration for DTSGlobalVariables. CarlaCarla Sabotta

Hi, Check this article on the converting the ActiveX to Script task transformation. Hope this will be useful http://pragmaticworks.com/help/dtsxchange/scr/ActiveX%20Script%20Task.htmThanks Karthikeyan Anbarasan http://f5debug.net/

Also check this article on the ActiveX Script task usage in SSIS http://beyondrelational.com/blogs/vishalpawar/archive/2011/08/28/msbi-26-ssis-13-control-flow-tasks-8-activex-script-task.aspxThanks Karthikeyan Anbarasan http://f5debug.net/

Hope this article as well helps you to get some clear idea on the ActiveX script task http://beyondrelational.com/blogs/tejas/archive/2009/10/30/sql-server-ssis-activex-task.aspxThanks Karthikeyan Anbarasan http://f5debug.net/