Insert

[kunai]

Hello,

I'm trying to insert column data using a DTS. I need some ideas.

This page is close but not quite what i'm trying to do. (

http://www.tek-tips.com/viewthread.cfm?qid=910282)

I'm importing data from an access database to sql server 2000. The table is already created in sql server with an extra date column. I want to add a date in that extra column using the DTS. I've tried passing a global variable in an activex script but it's not working.

Any ideas?

Thanks.

 

[kunai]

Forget it, figured out how to use the global variables.
Seems to work fine.