 | |
RE: dynamically changing datapump sourcesqlstatement
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
RE: dynamically changing datapump sourcesqlstatement -
07-07-2004
, 03:34 PM
|
I have a datasource in a data pump for which I wish to dynamically change the source SQL statement. Would the following active-x task code snippet work or is there a better way? Dim oTask Set oTask = DTSGlobalvariables.Parent.Tasks("DTSTask_DTS_Mytas kName") oTask.SourceSQLStatement = "SELECT * FROM AUTHORS" Thanks, Tom |
#2
| |||
| |||
|
|
Ok, well I'll partially answer my question here... Everything works great if I use a dynamic properties task to accomplish this, but, I would like to know how to properly do this in an active-x task. If anyone knows, I would appreciate your reply. Thanks, Tom "Tom" wrote: I have a datasource in a data pump for which I wish to dynamically change the source SQL statement. Would the following active-x task code snippet work or is there a better way? Dim oTask Set oTask = DTSGlobalvariables.Parent.Tasks("DTSTask_DTS_Mytas kName") oTask.SourceSQLStatement = "SELECT * FROM AUTHORS" Thanks, Tom |
Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
|
« 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.