Thanks ratbak for your help. We are using SQL Server 2016. Let me talk to our DBA.

Thanks, Chris. I appreciate your help.

DATEADD("DD" ,DATEDIFF( "DD" , @[User::Todays_Date] ,CONVERT(DATE,DATEADD("WK",DATEDIFF( "WK", @[User::Todays_Date] ,GETDATE()), @[User::Todays_Date] ) - 28)), '00:00:00')

@Todays_Date variable holds Today's date with DATETIME data type.

That was my first approach to use in the where clause. However, I am still getting the error when I ran against my real data, and the error is "Invalid...

Thank you, Thom,

That is precisely what I need as per my sample data.

Now I have one more further question. As you know, the data will not always clean or the...

Thanks for your reply. I just started using this ETL tool. I am wondering is it possible to pull the daily report for audit. How many records we received in...

Hi Salliven, 

Thank You for your reply. Do you have any example or anything that I can take a look?

Jeff, 

I don't have words to say THANK YOU for your help. Very professional way to help. 

I appreciate it. I will apply this logic and run through...

Ohh K. Can you share your stored proc if you already have written? 
Maybe I can use the SQL Script task to move the data from .txt to staging SQL...

What Expression value should I give for "LastRow" parameter?

Sorry, I miss understood your last question. Yes, I already have mapped those fields in SSIS.

Yes, Exactly same fields and both files are going into the same table except one file has one extra and others don't. 
Can you share your test .dtsx package?

To access BCP file will be a little bit challenge for me to convience IT.
After I come up with the solution I have to focus on performance because from...

Hi Jeff, Thank You for your time to reply. 
I was thinking, If I could create two Data Flow
1) DF with Row Delimiter "LF" with 275 character
2) DF...

Thanks let me test it. 
However, I am stuck with, how to pass file names to all 10 child packages. 

What I did so far, loop through all files...