Viewing 5 posts - 76 through 80 (of 80 total)
What I have done in my .net app is script out sql jobs from a SQL2000 server. The code changes all calls to ISQL to SQLCommand, change calls to...
July 17, 2008 at 9:18 am
Thanks for the clarification. So is there any other way to properly script out an MSDB job to a text .sql file? I don't want to have to...
July 17, 2008 at 2:31 am
If anyone else encounters this, I have found that is caused but a corrupt MDAC installation. Instructions to fix can be found here:
June 13, 2008 at 9:45 am
Frank Bazan (4/17/2008)
Populate a recordset with a query against sys.databases.[font="Courier New"]SELECT [name]
FROM SYS.DATABASES
WHERE state_desc = 'ONLINE'[/font]
Then use a for each ADO enumerator to loop through the recordset.
Thanks, that was...
April 18, 2008 at 3:01 am
I have tried setting the Max Number of Errors on the Dataflow task which sits inside the For Each loop but the package still fails.
Is there anyway to...
April 16, 2008 at 8:24 am
Viewing 5 posts - 76 through 80 (of 80 total)