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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-04 : 22:50:05
|
| Blair writes "We're trying to do the following and cannot seem to find any information in the DTS online help that says whether or not it is possible.We have a relational database that contains student information in about 100 different tables. We want to pull out a single student's information, as a row in a fixed width text file. THe information that we and to extract needs to be selected by varying peices of criteria, so it is not able to be done in a single SQL query.We figured that the best way to do this would be to write the majority of the data from the initial query to an Access table and then add the additional information with "Updates" to the existing records.However, DTS does not appear to be able to do updates at all, only appends. Is this correct? Can you steer me to where information on how to do this would be located? Also, if you have another suggestion, I would be very glad to hear it.Here is an example of the different sets of data that we're trying to extract:SELECT ID, FirstName, LastName, SSN, Address, City, ST, ZipCode From StudentData WHERE StuStatus = 'Applicant' This one would get our initial set of data.SELECT ID, TestName, Score, Sub1, Sub2, Date From ScoreData WHERE TestName = 'SAT' This gets a second set of data that needs to be added to the first set. There are about 40 sets of additional data that must be included in the final file." |
|
|
|
|
|
|
|
Updating fields in an Access Database with DTS