Viewing 15 posts - 2,536 through 2,550 (of 11,678 total)
Evil Kraig F (6/18/2014)
Grant Fritchey (6/18/2014)
Yeah, one guy offered to pay me, so I sent him my rate. And that was the end of that.
Heh, I don't mark up when...
June 19, 2014 at 12:07 am
June 19, 2014 at 12:04 am
An alternative is to run all the packages and use SQL profiler to monitor which packages make connection to the configuration table.
You know, why keep things simple? 😀
June 18, 2014 at 11:57 pm
Chitown (6/18/2014)
Thank you:-). I am assuming this is all I need other than setting up DB mail and SQL job to run this procedure.
I think that's about it yes 🙂
June 18, 2014 at 2:36 pm
You start with a simple count.
DECLARE @CountRows INT;
SELECT @CountRows = COUNT(1)
FROM myTable
WHERE Name = 'Jim';
Then you compare the count against a certain condition. If true, send an email.
IF @CountRows >...
June 18, 2014 at 2:22 pm
Sean Lange (6/18/2014)
Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something and...
June 18, 2014 at 2:07 pm
Grant Fritchey (6/18/2014)
SQLRNNR (6/18/2014)
jasona.work (6/18/2014)
GilaMonster (6/17/2014)
"No pressure to work overtime"...
June 18, 2014 at 2:03 pm
gbritton1 (6/18/2014)
Koen Verbeeck (6/18/2014)
The answer is incorrect.The question clearly states that the databases are on site. Thus, by the process of elimination, the corruption answer is the only one left.
Wrong!...
June 18, 2014 at 1:54 pm
Ryan1 (6/18/2014)
This works you are the man! Thank you so much.Any chance I can make this thing smaller?
Glad you got it resolved.
What do you want to make smaller?
June 18, 2014 at 1:32 pm
danielfountain (6/18/2014)
Badly worded, but you cant say that they said the databases are all on site and 2012 - because they didnt say that!
Maybe they use SQL 2000 for their...
June 18, 2014 at 7:30 am
How did you configure the OLE DB destination?
Anything special?
June 18, 2014 at 7:15 am
Any other errors in SSIS?
If you hardcode the value for @WorkingAttributeTableName, does it work?
June 18, 2014 at 7:10 am
jasona.work (6/18/2014)
The Index rebuilds. They're around 1/2 (maybe a bit more) of the total time for the...
June 18, 2014 at 6:58 am
A bit is a boolean, so I'm not sure what you are getting at.
June 18, 2014 at 6:51 am
Viewing 15 posts - 2,536 through 2,550 (of 11,678 total)