Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-06-30 : 14:29:15
|
| i am new to DTS active x scripting .i have to write a script to move only 2 columns from a text file(source)to an table in the database(destination)one is date column and another is integer column.can any of you tell m ehow to write a script for that.thanks in advance |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-06-30 : 17:58:51
|
| You should be able to do this without ActiveX scripting. If you're new to DTS, you can use the inbuilt wizards to do the job for you. From Enterprise Manager, select Tools --> Data Transformation Services --> Import Data.HTH,Tim |
 |
|
|
|
|
|
Active X Script