Click here to Skip to main content
15,886,689 members
Articles / Database Development / SQL Server / SQL Server 2008

Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005

Rate me:
Please Sign up or sign in to vote.
4.63/5 (16 votes)
15 Jan 2012CPOL6 min read 355.9K   7.1K   43  
Export SQL Server Tables to Excel Files Dynamically

This article is a sponsored article. Articles such as these are intended to provide you with information on products and services that we consider useful and of value to developers

  • SSIS_Excel.zip
    • SSIS_Excel
      • bin
        • ExcelSheets.dtsx
      • ExcelSheets.dtsx
      • SSIS_Excel 1.database
      • SSIS_Excel.database
      • SSIS_Excel.dtproj
      • SSIS_Excel.dtproj.user
      • SSIS_Excel.sln
      • SSIS_Excel.suo

Microsoft Visual Studio Solution File, Format Version 9.00
# Visual Studio 2005
Project("{D183A3D8-5FD8-494B-B014-37F57B35E655}") = "SSIS_Excel", "SSIS_Excel.dtproj", "{4E1D1242-CAB0-463C-A13F-756031529B9D}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Development|Default = Development|Default
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{4E1D1242-CAB0-463C-A13F-756031529B9D}.Development|Default.ActiveCfg = Development
		{4E1D1242-CAB0-463C-A13F-756031529B9D}.Development|Default.Build.0 = Development
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead
United States United States
Mr. Kanumukula is a IT-Professional and has been in the industry since 1997.
• Around 15+ years of experience in the areas of system design & architecture, application programming, development, testing, deployments, execution with implementations & Roll-outs of business applications in cloud/on-premise.
• Experience with Dynamics 365 for F&O/Dynamics AX, D365 for Business Central/NAV,(Inc -Visual Studio.Net, X++, AL, C#, CSide, SharePoint, SQLServer, SFDC, Power-BI, Power Apps, Dataverse/Common Data Service, CRM, SSIS/SSRS/SSAS, BizTalk, IOT, IIOT, JAVA, AWS, GCP, Azure, API, etc)
• Experience in managing Operations & Data Center maintenance both on-premise & cloud hosting, infrastructure/applications assessments & build systems.
• Experience in ERP upgrades, Mulesoft API's,MS Dynamics 365,Azure administration & hosting, LCS-Life Cycle Services.
• Experience with Commitment to Quality, technical quality assurance(before, during & after development). Create partnership with project manager to give technical assistance regarding important decisions.
• Well-Versed with Agile, SCRUM & CMMI process & methodologies to support rapid iterative Quality software development.

A highly motivated, self-starter & problem solver with multi-tasking skills, Had managed and served through an established process to get the job done in a timely and efficient manner with an eye on every detail during ERP-implementations. Flexible to work under stress and have ability to prioritize workload and stay organized in a fast-paced environment.

Learned & adapted to new technologies & tools at ease, aggressively delivered tasks on-demand at a fast-pace satisfying the needs of product owners, product development, program managers, Vendors, Higher Management, Internal/External Clients.

Have a proactive & positive attitude with a willingness to do what it takes to complete the job. Self-managed work style within a team environment. Extremely detail & Customer service oriented.

Comments and Discussions