Dear all,
I am writing a SSIS package which own an ActiveX Script Task (Visual Basic
Script code incide) but I haven’t idea or any clue about how do I set up
global variables.
Something like that:
Dim strIdioma
strIdioma = DTSGlobalVariables("strIdioma").Value
…
property “Script” allows me paste any snippet of code but then I don’t know
how to link my variables before created.
On the other hand "Script task" allows only to introduce Visual Basic .Net
and then design by Visual Studio.
Any comment would be very appreciated.
Regarding SSIS
Hot Topic
- SSAS 2005, 'Process' object command error in XMLA
- INSERTs given me the BLUES
- KPI - Sales Trend
- AggMerge_ .TMP files eat my harddisk
- Machine name and 'localhost' work, but local and . don't
- Error on security property page
- Login failed for user '<<domain>>\<<server>>$'.
- instawdb.sql runtime errors
- Error Message 443
- Setting Passwords In Connections Using Script Task
SQL Server
- Schedulling Jobs on SQL 2005
- Execute installation script.
- Replication to IP addressed server
- RS in SQL Server 2005 Express?
- Poorly written assembly and CLR
- Full text indexing question
- SQL installation Error...
- Creation name for ComponentMetadata
- Need Help - Local Synchronization Between SQL Mobile and Local SQL Database
- Solve order
Regarding SSIS
jtweku
ActiveX Script is solely there to support migrated DTS packages and even then it probably won't do what you want because SSIS and DTS are such different beasts. e.g. DTSGlobalVariables collection does not exist in a SSIS package.
I'm afraid its time for you to educate yourself in VB.Net and use the Script Task. Take it from someone that has been thru the same pain - it isn't that hard! Short term investment in learning a new technology will result in long term gain!
-Jamie
johnny_no1_boy
I am afraid that you are right..
Thanks for your advice