Flat file

[Nirmal Ramalingam]

When you parameterize the source which is a flat file, how do you use it? When I used the full path and file name it works, but when I use a parameter it says file not found!

[Tom Nats]

You must use the $InputFile format:

Changing Source Parameters in a File

You can define multiple parameters for a session property in a parameter file and use one of the parameters in a session. You can change the parameter name in the session properties and run the session again with a different parameter value.

For example, you create a session parameter named $InputFile_Products in a parameter file. You set the parameter value to “products.txt.” In the same parameter file, you create another parameter called $InputFile_Items. You set the parameter value to “items.txt.”

When you set the source file name to $InputFile_Products in the session properties, the Integration Service reads products.txt. When you change the source file name to $InputFile_Items, the Integration Service reads items.txt.