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 |
|
hezviz
Starting Member
3 Posts |
 Posted - 2007-08-03 : 15:04:43
|
| Hi there. This is only my second post ever- so please bear with me. First, I am using SQL Server 2000. I have built a DTS package using an Oracle ODBC and the following query;select pv.segment1 vendor_nbr, pv.vendor_name,pv.attribute4 , pv.creation_datefrom po.po_vendors pv, po.po_vendor_sites_all pvswhere pv.vendor_id = pvs.vendor_id(+)operating unit AND trunc(pv.creation_date) = trunc(sysdate)This DTS package is not always run on the same day the records are created. So......What I want to do is have the dts package ask the user for the date they are looking for-I know I need to probably use a parameter, but I have been unable to figure out how to do this in a DTS pkg. I have several reSQL reference books and I don't even know what to search for in Books online. Could anyone help??ThanksHeather Vizina |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
|
|
|
|
|
request for data input in a DTS Package