k.shankar

 Profile Answers by k.shankar 

• Apr 7th, 2011

 

When importing the source definition, the file must be in a directory local to the client machine. In addition, the Integration Service must be able to access all source files during the session.

When you create a file source, target, or lookup definition, you must define the properties of the file. The Flat File Wizard we have to give settings like 1) file name and location.2) file type.    3) no. fo header row in the file .4) column names and datatypes

while using flat file as a source in session properties in mapping tab

Source file type : flat file

source file name : name of the file

source file path: full path where flat file exist.