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 |
|
jgrimmer
Starting Member
2 Posts |
 Posted - 2006-09-05 : 12:38:55
|
| I'm fairly new to MS SQL Server. We have a legacy system that creates an extract (flat text file) weekly. This extract is loaded into a table on MSSQL 2000. I've inserted a column into a table (an example is below): Old Table Columns New Table Columns ----------------- ----------------- Field1 Field1 Field2 Field2 Field3 Field3 Field4 Field4 Field6 Field5 <--Note new field inserted Field6Now I need to update the DTS to reflect the table change. The DTS is used in an existing job via a DTSRun command. What I want to do is modify the DTS without having to modify the job that runs it.In the past the way I've modified a DTS when I want to use it in a job is to just create a new one from scratch, schedule it as a job, then copy the DTSRun command from the new job to the old job, then delete the new job.What I want to do is just open the existing DTS and modify it and have the modified DTS run in the job with no changes. Is this possible? If so, how do I do it?Thanks,Jerome |
|
|
jgrimmer
Starting Member
2 Posts |
Posted - 2006-09-05 : 12:40:37
|
| Rats. That did not display the way I wanted. What I'm doing is inserting a column between Field4 and Field6, calling it Field5.-Jerome |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-05 : 12:57:47
|
| put [ code ] and [ /code ] around the text you want in columns (no spaces in the tag).Peter LarssonHelsingborg, Sweden |
|
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-09-05 : 13:22:55
|
quote:
Originally posted by jgrimmer
Rats. That did not display the way I wanted. What I'm doing is inserting a column between Field4 and Field6, calling it Field5.-Jerome
Why should you change the job, just change and save the dts package. as long as you dont rename the package or move it to a new server, it should be fine.________________________________________________I am a man, I can change, if I have to, I guess. |
|
|
|
|
|
|
|
|
Modify DTS that is used in job w/o changing job