sql server dts: Hi all,

i have a dts package that exports to an excel file, but the name of the
excel file is defined at runtime. this is not a problem as i define the
destination table for the excel file in the data transformation task before
running the package.

is there a way using vbscript to define the destination table name in a data
transformation task?

i am using sql server 2000 sp4.

any pointers or white papers would be appreciated


Simon Whale

Hello Simon,

The destination table can be defined using the DestinationObjectName property
on the Transform data task. You can dynamically create the table against
the XL connection manager using an ExecuteSQL task and a CREATE TABLE statement.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]