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 |
|
amirkatz
Starting Member
5 Posts |
 Posted - 2005-04-11 : 14:32:12
|
| Hello all,I'm building a package using DTS Designer that will generate a FILE that will hold my database stored procedures,exactly the same kind of file that is generated by running the DTS wizard (using "generate sql script").iv tried using "copy sql server object task", but its not working properly - firstly because its enforces me to pick a database under "destination" tab and so its generates the stored procedures in that database and secondly it outputs to the "script file directory" under "copy" tab the desired PRC file along with other garbage files.how can i get rid of these undesired files and avoiding filling up the database with that 'garbage' files?one more question - how can i copy the content of a table using DTS designer? (the same manner used by DTS Export/Import Wizard)Thanks Amir |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-11 : 18:50:56
|
| It would be a much better practice to not do this at all. Procedure code should originate as a file, NOT be created or maintained via Enterprise Manager. Once the source code file is saved, it should be checked in to a source control program like SourceSafe, CVS, etc. There is an excellent article detailing the approach here:http://www.mindsdoor.net/SQLServerReleaseControl.htmAs difficult a practice as this may seem, you will come to appreciate its value, and it's a fairly easy discipline to acquire. It's too easy to use Enterprise Manager to make changes that can cause something to stop running. Doing what you originally asked for will ultimately make code maintenance impossible. |
 |
|
|
amirkatz
Starting Member
5 Posts |
Posted - 2005-04-12 : 03:27:17
|
| Thanks for your quick response.I need to take this approach cause the server I am trying to load files to is an isolated and secured computer.All the files are being transfered to that server from local development environment using diskonkey...My goal is to create a folder for each service im moving to that computer by typing the service number.Could u please help outAppreciate it Amir |
|
|
|
|
|
|
STORED PROCEDURES AND DTS