In SAS Data Integration Studio 4.4, the Data Validation Error and Data Exception tables were defined in metadata as string objects that contain libref.tablename information about the table. Physical table objects in the metadata are not created.

In SAS Data Integration Studio 4.5, the Data Validation Error and Data Exception tables are defined in the metadata as physical tables. Accessing SAS Data Integration Studio 4.4 metadata about these tables and converting that information to physical tables in SAS Data Integration Studio 4.5 is a simple process.

Note: The following directions are specific to creating the Data Validation Error table but can also be applied to creating the Data Exception table.

1. Import the SAS Data Integration Studio 4.4 job into SAS Data Integration Studio 4.5 (or later). Note the 2 additional table objects to the right of the Data Validation transformation.

   



2. Open the Data Validation transformation and click the Error and Exception Tables tab.
   
3. Select Create error table for the table that you want to create. Do not select Replace error table.

   



4. Click OK. The following dialog box is displayed:

   

   
   

   When Create error table is selected in an earlier step, a physical table is created, but not before the program checks to see whether an error table already exists. In this instance, an error table named SASHLP.DV4_4_ERROR_TABLE is currently defined. By clicking Yes in the dialog box, a physical table object for the error table is defined in metadata.

   
   

   Click Yes.



5. Go to the Error Records Table icon on the desktop and select Properties ► Physical Storage. Define the name and library of the current error table. The prior table name is now defined as a physical table in the metadata and is accessible to the SAS Data Integration Studio 4.5 job.

   

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Integration Studio	Microsoft Windows Server 2008 for x64	4.5		9.3 TS1M2
		Microsoft Windows Server 2012 Datacenter	4.5		9.3 TS1M2
		Microsoft Windows Server 2012 R2 Datacenter	4.5		9.3 TS1M2
		Microsoft Windows Server 2012 R2 Std	4.5		9.3 TS1M2
		Microsoft Windows Server 2012 Std	4.5		9.3 TS1M2
		Microsoft Windows XP Professional	4.5		9.3 TS1M2
		Windows 7 Enterprise 32 bit	4.5		9.3 TS1M2
		Windows 7 Enterprise x64	4.5		9.3 TS1M2
		Windows 7 Home Premium 32 bit	4.5		9.3 TS1M2
		Windows 7 Home Premium x64	4.5		9.3 TS1M2
		Windows 7 Professional 32 bit	4.5		9.3 TS1M2
		Windows 7 Professional x64	4.5		9.3 TS1M2
		Windows 7 Ultimate 32 bit	4.5		9.3 TS1M2
		Windows 7 Ultimate x64	4.5		9.3 TS1M2
		Windows Vista	4.5		9.3 TS1M2
		Windows Vista for x64	4.5		9.3 TS1M2
		Microsoft Windows Server 2008 R2	4.5		9.3 TS1M2
		Microsoft Windows Server 2008	4.5		9.3 TS1M2
		Microsoft Windows Server 2003 for x64	4.5		9.3 TS1M2
		Microsoft Windows Server 2003 Standard Edition	4.5		9.3 TS1M2
		Microsoft Windows Server 2003 Enterprise Edition	4.5		9.3 TS1M2
		Microsoft Windows Server 2003 Datacenter Edition	4.5		9.3 TS1M2
		Microsoft Windows 8.1 Pro 32-bit	4.5		9.3 TS1M2
		Microsoft Windows 8.1 Pro	4.5		9.3 TS1M2
		Microsoft Windows 8.1 Enterprise x64	4.5		9.3 TS1M2
		Microsoft Windows 8.1 Enterprise 32-bit	4.5		9.3 TS1M2
		Microsoft Windows 8 Pro x64	4.5		9.3 TS1M2
		Microsoft Windows 8 Pro 32-bit	4.5		9.3 TS1M2
		Microsoft Windows 8 Enterprise x64	4.5		9.3 TS1M2
		Microsoft Windows 8 Enterprise 32-bit	4.5		9.3 TS1M2
		Microsoft® Windows® for x64	4.5		9.3 TS1M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

You can access a SAS® Data Integration Studio 4.4 Data Validation Error or Exception table in SAS® Data Integration Studio 4.5 after you import a job by defining an error table in the Data Validation transformation and defining the same physical location to the table.

Type:	Usage Note
Priority:

Date Modified:	2014-07-30 13:02:59
Date Created:	2014-06-26 13:09:37