Hi all,

I have a DTS which has a text file (source) which transform data to a table
'IMPORT' in my database. It is a very simple operation: the text file has
only one field and it goes in one column 'import_record' of the table. Now
this table has another column 'import_type' for which i want to set a value
in the DTS. This value can be a result of an SQL statement or it can be just
a hard-coded number like 1. How can I do it? Please help

Thanks

JY

I presume when you say "This table" that you mean the destination.

In an ActiveX transform have a Global Variable map to the destination
attribute i.e.

DTSDestination("ExtraCol") = DTSGlobalVariables("MyVar").Value

You can then assign your static value or result from a Query to the Global
Variable

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"J Y" <jy1970us (AT) hotmail (DOT) com> wrote