I have de following application to do :
I receive several .csv files from another application in a determined folder
of my PC.
Those files are named with the format log1.csv logs2.csv logs...
The number of file is variable but the internal format is always : time_sec;level
So the files content a field that may be used as unique key in the target database.
I'm trying to build a DTS package that should import periodically
all the CSV's present in the folder and then destroy them if done
successfully.
Apparently its not so simple than I supposed. I have always to give the name
of the table I want to import.
any idea?"Laurent" <autplc@.hotmail.com> wrote in message
news:e8bac87e.0411100552.5af177ca@.posting.google.c om...
> I receive several .csv files from another application in a determined
folder
> of my PC.
> Those files are named with the format log1.csv logs2.csv logs...
> The number of file is variable but the internal format is always :
time_sec;level
> So the files content a field that may be used as unique key in the target
database.
>
> I'm trying to build a DTS package that should import periodically
> all the CSV's present in the folder and then destroy them if done
> successfully.
Two Options:
Option 1:
Rename the file to a temporary name (in an ActiveX task) and use the
temporary name for the Data Pump
Option 2:
Use a Dynamic Properties Task to change the Data Source Name in the Data
Pump Task.
Regards,
Jim
No comments:
Post a Comment