Viewing 15 posts - 1,771 through 1,785 (of 2,486 total)
There are a few products on the market for this now.
A couple of the better offerings are available here,
May 17, 2004 at 9:14 pm
First step would be to put togther a VB or VBScript program to programmatically open each package, change the required properties and then save the package.
Second step is to change...
May 6, 2004 at 9:58 pm
Because of SQL Servers relative youth when compared to Oracle, there's not much in the way of Enterprise class management.
There are a few web based offerings, but most of them...
May 6, 2004 at 9:44 pm
Antares, you're usually spot-on with your prompt replies. However this time I think your promptness has got the better of you.
The IDn files are for the indexes. ID1 is clustered...
May 6, 2004 at 9:32 pm
I must admit it's not that easy to get to.
1) Bring the properties for the Matrix (not the report)
2) Select the "Group" tab
3) Select the group to change in the...
May 6, 2004 at 3:16 am
We do this regularly in a number of packages. All in an ActiveScript task.
The filename is stored in a global variable which is used when attaching the file to the...
May 6, 2004 at 3:00 am
FOr the "A previous program installation ..." message, clear out the temp directory before running the setup program.
It's supposed to be cleared when you reboot, but sometimes it isn't.
May 6, 2004 at 2:57 am
Based on a few unrelated google messages about MS Access and password protection, I decided to set the userid and password parameters each time I changed the datasource.
This seems to...
May 5, 2004 at 9:01 pm
Turning on Client Statistics in Query Analyzer gives you the following info on a seperate tab,
Application Profile Statistics
Timer resolution (milliseconds)00
Number of INSERT, UPDATE, DELETE statements00
...
May 5, 2004 at 4:38 pm
I've done that and all is ok.
After further testing I've found that it seems to occur about 1 in 4 times.
Could it be a timing issue?
May 5, 2004 at 2:44 pm
If you're running these queries in Query Analyzer, turn on Client Statistics (Ctrl+Shift+K).
The delay you're experiencing is probably due to the client formatting the output.
Also, make sure you are not...
May 5, 2004 at 1:51 am
You can't attach query results using CDONTS.
Extract the results to a file and then attached the file.
May 5, 2004 at 1:35 am
See my post in the T-SQL group.
May 5, 2004 at 1:33 am
Right-click on the maintenance plan and select "Maintenance Plan History". This is where you'll find much more descriptive error messages.
May 5, 2004 at 1:32 am
Viewing 15 posts - 1,771 through 1,785 (of 2,486 total)