what I'm trying to implement is to be able to load certain columns from a flat file which is tab delimiter dinamically, I don't need all the columns from the...

yes , the files are {tab} delimiter

Thanks both of you for the quick response.

The easy way to do it is to create a function that will receive the date as a param and return a varchar formated YYYMM.

then call the function from your...

Hello,

First ask your FTP people to give you the time when the load starts

second: make sure you run your job after this time.

third : before start doing...