471,084 Members | 1,024 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

Help on DTS and selective dates

B
Version: 7.0

I have created several packages that will export data from MySQL to
SqlServer. But user have control on which dates to process, it could be one
range of date or multiple range of dates. The dates are stored on separate
table on sqlserver called "tblMySQlDates". Below is sample structure:

from_date to_date
1/1/2003 4/30/2003

or

from_date to_date
4/1/2003 6/30/2003
8/1/2003 12/31/2003
etc..

Is it better idea to create table also on MySQL to store the dates? I do not
have access to this server, only data. I will need to ask the database
administrator. Or is it better to assign global variables from vbscript to
accomplish above? How?

Thank you.
Bob
Jul 20 '05 #1
0 874

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ian DeRock | last post: by
2 posts views Thread by Bobby Maul | last post: by
6 posts views Thread by vili | last post: by
4 posts views Thread by Steve Chow | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.