July 29, 2008 at 2:00 pm
Hello
I have task which am trying to figure out the best way to achieve it. I want to develop a package that will extract a CSV file from a holding server, import the data into a staging table and inform end users of outstanding orders that are more than a day old via email or SSRS.
I have attached a graphical overview of the what is intended, to provide a better picture. Any suggestions or idea will be welcomed.
July 30, 2008 at 9:41 am
an initial thought would be to build a data flow task that imports the records from the CSV and then performs a conditional split on the data for the notified records based upon the day old condition.
you can then take that data and store it into a holding table as well as possibly a flat file that you plan to email out. from there, you can build in your control flow a check to see if records exist and if so, email the data out. a ssrs report could also (or in place of) be built to read the table and either send email out or just store the report on the server for your users to come and review daily.
you may want to build into your process the cleaning up the CSV file from the holding server, the storage of history of orders that met the day old criteria and who received the emails as well.
just a some ideas to get you started.
hth
July 31, 2008 at 1:54 pm
😛
Q. are the Servers databases similar, if so why not link the servers
and go after the data? there are many ways to go after the data under this scenario, but that's just me.
"We never plan to Fail, We just fail to plan":)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply