I have a pkg that moves data for a specific period (monthly) from a main DB2 repository to our SQL Server database.

It works fine and here is the SQL stmt for selecting results for the appending into target table. Works great with dates hard coded into SQL stmt. I just run the following cmd line...

DTSrun /F J:\Data\Loaders\tbl0210ProviderInq.dts

But, when I replace the dates with Global Parms like this

SELECT * FROM KDIR0000.KTIR0210_PROV_INQ WHERE (KDIR0000.KTIR0210_PROV_INQ.CORP_RECD_DATE Between ? And ?);

everything goes to hell. It blows up because the parms aren't being processed properly and so the result set it tries to append is empty. Boom.

My gobal parms are set in order, startdate: datetype value:1/1/2000and enddate: datetype value:1/1/2000

This is the command line trying to run it!
DTSrun /F J:\Data\Loaders\tbl0210ProviderInq.dts /A startdate:7="8/1/2003" /A enddate:7="8/31/2003"

I can't find ANY info about passing dates! Help.

Thanks



DTSrun /F J:\Data\Loaders\tbl0210ProviderInq.dts /A startdate:7="d{'9/1/2003'}" /A enddate:7="d{'9/14/2003'}"

I'm trying to figure out why nobody's taken a shot at this is it too easy and already been covered? If so, where, cause I haven't found it. The std use documentation is not accurate because it does not work and there is no documentation on the solution. Is it because it does not work at all or is there a special process to apply to use it?

Hi,

try to use ISO date format yyyy-MM-dd.

http://www.iso.ch/iso/en/prods-servi...esandtime.html

Regards,

Nuno