November 13, 2009 at 6:10 pm
in my dept there is an upgrade very soon from sql server 2005 to 2008. many of our jobs use sp_makewebtask. We are in the process of updating them to use SSIS instead, but this will not be done before the upgrade.
If the db's are left in compatability level of 90, will sp_makewebtask work in sql server 2008, so as to get us by until we can convert all the jobs? I dont have sql server 2008 available to me at this moment and wont until monday again, but would like to know the answer to this as soon as possible. Thanks all
November 13, 2009 at 11:14 pm
I don't think it will work at any compatibility level..
See this link:
http://msdn.microsoft.com/en-us/library/ms180099(SQL.90).aspx
CEWII
November 14, 2009 at 2:18 am
Oh Crap! This will be a long week!! Thanks for the quick response.
November 14, 2009 at 10:01 am
You are welcome, sorry I didn't have a happier answer..
CEWII
November 19, 2009 at 10:52 am
In case it helps anyone in a similar situation, to resolve the issue of lack of sp_makewebtask in sql 2008, we used SSIS. We output the data to an excel, and then called a sproc to send the report in an email.
Prob not the most elegant solution, but its simple, easy to adopt to other similar issues, and works!
Ive also gained quite an interest in SSIS and am looking for excuses to use it in my day to day work now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply