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 ««12

Overwrite data in excel using SSIS Expand / Collapse
Author
Message
Posted Friday, April 3, 2009 3:20 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:21 PM
Points: 107, Visits: 155

Right... execute SQL Task. Sorry about that. I'm glad it helped, though!

PSS
Post #690263
Posted Sunday, April 5, 2009 6:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 3:40 AM
Points: 2, Visits: 69
Thanks Pss,

I think I will use your method.
Post #690587
Posted Thursday, August 20, 2009 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 9, 2010 10:27 PM
Points: 1, Visits: 3
Hi,

I tried to delete the worksheet using excecute sql task. But i m getting a error "sysntax error in drop table or drop index". possible failure reasons" problems with the query,"resultset" property not set correctly,parameters not set correctly.....",when i execute the data manager package.

Syntax i was using to delete is drop table 'members'. "members" is the work sheet name, i want to delete.

Any help on this will be appreciated.

cheers,
Ashok
Post #774075
Posted Thursday, August 20, 2009 3:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 5,078, Visits: 11,856
What is your resultset property set to?


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #774077
Posted Saturday, August 22, 2009 12:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, December 30, 2012 11:54 PM
Points: 19, Visits: 79
Hi !
It is possible to insert the values into the same excel sheet without appending. U need to delete the records and then insert the values. Please let me know detail about the MS Excel

Thanks
Post #775508
Posted Friday, September 20, 2013 1:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 10:48 AM
Points: 1, Visits: 11
I tried this, but it still isn't clearing the spreadsheet, just appending it.
Post #1497015
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse