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 Thursday, May 5, 2005 1:04 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, May 24, 2014 10:58 PM
Points: 79, Visits: 74

Hi Joseph

U r article is excellent!!!...

A small problem i noticed it, though it is working successfully, data getting appended with old data, so in effect SQL Excecute task is not dropping the table..

can anybody tell me why and how I can solve it?

Thanks in advance

Agson C A

 

Post #180089
Posted Thursday, June 30, 2005 9:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 5:55 PM
Points: 28, Visits: 34

My post has nothing to do with capturing the error description, but after ten minutes of searching for a 'new thread' button I give up.

What I am looking for is more leeway in formatting the email. In sqlmail I am able to insert cr's and lf's, but the same syntax doesn't work in the activex mail.

Can someone point me in the right direction to research this further?

Thanks,

Dunc

 

 




Post #195868
Posted Friday, September 16, 2005 4:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 6, 2006 11:03 AM
Points: 1, Visits: 1
I kept getting a syntax error with my Execute SQL Task:

DROP TABLE 'contacts'
GO

Finally I removed the single quotes and it worked:

DROP TABLE contacts
GO

weird...
Post #220887
Posted Friday, September 23, 2005 1:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 30, 2007 7:56 AM
Points: 208, Visits: 1
Excellent article, thanks.  I've discovered that exporting to a .csv you don't need to delete the file/contents of the file first, a .csv file retains the structure from the first time you run the package and just gets new data on each subsequent run. Does that make sense?


Growing old is mandatory, growing up is optional
Post #222966
Posted Friday, September 23, 2005 1:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 24, 2014 1:38 AM
Points: 292, Visits: 662
Yes, it does append the data unless you delete and recreate the CSV file.


Post #222968
Posted Friday, September 23, 2005 1:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 30, 2007 7:56 AM
Points: 208, Visits: 1

Wildh, i've found the opposite.  You don't need to delete and recreate the csv file, the original data is replaced with the new data, at least in my experience.




Growing old is mandatory, growing up is optional
Post #222972
Posted Friday, September 23, 2005 2:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 24, 2014 1:38 AM
Points: 292, Visits: 662
Ahh. I was talking about spreadsheets not CSV, my mistake.


Post #222975
Posted Friday, September 23, 2005 2:21 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 3:55 AM
Points: 329, Visits: 102

Excellent just the kind of thing I need ....

Now if someone could give me a tip on using a parameterized stored Procedure instead of a view of a table ... and how to invoke that from a .net application it would absolutely make my day!!!!

nano

Post #222982
Posted Friday, September 23, 2005 3:00 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: Tuesday, August 10, 2010 4:54 AM
Points: 815, Visits: 32

I also had the drop table problem, I just removed the quotes altogether, which seemed to solve the problem

I have a problem with the ActiveX script, it results in an error

Error Code: 0

Error Source: CDO.Message.1

'The SendUsing configuration value is invalid'

Error Line : 13

 

David



If it ain't broke, don't fix it...
Post #222991
Posted Friday, September 23, 2005 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 1, 2010 3:40 PM
Points: 1, Visits: 4
Would it be possible to export data to multiple tabs or specify a tab to export the data to?

Thanks
Post #223041
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse