2nd May 18:18
DTS:- Create a Text file in RunTime
Is the format of the file constant ?
Is the format of the database table constant ?
If yes then you can have SQL Server DTS do this relatively easily.
You would build the package once in designer and if you need to change the
connection names you could pass those into the package at runtime.
If you need everything to be dynamic then it could be more problematic as
you would basically need to redefine the package each time. To see a lot of
the work involved with that but also to give you ahead start try saving a
package as a VB .bas file from designer and have a look
Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org