Viewing 15 posts - 11,581 through 11,595 (of 13,876 total)
pwalter83 (2/25/2011)
I do not agree with your assessment - try re-reading it. Once it is set up, a SQL Agent job takes care of everything without manual input.
Okay...
February 25, 2011 at 3:44 am
pwalter83 (2/25/2011)
Phil Parkin (2/25/2011)
Did you take a look at Jason's suggestion? It might work for you.
I studied Jason's solution but it doesnt seem to be according to the business...
February 25, 2011 at 2:59 am
Did you take a look at Jason's suggestion? It might work for you.
February 25, 2011 at 2:37 am
You did not really answer my question. Did you test with the same data?
February 25, 2011 at 2:30 am
One way or another, you've got to create all of those files. Given that you need the destination to be dynamic, I can't think of a easy way to make...
February 24, 2011 at 12:36 pm
Hmmm, wasn't clear to me! But now it is and my suggestion was not valid.
My first idea would be to use an Execute SQL task to populate an object variable...
February 24, 2011 at 12:23 pm
I may be coming into this a bit late, but sorting can be done a bit more elegantly than that in .NET. Here's an example:
...
February 24, 2011 at 12:09 pm
Pretty much what I meant.
Where are you getting the destinations from?
February 24, 2011 at 11:32 am
Strange requirement!
Can you do it just once and then do a file copy to the others - rather than running the data transfer over and over again?
February 24, 2011 at 10:46 am
rashmiptl22 (2/24/2011)
hi--
Where the execute package task will come into picture?
I do not understand this question.
You seem keen on defending your solution to the death, when we have clearly pointed out...
February 24, 2011 at 7:37 am
rashmiptl22 (2/24/2011)
Hi--
Don't u think the package should be scheduled to run every 5 or 10 minutes to meet the requirement.
No.
The requirement: ".. very next minute..."
Your solution misses that by up...
February 24, 2011 at 4:25 am
The File Watcher Task may be of interest.
February 24, 2011 at 2:41 am
Where is this 'equivalent table'?
February 23, 2011 at 5:36 am
It certainly looks like a data issue - are you sure that you have tested the package successfully in BIDS with the same data?
February 23, 2011 at 3:16 am
No doubt there is some underlying operation on the table which causes the condition to be true (insert, update etc). Have you thought about creating one or more triggers on...
February 23, 2011 at 12:11 am
Viewing 15 posts - 11,581 through 11,595 (of 13,876 total)