Viewing 15 posts - 1 through 15 (of 19 total)
If XMLA script isn't working you could try SSIS using AMO to backup the databases. We backup ours twice a day to catch any deployments........
Sometimes you have to just...
March 16, 2010 at 5:11 am
BUMP.
This is something I have been wondering about.
A Mirrored and Stripped array, 4 disks plus (2 striped and then mirrored) could achieve 170mbps per disk write and 200mbps read per...
January 14, 2010 at 9:44 am
Hello
If the **script** is on the "Control Flow" design screen then you could add a Execute SQL task the uses sp_send_dbmail with attention paid to the file attachment option....
November 30, 2009 at 10:14 am
If it happens again you could uninstall and re-install SSMS, then apply SP2.
November 30, 2009 at 9:58 am
If you are just upgrading database objects (tables, views, usp's, udf's, etc) then you will just need to follow the updade advice from those sources.
If you are upgrading to IA64...
May 27, 2009 at 4:21 am
ahlinger,
Are you sure you have setup the configuration files in the job?
If you haven't doen that it would exactly match the symptoms you describe and is a step to easily...
October 28, 2008 at 10:29 am
This sounds like the design time configurations are being used, ie. the Dev environment.
From your discussion it sounds like you are not that familiar with SSIS configs, which is ok,...
October 28, 2008 at 5:25 am
Madhivanan (10/24/2008)
If you want to do this in sql, refer http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
Unfortunately "Microsoft.Jet.OLEDB.4.0" does not exist for IA-64..........unless you have heard otherwise.....
If you have we would be very pleased indeed!!...
October 24, 2008 at 6:52 am
We have IA-64 servers........other than using a CSV converted version......will Microsoft ever release excel (Jet) drivers so we can use the excel Tasks?
Do you have any methods for bringing in...
October 24, 2008 at 3:15 am
Didn't the three amigo's - Booch, Brady and Rumbaugh cook up the Capability Maturity Model back in 1995/6?
September 23, 2008 at 2:23 am
Multiple processor bugs are nothing new to SQL Server, e.g. had them in 7 sp3 and 2000 sp3.
If you think you have a Parallelism problem using MAXDOP 1 option on...
August 1, 2008 at 3:11 am
Here's VB Net Script to do the same using AMO....in SSIS
Variables are declared at Package level and are configured using Package configurations (XML files).
This is the MAIN() body of code
Imports...
July 17, 2008 at 7:54 am
A few steps and questions about this "problem"
1) are the users in the administrators group on the server running SSIS service
2) If not then DCOM settings need to be...
May 23, 2008 at 7:47 am
You can also right click the text box and select "fx - Expression"
On the new dialogue shown you can now enter CF/LF by pressing CTRL and RETURN together at...
May 23, 2008 at 7:24 am
Viewing 15 posts - 1 through 15 (of 19 total)