Archives of the TeradataForum

Message Posted: Fri, 31 Dec 2004 @ 10:37:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, December 30, 2004 21:35 -->

Another way to FastLoad from a DTS package is by using the DTSPackageDSO OLE DB provider with the OLE DB Access Module. Here is a small experiment that you can use to verify that this works:

* On a system having Microsoft SQL Server 2000 installed, click "Start" then "Programs" then "Microsoft SQL Server" then "Import and Export Data". Follow the wizard steps to create a "Microsoft OLE DB Provider for SQL Server" to "Microsoft OLE DB Provider for SQL Server" package. On the "Specify Table Copy or Query" step, choose "Copy table(s) and view(s) from the source database". On the "Save, Schedule, and replicate package" step, uncheck all of the check boxes in the "When" group box, check the "Save DTS Package" check box and the "Structured Storage File" radio button in the "Save" group box.

* Start the "SQL Server Enterprise Manager" and find the "Data Transformation Services" icon. Right click it and choose "Open package" to open the package that you created with the "Import and Export Data" wizard. Right click the "transform data task" icon (it is an arrow) and click "Workflow Properties". On the "Options" tab in the "Execution" group box set the "DSO rowset provider" check box. Also, copy down the entire "Name" of the transform data task. It is important the get the entire name. It may not all be displayed and you might have to click on it and then move the cursor all the way right and left over it to get the whole name.

* Save the package.

* Start OleLoad and for the "Select a source" group box, select the "Microsoft OLE DB Provider for DTS Packages ("DTSPackageDSO")" entry. On the "All" tab of the "Data Link Properties" dialog box, set the value of the Provider String property to /Ffilename (where filename is the full pathname of your DTS package).

* In the Enter the name of the desired table edit box, enter the name of the transform data task.

The rest is a normal FastLoad via OleLoad.

	<Prev	Next>		<<First	<Prev	Next>	Last>>