I've gone back to the "Component Properties" in my "Advanced Editor for Flat File Source" to make this change and I seem to have forgotten how to put this formula...

Thanks... this helped tremendously... right now it is however using the FileNameColumnName under "Component Properties" in my "Advanced Editor for Flat File Source" to deliver the full path when I...

So I chose just the first .csv file in the list?

When I use the data flow task and the Source Assistant / Flat File Connection Manager Editor it will not allow me to choose multiple flat files with my folder

I want to insert the date part of the file name into a date field in my SQL table called "PyRlByPeriod" within connection "10.1.201.29.a2hr" which is my database. The file...

Thanks... within my Loop container I placed an "Execute SQL Task Editor" but I'm having trouble with its needed syntax in the SQL Statement and the Parameter Mapping... something is...

How do you get part or all the file name into the variable?

What do you mean by "dynamic filename variable"?

ConvoEVQ2021-03-22 is the convention of the .csv file names with only the month and day changing. Here I only want to return 2021-03-22 as the value that will be going...

• This reply was modified 4 years, 4 months ago by DaveBriCam.
• This reply was modified 4 years, 4 months ago by DaveBriCam.

Found the Derived Column Transformation but do I type in my SQL to get the Date from the file name into the "Expression"?

Sorry it's there when I go into Data Flow... my bad

It's simply not there

I can't find the Derived Column Transformation in my Toolbox

To get the date would I Take the file name and a variable like DATE and do something like a:

SELECT RIGHT ([FILENAME], 10) AS [DATE] to get the date out...

Just a guess as to my strategy - I'm using variables to hold the values of each field as the process iterates through each row of the .csv file. Can...