 | |
looping, importing
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
looping, importing -
02-22-2005
, 04:25 PM
#2
| |||
| |||
|
|
I downloaded a sample package from sqldts that is exactly what I needed - http://www.sqldts.com/default.aspx?246. I have one question about it, and ActiveX tasks in general. In step 6, it has the loop returning to "set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")". How do I know what step number (e.g. DTSStep_DTSActiveScriptTask_3) my task is? Mine don't have names like this, they have more descriptive names. I tried changing the above to my step's name, but it didn't work. Thanks, Andre |
#3
| |||
| |||
|
|
Right click a task at take a look at workflow properties, this where the nae is visible. You can cut and paste directly from the tabbed dialog "Andre" <no (AT) spam (DOT) com> wrote in message news:%233zpG2SGFHA.2032 (AT) tk2msftngp13 (DOT) phx.gbl... I downloaded a sample package from sqldts that is exactly what I needed - http://www.sqldts.com/default.aspx?246. I have one question about it, and ActiveX tasks in general. In step 6, it has the loop returning to "set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")". How do I know what step number (e.g. DTSStep_DTSActiveScriptTask_3) my task is? Mine don't have names like this, they have more descriptive names. I tried changing the above to my step's name, but it didn't work. Thanks, Andre |
#4
| |||
| |||
|
|
Right click a task at take a look at workflow properties, this where the nae is visible. You can cut and paste directly from the tabbed dialog "Andre" <no (AT) spam (DOT) com> wrote in message news:%233zpG2SGFHA.2032 (AT) tk2msftngp13 (DOT) phx.gbl... I downloaded a sample package from sqldts that is exactly what I needed - http://www.sqldts.com/default.aspx?246. I have one question about it, and ActiveX tasks in general. In step 6, it has the loop returning to "set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")". How do I know what step number (e.g. DTSStep_DTSActiveScriptTask_3) my task is? Mine don't have names like this, they have more descriptive names. I tried changing the above to my step's name, but it didn't work. Thanks, Andre |
#5
| |||
| |||
|
|
You can also right-click anywhere on the design surface and select "Disconnected Edit". From there you will be able to see all of the task names. Regards Jamie Thomson An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx "Paul Smith" <paul (AT) spamno_sagestore (DOT) com> wrote in message news:O1MGwCTGFHA.3792 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Right click a task at take a look at workflow properties, this where the nae is visible. You can cut and paste directly from the tabbed dialog "Andre" <no (AT) spam (DOT) com> wrote in message news:%233zpG2SGFHA.2032 (AT) tk2msftngp13 (DOT) phx.gbl... I downloaded a sample package from sqldts that is exactly what I needed - http://www.sqldts.com/default.aspx?246. I have one question about it, and ActiveX tasks in general. In step 6, it has the loop returning to "set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")". How do I know what step number (e.g. DTSStep_DTSActiveScriptTask_3) my task is? Mine don't have names like this, they have more descriptive names. I tried changing the above to my step's name, but it didn't work. Thanks, Andre |
#6
| |||
| |||
|
|
You can also right-click anywhere on the design surface and select "Disconnected Edit". From there you will be able to see all of the task names. Regards Jamie Thomson An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx "Paul Smith" <paul (AT) spamno_sagestore (DOT) com> wrote in message news:O1MGwCTGFHA.3792 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Right click a task at take a look at workflow properties, this where the nae is visible. You can cut and paste directly from the tabbed dialog "Andre" <no (AT) spam (DOT) com> wrote in message news:%233zpG2SGFHA.2032 (AT) tk2msftngp13 (DOT) phx.gbl... I downloaded a sample package from sqldts that is exactly what I needed - http://www.sqldts.com/default.aspx?246. I have one question about it, and ActiveX tasks in general. In step 6, it has the loop returning to "set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")". How do I know what step number (e.g. DTSStep_DTSActiveScriptTask_3) my task is? Mine don't have names like this, they have more descriptive names. I tried changing the above to my step's name, but it didn't work. Thanks, Andre |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.