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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2007-03-31 : 10:57:24
|
| Hi guys,THanks for taking time to comming to this thread and any suggestion is appreciated.We have clients databases with HR data in sql server 2000. Presently, we use DTS packages (every client has his own package) to update their HR feed every month. What should be the best practice so that burden is minimized from our data-team? The file format sent by the clients are usually text files, but the columns may differ per clients' need. However, the database structure for all clients are same. Any suggestion on this is greatly appreciated.Thanks,SB |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-03-31 : 11:05:57
|
| First, I would get far away from DTS.Second, I would require feeding systems to have a standard formatin lieu of that, I would set up bcp's specific to each feed inot a staging tableThen I would do what ever was left...DTS is a pig as well as any ETL tools that are out thereBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2007-03-31 : 11:10:09
|
| Thanks Brett and sorry for the question format. |
|
|
|
|
|
|
Automate Process