Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-01-27 : 12:43:38
|
Hi - I'm not sure if this is the right posting place for this. If not can someone please let me know.Here we go.Objective: To NOT delete the Friday 4:00 PM data that is pulled in from an SSIS packageIssue: My SSIS Package runs M-Sat every 2 hours and loads data into Synonym table called BackLogLaborOld which has the table associated to it called BacklogLaborEnd-users connect to another Synonym named BackLogLaborCurrent from excel to report off of which is associated to a table called BackLogLaborB.From my understanding of Synonyms and why I have the two is it switches back and forth when the SSIS package completes and the end user never sees Excel lockup on them and they always see the new data pull. Basically loading new data into one and the other holds the old data until the job run.At the start of the SSIS package I have an Execute SQL Task run the following scriptDELETE FROM dbo.BackLogLaboroldWHERE (datename(dw,PIT)<>'Friday' or datepart(hh,PIT) <> 16) If I want to save the 4:00 PM Data pull and not delete it when I run the above script I can refresh excel and I can see it listed on the one run (the 4:00 pm Data) but cannot see it when the next run completes. Then I can see it again when another run completes.I hope I explained this good enough. Any thoughts on why I’m not seeing the saved data on the second run. I know it there when I query it in SSMS.Regards,D- |
|
|
|
|
|
SSIS Package Help...