Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Capturing The Error Description In A Stored Procedure Expand / Collapse
Author
Message
Posted Monday, April 26, 2004 2:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51
Comments posted to this topic are about the content posted at http://www.sqlservercentral.co


Post #113106
Posted Monday, May 3, 2004 10:18 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 18, 2005 8:25 AM
Points: 37, Visits: 1

Great Article Joseph!

This is even more interesting when you consider the new features in the "soon to be revamped" DTS in Yukon. I read that you will be able to use looping structures so using this types of packages you will be able to put all you data into a spreadsheet in one fell swoop.

I'm wondering whether Microsoft will release a separated module with the new DTS for download until we can actually start using it when the product is released together SQL Server 2005 like they did with other features (enhanced XML, Reporting Services). But if the change is "that big" maybe they wont be able to release separately.

Keep writing this great DTS articles... I'm looking forward to see more of them




Post #114126
Posted Monday, May 3, 2004 11:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 17, 2006 8:21 PM
Points: 21, Visits: 1

Enjoyed your article Joseph.

FYI, the page title that appears in the window title bar is:

"Capturing The Error Description In A Stored Procedure"

Post #114135
Posted Wednesday, May 5, 2004 10:04 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:07 AM
Points: 434, Visits: 272

"There is a limitation in the Excel driver that effects the 'DELETE' keyword. If you attempt to use it, you will receive the error message, "Deleting data in a linked table is not supported by this ISAM". Instead, we remove the Excel table entirely with the DROP TABLE 'authors' command."

That is so clever!  For years, I have been using an Excel template and the FSO to overcome the delete failure.  Your solution is so simple it's elegant!  Bravo!



ZenDada
Post #114530
Posted Friday, May 7, 2004 2:41 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:48 AM
Points: 848, Visits: 297

I had som similar problems with Excel-reports a while back, but my solution was to create a template of the excelfile and in the beginning of the DTS, I deleted the previous report and copied my fresh template.

exec master.dbo.xp_cmdshell 'del excelfile.xls'

exec master.dbo.xp_cmdshell 'copy excelfile_template.xls excelfile.xls'

The great thing with this option is that you can create some basic formatting on the template if your report require that.




Post #114901
Posted Thursday, June 10, 2004 7:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:49 AM
Points: 292, Visits: 661
Very much akin to discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=93756#bm93832

however, this version is much more visually comprehensive.

This article that should help a lot of people as it appears to have been a very common question over the years.



Post #120338
Posted Wednesday, December 8, 2004 9:19 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 12:55 PM
Points: 86, Visits: 9
First - great article!

Minor issue with implementation - maybe somebody has experienced this too? When the data is posted from my query into the excel sheet, it doesn't start posting the data on Row 2 (Row 1 has column headers). Instead it starts posting the data down on row 458.

Any ideas? This is screwing up my pivot table that is using that data sheet.

Thanks for your help!



Post #150154
Posted Tuesday, January 18, 2005 3:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 31, 2005 1:56 PM
Points: 3, Visits: 1

Very nice Article!

I got an error on implementation. The first task of dropping the table, did not work for me. It says error occurred in drop table or drop index. I removed the first task and tried with the remaining tasks. the transformation task works fine but the execute ActiveX control task gives me an error saying that the 'SendUsing' has a configuration value that is invalid. I dont konw what it means. Can anybody help me???

 

thanks

vakula

 

Post #156242
Posted Tuesday, May 3, 2005 8:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 6, 2012 2:48 PM
Points: 182, Visits: 104
Regarding the dropping the table task: Make sure that you use the slanted quotes around the table name, not just the regular single quotes. They seem to be necessary. You can copy them from the CREATE TABLE statement. See if that helps.
Post #179494
Posted Tuesday, May 3, 2005 10:56 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:59 AM
Points: 886, Visits: 1,544

Two thinsg to note:

 

1) I too had trouble with the DROP Table statement until I used the slanted quotes.  I accidentally discovered that I could also use Brackets to get it to work like this:

DROP TABLE [Authors]

 

2) I can;t get the ActiveX code to work with the objMail.AddAttachment line.  If I remove that line then the code works but when that line is there I get the error that the object doesn't support this property or method.  ANy ideas?

 

Thanks



Kindest Regards,

Just say No to Facebook!
Post #179568
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse