Populating From & Thru Date Global Variables
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
What's the best way of populating the From and Thru date Global Variables for
a DTS to use as parameters in extract queries?
.
Relevant Pages
- Re: Multiple text files to multiple tables
... > That's for bulk insert but if you really want to usr dts you can do a similar thing setting a global variable using dtsrun then using a dynamic properties task to set it as the source file. ... These subsequent SQL tables will then be queried to ... The batch file passes Global Variables to a DTS package that first ... .txt file to the staging table which works well. ...
(microsoft.public.sqlserver.dts) - Re: Transform Data Task, parameterized SP: "No value given for one or more required parameters&
... Global Variables and SQL statements in DTS ... > exec ap_ds_getstagingdata 141, 'Points'> ... > The global variable ConversionID *is* defined, and has a default value> of 141. ...
(microsoft.public.sqlserver.dts) - Re: DTS issue....please help!!
... > Allan Mitchell MCSE,MCDBA, ... > www.SQLDTS.com - The site for all your DTS needs. ... >>> Global Variables and Stored Procedure Parameters ... >>> SET NOCOUNT ON ...
(microsoft.public.sqlserver.dts) - Re: Results in email
... You can then use this article to extract them into Global Variables ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... I have a number of SQL updates that I have setup as Execute SQL Tasks. ...
(microsoft.public.sqlserver.dts) - Re: DTS issue....please help!!
... Also the DTS package correctly assings a value to the ... > Global Variables and Stored Procedure Parameters ... >>I have a stored procedure that does a qc check on 2 tables. ...
(microsoft.public.sqlserver.dts) |
|
