p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Regarding DTS problem


Message #1 by "Ashis choudhury" <ashis_choudhury@y...> on Wed, 12 Jun 2002 06:38:19
Hi
I am a student currently working in a data warehousing project .my problem 
are as follows. 
1. I have one flat file & one sql data base table, I want to extract 
conditional data from those two to a destination sql table without using a 
temp table. i.How can i do this job?
                
            ii.	How can we do this by applying Lookups in SQL Server 2000?

2.	How to implement ?Surrogate keys? for DTS (Data transmission 
Services ) in SQL Server 2000.



3.	How are additive and non-additive measures are defined in analysis 
services?

4.	How are numeric and non-numeric measures are defined in analysis 
services?

If anybody have any ideas regarding my above problem please 



  Return to Index