User-Friendly Package

[Jozopiso]

Hi Everybody.
I need to make user-friendly interface in the beginning of execution of package. It have to be something like dialog box with one switch how package should works. After click "Execute" it starts another MSG BOX like "You want to replace security tables" with only two chances "Yes" or "No". I dont know how can i make it, how should i call those variables from package.

Appreciate

jozef

 

[gradley]

You can use a MsgBox or an InputBox in an ActiveX task using VBScript.

Based on the response from the user, you can set Global Variables that control whether to perform a function. Here's an example using an Input Box

'**********************************************************************
'  Visual Basic ActiveX Script
'************************************************************************

Function Main()
Dim  strYesNo 

	strYesNo = InputBox ("Delete Files", "Prompt User", "Yes")

	If strYesNo = "Yes" then
		'  Set global variable used to delete files..
	End if
	Main = DTSTaskExecResult_Success
End Function

 

[Jozopiso]

Thanx gradley,
i need to begin this package with this message and declare this variables in the beginning of package:
................
declare @SecuritySettingsReplace bit
set @SecuritySettingsReplace=0

if (@SecuritySettingsReplace=1)
begin

DELETE FROM SecurityAccessRights
DELETE FROM SecurityObjects

SET IDENTITY_INSERT SecurityObjects ON
insert into securityobjects(ID_Object, ObjectName) values(44, 'IDRank');
insert into securityobjects(ID_Object, ObjectName) values(45, 'IDSkill');
insert into securityobjects(ID_Object, ObjectName)
..........
But this switch is useable in the middle of the package. I'm asking because there is a high hierarchy of this package and i need to declare this switch in the beginnig and using in the middle.

Appreciate

jozef