I am loading daily data through SSIS package on daily basis to my local system.
THe process is I will download the (.txt) files from Main Server through FTP in SSIS package and save in my local system.
And i will load those datas into Database .
First i will load full data in Master table.
ANd from Master table i will load into relevant Parent and child table.
The Problem is I will get the file data as yesterday date but while loading into DB i must load it into current date.
SO using Experssion i have changed by loading into Current date through GETDATE() and it will load in current date into All the DB.
SO when i am using this SSIS package to load into server .If i need to load a day before day data in server.It takes the current date only .so l need a solution like on which date i loading in Master tables.THose date only it get need to load in Parent and CHild tables.
How to do this please any one help me.