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 |
|
asf
Starting Member
7 Posts |
 Posted - 2011-02-08 : 23:03:47
|
| Hi,I have to migrate the Activex scripts in the workflow properties of the DTS tasks in the DTS packages to SSIS. Has any one does this before. I think in Dts we can use the active x scripts in workflow properties, but how can I do the same in the SSIS 2008.I do not see the workflow properties option in SSIS.What is DTSGlobalVariables.Parent equivalent in SSIS?And also how can I pull the precedence task name in SSIS. For example in DTS 2000 we call the precedence task name using oPkg.Steps("DTSStep_DTSname").TaskName. But how can i do the same thing in SSIS script task (VB.net code).Thanks a lot. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-08 : 23:10:01
|
You can use script tasks and do some coding around the workflows, and you can set precedence in the workflows using expressions and variables. You can easily apply .net code to the script task and do some of the same functionality...but SSIS is way more powerful and involved than DTS was.The DTSGlobalVariables.Parent equivalent is a Variable scoped to the entire package. You can use variables in workflow tasks via Expressions.Let's say you have a file path that changes, and you need the flat file to look at that path for the source. You would set the flat file connection and define everything for that first, once set, you can change the properties of that flat file connection to use the defined variable for the path via an expression.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
asf
Starting Member
7 Posts |
Posted - 2011-02-10 : 10:28:36
|
| Hi,Thanks you for the reply.I plan to use an execute/script task in the event handler (with condition "on post execute"). But I will still need the task name and the result of the task success/failure to log into a table. So, how can I pull in the name of the main task(which contains the event handler) and its results into the the event handler so that it can log into the table sucessfully.I do see a system variable called "taskname" but when i am using it in the event handler it is giving the name of the event handler and not the main task. Also, I need a way to get the results from the main task . But Iam still not successfull in doing so. Any ideas will be helpful. |
|
|
|
|
|
|
DTS workflow properties