Ok my question is somewhat twofold but I will try to kill two birds with one stone. What I'm tyring to do is run a DTS package that is pretty much as follows.
2 DB Connections
1 Text File (Destination)
The 2 DB connections have a data pump in the middle that collects a number of fields by a query and then uses a copy column transformation package to pump the data into the destination table.
That table is then later dumped into the text file at a later time.
My question is:
A) How can I execute this query and dynamically set a portion of the where statement?
-------Example: Select * from table as t1 where t1.id = ?
B) How do I execute the data pump for each record in the recordset that will supply the value for the above parameter in question A?
-Lookup parameter value from recordset
-Execute data pump with value returned from recordset
-Loop through recordset
-Finished remaining part of DTS Package
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.