Execute DTS MSSQL 2000 from the command prompt

2008 September 17 at 11:24 am 2 comments

DTSRUNUI UTILITY

DTSRUNUI UTILITY

  1. Jalankan perintah ‘dtsrunui‘  di Start Windows->RUN
  2. kemudian akan muncul Dialog DTS Run ( Gbr. 1)
  3. pilih SERVER bisa IP bisa nama komputer(recommended),  contoh pebdb1 ( Gbr. 1)
  4. pilih Package Name, dengan cara klik tombol ‘‘ sebelah kiri tombol ‘Advanced …’ ( Gbr. 1), kemudian akan mucul dialog baru ( Gbr. 2) kemudian pilih DTSnya klik Ok
  5. akan digenerate Date dan Package ID tampak pada ( Gbr. 3)
  6. Klik Tombol Advanced… ( Gbr. 3) maka akan muncul dialog baru ( Gbr. 4)
  7. Klik Tombol Generate… ( Gbr. 4) maka akan tercipta key yang akan dijalankan oleh perintah Utility DTSRUN yang tampak sebelah kiri Tombol Generate… , copy
  8. ini yang dihasilkan oleh Generate  DTSRun /S “pebdb1” /N “IKDB_BOM” /G “{2081627C-CFE1-4E0D-A51F-67D312EADDDE}” /W “0” /E
  9. kemudian jalankan di command prompt hasil generate tadi ( Gbr. 5)

Entry filed under: MSSQL. Tags: .

Linked Server di MSSQL 2000 MSSQL 2000 Export Import from the command promt

2 Comments Add your own

  • 1. duroh  |  2008 September 17 at 11:57 am

    MANTAPP BOZZ…..

    Reply
  • 2. masjay  |  2008 September 17 at 12:08 pm

    siip, akang.. bikin buku MS-SQL Database administrator sekalian.. ntar aku dapet versi free-nya.. hihii

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Categories


%d bloggers like this: