4 articles Data Sources

Using Access databases as an import data source

Prerequisite : 32 bit version of Microsoft Access 2010 Redistributable Link: http://www.microsoft.com/en-us/download/details.aspx?id=13255 Create an ODBC connection item in the Connection Manager. Click “Options | Connection Manager”. Click “ODBC Connection” button. Set the settings a shown in the image below: Make sure that the path does not contain double quote characters. Once the ODBC connection is…

Using CutOffDateTime variable

What is CutOffDateTime variable? The CutOffDateTime variable contains the last time an SQL or a Pipeliner Datasource query is successfully executed. How to use this variable The variable can be directly referenced in the SQL query as shown below: select ‘@@CutOffDateTime’ as DateLastExecuted,DOB,Name,Title from customers where DOB > cast(‘@@CutOffDateTime’ as DateTime) The sample query above…