I am developing my first package and need load a .xls file into a
table in an Informix database.

Everything looks straightforward except one of the columns in the
primary key of the table is not in the spreadsheet. I need to add a
constant value (a date) in that column. I can not find a way to do
this using a Transform Data Task. What is the best way to accomplish
this?

Any help would be greatly appreciated.
Thanks
David

Hi David,

I'm not a experienced user, however I think that maybe you can create a new
activeX script transformation ( tranformations tab click new), there you'll
set no source column nut a destination column (your date column) now, on this
activeX Script, you should be able to set the destination column to any value
you want.

I would use a global variable to send the date via parameter, but I don't
know if this is need.

Hope I helped ya

Miguel Salles

"David" wrote:

If you want to use a constant then you could easily

Select the destination field in the Transformations tab (Make sure it is the
only one selected

New | Active Script transform

You can then do

DTSDestination("Col Name") = "Hard Coded Value"



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know