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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  DTS Package and Execute SQL Task

Author  Topic  Bex Aged Yak Warrior 580 Posts Posted - 2005-12-30 : 05:05:11 Morning all I have a DTS package that daily drops and recreates a test database. The schema is stored in source control, however, everytime the schema is updated, I also have to update the script in the SQL Task in the DTS package. Is there a method/script that will point to the file in source control and generate the DB using the schema stored in that location??? Thanks in advance Hearty head pats