Results 1 to 3 of 3

Thread: Change the Source and Destination Property

  1. 10-29-2003, 05:43 AM #1
    chuijhk
    chuijhk is offline Registered User
    Join Date
    Oct 2003
    Posts
    5

    Question Change the Source and Destination Property

    Hi,

    I want to use the DTS Designer to do a transformation service. I have a TextFile Source and SQL Server Destination. Then I added a Data Transformation Task between them. Next I want to write the workflow property script to change the Datasource (textFile) and the Destination table(SQL) for import. Any sample around. Please help.

    Regards,

    Jeff
    Reply With Quote Reply With Quote
  2. 10-29-2003, 07:38 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://www.databasejournal.com/featu...le.php/1461661

    http://www.sqldts.com/?298

    http://www.sqldts.com/?246
    Reply With Quote Reply With Quote
  3. 10-29-2003, 10:41 PM #3
    chuijhk
    chuijhk is offline Registered User
    Join Date
    Oct 2003
    Posts
    5

    Unhappy

    Hi all,

    I've tried to change the SourceObjectName and the DestinationObjectName of the task but error of transformation prompt out. Is it impossible to change the DataPumptask properties during package execution? Thanks...

    Regards,
    Jeff
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules