Posted by Ben on 02/28/07 14:54

We currently use SSIS to build DTS packages in which we store changes
to our database schema, as well as scripts that need to be run upon
each release. This works well for small sets of changes that never
need to be updated or for architectures with only one database.

We store each of the changes included in the package in separate
files, which are tracked using version control. It is growing time
consuming to maintain parity between those files and what is in the
SSIS.

Furthermore, we have been unable to discover an easy way to load a
file's contents into a package SQL Task without opening the file and
copy-pasting the contents into a new SQL task.

ANY information at all would be extremely appreciated!

• Next in forum: Stored procedure to create a new database with tables
• Prev in forum: Need help with CONVERT function
• Thread view: Does anyone use SSIS for database schema maintenance?

[Reply to this message]