2005. They are both SSIS based.
1. DTSWizard:
This is a wizard based import export utility. This creates a SSIS package,
executes it, copy it to file system or to database instance. This SSIS
package is for import / export data from many sources to SQL Server. I used
it to create a package to export data to excel file, which is successfully
did. I loved this utility.
You can start this utility by just typing DTSWIZARD in the command prompt.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG_HDLtV5PfdDgBPXEXH9kSoVTMtrafkhFxncpihYdsSfx83_zJ9zeQwpZqjsKOSU6O1H04VS5Vu1TCk0JfQdmJ4OqDO0SmgrCkzLFQZqLVDcBhNbwlFAp_gSg0baec9BZ6rA1gl3LIKc/s320/pic24179.jpg)
2. DTUTIL:
This is also related to SSIS. This is about copying / moving SSIS packages
from / to SQL Server.
You can start this utility by typing DTUTIL from SQL Server. This is not
wizard based but it uses or creates SSIS package.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhB5TSeG3Wfgq_MI1quS4hp4fZ8bihpg8GTVaanCMEGahwFRuygC-0s1U3xwGaMjFwlTbLmujmmRMuKACsoub4ZVya-aqHpnf15-vit-6oXD7wZQ_yETNuw40dGYP7u4cuxqTdVuMsC1zQ/s320/pic18190.jpg)
No comments:
Post a Comment