[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 555
  • Last Modified:

XML Export: SSAS?

I recently built a stored procedure that uses a cursor to loop on a recordset of attorneys, builds a temporary view containing calendar events for each attorney, and exports that view to an external XML file.  The temporary view and XML export code works, but I had to do some funky stuff with the code to get it to work.  This made me start thinking about SSIS.  

Is an XML export type of thing that SSIS is made for?  Additionally, the sproc described above is just one of several in my project.  Can I call an SSIS procedure from a TSQL sproc?
0
jdana
Asked:
jdana
  • 3
  • 2
1 Solution
 
PedroCGDCommented:
You need to use a XML task for source or destination?
You can call a SSIS package from a Stored Procedure directly or from a SQL Job.
Give more feedback!
regards!
0
 
jdanaAuthor Commented:
If SSIS is appropriate, I'd use it as an XML source.
I'm pumping the XML files to a web server where I front them with PHP.
0
 
PedroCGDCommented:
You need to read XML source and where you need to insert data? In database?
Regards
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
jdanaAuthor Commented:
The data resides IN the database.  The database EXPORTS XML files.  The website READS the XML files.
0
 
HoggZillaCommented:
To call an SSIS Package from T-SQL, use the sp_start_job procedure:
USE msdb;
GO
EXEC dbo.sp_start_job N'SSIS_PACKAGE_NAME';
GO
 
Here is an example of a way to use the .NET Script Componenty with your Stored Procedure and produce an XML destination:
http://www.sqldbatips.com/showarticle.asp?ID=23
 
 
0
 
jdanaAuthor Commented:
Thanks Hoggzilla,

Perfect solution
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now