Hi,

As a beginner with DTS, I'd like to know if it's possible to export data
from a sqlserver with a package, but without predefined tablecolumns to
export. I want to build an export module from C# that exports columns the
user has selected (thus at runtime).
The DTS packages I have tried to create, were all predefined and could not
be edited afterwards.

If this is possible, ae there any examples maybe?

Thanks in advance

Yes this is possible but it is not straight forward and not that easy. I
have a package which does something very similar if you want to ping me
offline.

Basically it will involve tearing down the current transformations, adding
back the columns you want to move from and to and then recreating the
mappings between them.

Allan
www.sqldts.com

"TJ." wrote: