 | Created On:10/14/2005 1:55:04 PM |
DTS Documentation
Master Conversion Package
Package Information
| Name | Value |
|---|---|
 Name | Master Conversion Package |
| Package I D | {FFB96B1A-EEBB-44E5-9F36-9FAF00885400} |
| Write Completion Status To N T Event Log | False |
| Fail On Error | False |
| Version I D | {987FF9E0-528A-4187-AE2D-E58E926D6341} |
| Creator Name | myuser |
| Creator Computer Name | my-sql-server |
| Creation Date | 10/14/2005 1:30:18 PM |
| Package Priority Class | 2 |
| Max Concurrent Steps | 4 |
| Lineage Options | 0 |
| Use Transaction | True |
| Transaction Isolation Level | 4096 |
| Auto Commit Transaction | True |
| Repository Metadata Options | 0 |
| Use O L E D B Service Components | True |
| Log To S Q L Server | False |
| Log Server Flags | 0 |
| Fail Package On Log Failure | False |
| Explicit Global Variables | False |
| Package Type | 0 |
| Nested Execution Level | 0 |
Overview
| Overview |
|---|
 |
Package Call Tree
| Call Tree |
|---|
 |
Connections
| Name | Catalog | Data Source | User | Password | Description |
|---|---|---|---|---|---|
 Microsoft OLE DB Provider for SQL Server 2 | my_bank_flat | (local) | |||
| Microsoft Excel 97-2000 | D:\work\doc\my_bank\Data Conversion.xls | Admin | |||
| Microsoft OLE DB Provider for SQL Server | Old36Police | (local) | sa | ||
| Microsoft Access | D:\work\access\tst.mdb | Admin | |||
| My Text | D:\temp\result.txt | ||||
| dBase 5 | D:\temp | Admin |
Data Tasks
Person Module
Source SQL: select top 100 * from alpha
| [my_bank_flat].[dbo].[tPerson] | Description | |
|---|---|---|
 ANAME |  firstnamemiddlenamelastname | Name Parse |
| ASOC# | socialsecuritynumber | DTSTransformation__1 |
| ALIC# | aliennumber | DTSTransformation__2 |
| ALKEYB | entityID | DTSTransformation__3 |
| ALKEYA | personID | DTSTransformation__4 |
Clear Person
| Name | Value |
|---|---|
| Name | DTSTask_DTSExecuteSQLTask_1 |
| Description | Clear Person |
| S Q L Statement | delete from tPerson |
| Connection I D | 2 |
| Command Timeout | 0 |
| Output As Recordset | False |
Alias transformation
| [Old36Police].[dbo].[ALIAS] | [my_bank_flat].[dbo].[tPerson] | Description |
|---|---|---|
| AANAME | lastnamemiddlenamefirstname | DTSTransformation__1 |
| AAKEYA | personID | DTSTransformation__2 |
| AAKEYB | entityID | DTSTransformation__3 |
| AAKEYC | salutationID | DTSTransformation__4 |
| AAKEYD | personclassificationID | DTSTransformation__5 |
| AIDA | maritalstatusID | DTSTransformation__6 |
ActiveX Script Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_DTSActiveScriptTask_1 |
| Description | ActiveX Script Task: undefined |
| Active X Script | '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Main = DTSTaskExecResult_Success End Function |
| Function Name | Main |
| Script Language | VBScript |
| Add Global Variables | True |
Start Client notification Process
| Name | Value |
|---|---|
| Name | DTSTask_DTSCreateProcessTask_1 |
| Description | Start Client notification Process |
| Process Command Line | D:\temp\do.bat |
| Success Return Code | 0 |
| Timeout | 0 |
| Terminate Process After Timeout | False |
| Fail Package On Timeout | True |
Data Driven Query Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_DTSDataDrivenQueryTask_1 |
| Description | Data Driven Query Task: undefined |
| Source Connection I D | 1 |
| Source S Q L Statement | select * from addr |
| Destination Connection I D | 2 |
| Destination Object Name | [my_bank_flat].[dbo].[tOrder] |
| Progress Row Count | 1000 |
| Maximum Error Count | 0 |
| Fetch Buffer Size | 1 |
| Exception File Column Delimiter | | |
| Exception File Row Delimiter | |
| First Row | 0 |
| Last Row | 0 |
| Rows Complete | 0 |
| Rows In Error | 0 |
| Exception File Options | 1 |
Copy SQL Server Objects Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_DTSTransferObjectsTask_1 |
| Description | Copy SQL Server Objects Task: undefined |
| Source Server | (local) |
| Source Use Trusted Connection | True |
| Source Database | HTE |
| Destination Server | (local) |
| Destination Use Trusted Connection | True |
| Destination Database | new hte |
| Script File Directory | C:\Program Files\Microsoft SQL Server\80\Tools |
| Copy All Objects | True |
| Include Dependencies | True |
| Include Logins | False |
| Include Users | True |
| Drop Destination Objects First | True |
| Copy Schema | True |
| Copy Data | 1 |
| Script Option | -2147061505 |
| Script Option Ex | 4112 |
| Source Translate Char | True |
| Dest Translate Char | True |
| Dest Use Transaction | False |
| Use Collation | True |
Job Completed notification
| Name | Value |
|---|---|
| Name | DTSTask_DTSSendMailTask_1 |
| Description | Job Completed notification |
| Profile | Outlook |
| To Line | support@conversion.net |
| Subject | Conversion Job is completed |
| Is N T Service | False |
| Save Mail In Sent Items Folder | True |
Bulk Insert to the Reports
| Name | Value |
|---|---|
| Name | DTSTask_DTSBulkInsertTask_1 |
| Description | Bulk Insert to the Reports |
| Destination Table Name | [Old36Police].[dbo].[ADDR] |
| Connection I D | 1 |
| Batch Size | 0 |
| Check Constraints | False |
| Codepage | OEM |
| Data File | C:\temp\5.txt |
| Data File Type | 0 |
| Field Terminator | \t |
| Row Terminator | \n |
| First Row | 0 |
| Last Row | 0 |
| Keep Identity | False |
| Keep Nulls | False |
| Maximum Errors | 10 |
| Table Lock | False |
Execute Package Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_DTSExecutePackageTask_1 |
| Description | Execute Package Task: undefined |
| Server Name | (local) |
| Use Trusted Connection | True |
| Use Repository | False |
| Package Name | test |
| Package I D | {E6AF9007-FBC6-4F90-8B1A-0EA6B81F0257} |
Send Notification to the MSMQ
| Name | Value |
|---|---|
| Name | DTSTask_DTSMessageQueueTask_1 |
| Description | Send Notification to the MSMQ |
| Task Type | 0 |
| Queue Path | RESPONSE_QUEUE |
| Receive Message Type | 0 |
| D T S Message Package I D | |
| D T S Message Version I D | |
| D T S Message Lineage I D | |
| String Compare Type | 0 |
| String Compare Value | |
| Save Data File Name | |
| Data File Non Overwritable | True |
| Remove From Queue | False |
| Error If Receive Message Timeout | False |
| Receive Message Timeout | 0 |
Transfer Error Messages Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_OMWCustomTasks.OMWTransferErrors_1 |
| Description | Transfer Error Messages Task: undefined |
| All Errors | 0 |
Transfer Databases Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_OMWCustomTasks.OMWTransferDatabases_1 |
| Description | Transfer Databases Task: undefined |
| Name | Value |
|---|---|
| Name | DTSTask_OMWCustomTasks.OMWTransferMaster_1 |
| Description | Transfer Master Stored Procedures Task: undefined |
| All Master | 0 |
Transfer Jobs Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_OMWCustomTasks.OMWTransferMSDB_1 |
| Description | Transfer Jobs Task: undefined |
| All M S D B | 0 |
Transfer Logins Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_OMWCustomTasks.OMWTransferLogins_1 |
| Description | Transfer Logins Task: undefined |
| All Logins | 0 |
Dynamic Properties Task: undefined
| Name | Value |
|---|---|
| Name | DTSTask_DTSDynamicPropertiesTask_1 |
| Description | Dynamic Properties Task: undefined |
Data Steps
Person Module
| Name | Value |
|---|---|
| Name | DTSStep_DTSDataPumpTask_1 |
| Description | Person Module |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSDataPumpTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Clear Person
| Name | Value |
|---|---|
| Name | DTSStep_DTSExecuteSQLTask_1 |
| Description | Clear Person |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSExecuteSQLTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Alias transformation
| Name | Value |
|---|---|
| Name | DTSStep_DTSDataPumpTask_2 |
| Description | Alias transformation |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSDataPumpTask_2 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
ActiveX Script Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_DTSActiveScriptTask_1 |
| Description | ActiveX Script Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSActiveScriptTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Start Client notification Process
| Name | Value |
|---|---|
| Name | DTSStep_DTSCreateProcessTask_1 |
| Description | Start Client notification Process |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSCreateProcessTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Data Driven Query Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_DTSDataDrivenQueryTask_1 |
| Description | Data Driven Query Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSDataDrivenQueryTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Copy SQL Server Objects Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_DTSTransferObjectsTask_1 |
| Description | Copy SQL Server Objects Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSTransferObjectsTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Job Completed notification
| Name | Value |
|---|---|
| Name | DTSStep_DTSSendMailTask_1 |
| Description | Job Completed notification |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSSendMailTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Bulk Insert to the Reports
| Name | Value |
|---|---|
| Name | DTSStep_DTSBulkInsertTask_1 |
| Description | Bulk Insert to the Reports |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSBulkInsertTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Execute Package Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_DTSExecutePackageTask_1 |
| Description | Execute Package Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSExecutePackageTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Send Notification to the MSMQ
| Name | Value |
|---|---|
| Name | DTSStep_DTSMessageQueueTask_1 |
| Description | Send Notification to the MSMQ |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSMessageQueueTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Transfer Error Messages Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_OMWCustomTasks.OMWTransferErrors_1 |
| Description | Transfer Error Messages Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_OMWCustomTasks.OMWTransferErrors_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | True |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Transfer Databases Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_OMWCustomTasks.OMWTransferDatabases_1 |
| Description | Transfer Databases Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_OMWCustomTasks.OMWTransferDatabases_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | True |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Transfer Master Stored Procedures Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_OMWCustomTasks.OMWTransferMaster_1 |
| Description | Transfer Master Stored Procedures Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_OMWCustomTasks.OMWTransferMaster_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | True |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Transfer Jobs Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_OMWCustomTasks.OMWTransferMSDB_1 |
| Description | Transfer Jobs Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_OMWCustomTasks.OMWTransferMSDB_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | True |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Transfer Logins Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_OMWCustomTasks.OMWTransferLogins_1 |
| Description | Transfer Logins Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_OMWCustomTasks.OMWTransferLogins_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | True |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |
Dynamic Properties Task: undefined
| Name | Value |
|---|---|
| Name | DTSStep_DTSDynamicPropertiesTask_1 |
| Description | Dynamic Properties Task: undefined |
| Execution Status | 1 |
| Execution Result | 1 |
| Task Name | DTSTask_DTSDynamicPropertiesTask_1 |
| Commit Success | False |
| Rollback Failure | False |
| Script Language | VBScript |
| Add Global Variables | True |
| Relative Priority | 3 |
| Close Connection | False |
| Execute In Main Thread | False |
| Is Package D S O Rowset | False |
| Join Transaction If Present | False |
| Start Time | 12/30/1899 12:00:00 AM |
| Finish Time | 12/30/1899 12:00:00 AM |
| Execution Time | 0 |
| Disable Step | False |
| Fail Package On Error | False |