How to add Dynamic column in the Flatfile Source?

Question

Post reply

How to add Dynamic column in the Flatfile Source?

Viewing 8 posts - 31 through 38 (of 38 total)

You must be logged in to reply to this topic. Login to reply

arunnrj87 Mr or Mrs. 500 Points: 565 More actions · Answer 1

arunnrj87

Mr or Mrs. 500

Points: 565

November 12, 2014 at 4:14 am

#1757895

Column Name --> FtpDate

Datatype --> Date Not Null

Phil Parkin SSC Guru Points: 247158 More actions · Answer 2

When you are retrieving the file name in the Foreach loop, consider selecting the 'Name only' option to avoid having to dissect the entire path string with your derived column expression.

Phil Parkin SSC Guru Points: 247158 More actions · Answer 3

OK, so is this solved now?

If not, please provide three or four sample file names, so that we can help with the Derived Column expression.

arunnrj87 Mr or Mrs. 500 Points: 565 More actions · Answer 4

No The problem has not solved

Here are the Sample File Names

''ACTEST00001_20141111_0408_INV.TXT''

''ACTEST00001_20141111_0408_SL.TXT''

''ACTEST00001_20141111_0408_SV.TXT''

''ACTEST00001_20141111_0408_SV_APPT.TXT''

Like this i have 100 files in my local path

I please u to tell the procedure from the first step by step so that i willl try again from the First.

arunnrj87 Mr or Mrs. 500 Points: 565 More actions · Answer 5

arunnrj87

Mr or Mrs. 500

Points: 565

November 12, 2014 at 6:24 am

#1757953

Hi Phil ,

Please reply

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 6

arunnrj87 (11/12/2014)
Hi Phil ,
Please reply

Please be aware that this is a forum of volunteers, where most of them have day time jobs as well.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arunnrj87 Mr or Mrs. 500 Points: 565 More actions · Answer 7

I know that Mr.Phil,If u dont have time please tell sorry having some work.

Any way thank u giving me some ideas till now in your busy Schedule.

Phil Parkin SSC Guru Points: 247158 More actions · Answer 8

Koen Verbeeck (11/12/2014)
arunnrj87 (11/12/2014)
Hi Phil ,
Please reply
Please be aware that this is a forum of volunteers, where most of them have day time jobs as well.

Yep, this includes me. I don't have time to write out a step-by-step process right now.

I am busy refactoring my databases to the gates of hell.

How to add Dynamic column in the Flatfile Source?

Cookies on SQLServerCentral