Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2003-02-26 : 14:57:54
|
| How can I add VB language to it?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-26 : 15:18:06
|
| It would have to be VBScript. You can't Dim variables of a particular type, for example, or objects as instances of a class. You'd have to use CreateObject() to create a new object in an ActiveX task. There are a few other things to look out for, but usually this is the only thing you need to worry about when converting VB to VBScript. |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2003-02-26 : 15:20:02
|
| I was just wondering because BOL says that you CAN install OTHER languages like VB. Here is the article.ActiveX Script Task PropertiesUse this dialog box to specify the code that will perform the functions you need to customize your Data Transformation Services (DTS) package (for example, skipping a row of source data that contains invalid data).OptionsDescriptionSpecify a description for the Microsoft® ActiveX® Script task. This description becomes the label for the task icon placed on the DTS Designer design sheet.Language tabThis tab lets you specify the scripting language and the functions to use in the ActiveX script. Language Select an available scripting language. When you install scripting languages on the computer, this list will update automatically. Microsoft Visual Basic® Scripting Edition (VBScript) and Microsoft JScript® are available by default.Functions Select a function from the script language library to be placed into the ActiveX script text box. Double-clicking on a function name inserts the function code into the text box at the position of the cursor.Entry Function Specify the name of the function that will be the entry point when the script runs. Only one function can be specified as an entry point for an ActiveX Script task. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-26 : 15:58:40
|
| You can use SCRIPTING languages. VB is a compiled language. VBScript is the scripting version of it. |
|
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2003-02-26 : 15:59:43
|
quote:
You can use SCRIPTING languages. VB is a compiled language. VBScript is the scripting version of it.
Gotch ya, thanks |
|
|
|
|
|
|
Adding Scripting Language To ActiveX Script Task