Viewing 15 posts - 1,411 through 1,425 (of 4,272 total)
I'm thinking you are going to have to catch them and evaluate whether they are true errors. I did a little search online and didn't see a way around...
June 3, 2011 at 12:20 pm
Why don't you just schedule the existing TRX logs on those databases for every 15 minutes. That would tell you pretty easily. Or if you have exisiting TRX...
June 3, 2011 at 12:04 pm
When you run that batch file what if any output do you get?
Also, since all you are doing is creating a security context why even map it to a drive?
net...
June 3, 2011 at 11:54 am
As a side note, we also have Mr. Drapers to thank for the Database Mail component in SQL 2005 and above.
CEWII
June 3, 2011 at 9:17 am
shyamhr (6/3/2011)
How can i download a file and upload a file to the same share point site. I...
June 3, 2011 at 8:37 am
The output variable from the EXEC task needs to be the same name and scope of the variable that is tested in the precedence constraint between the EXEC SQL Task...
June 2, 2011 at 3:58 pm
opc.three (6/2/2011)
Elliott Whitlow (6/2/2011)
Actually that is pretty easy and opc.three is on the right track.CEWII
Gee, thanks CEWII :blush:
I had already started my response when I noticed you were already...
June 2, 2011 at 3:23 pm
Data driven subscriptions IS an enterprise edition feature. However, this is very different than a DDS, the values are set at design-time and don't have to change like they...
June 2, 2011 at 3:22 pm
Actually that is pretty easy and opc.three is on the right track.
CEWII
June 2, 2011 at 3:18 pm
Considering PDF is for a human readable format I'm a little unsure why SSIS would be handling the formatting instead of something like SSRS. Are you using the right...
June 2, 2011 at 12:24 pm
I guess I'm unclear what you are asking. You have 50 or so sprocs that use columns that are encrypted with a particular cert. The code that accesses...
June 2, 2011 at 12:23 pm
Try changing the parameter name to the number zero (0) and perhaps paramter size to -1, can't remember about the size one..
CEWII
June 2, 2011 at 10:40 am
Lets start with some practices..
You should NEVER be trying to run production packages from your development machine like this.
Regardless of whether you are using the file system of the SQL...
June 2, 2011 at 10:35 am
Great news, glad to hear it..
CEWII
June 2, 2011 at 7:43 am
It tends to stick to the port once it starts using one, so a failover would not likely change that. Possible, but not very likely.
Also I saw that you...
June 1, 2011 at 8:05 pm
Viewing 15 posts - 1,411 through 1,425 (of 4,272 total)