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: Sunday, December 7, 2014 12:32 PM
Points: 107, Visits: 158

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 @ 7:00 AM
Points: 5,317, Visits: 12,350
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.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
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