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?
jdanaAsked:
Who is Participating?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
PedroCGDCommented:
You need to read XML source and where you need to insert data? In database?
Regards
0
 
jdanaAuthor Commented:
The data resides IN the database.  The database EXPORTS XML files.  The website READS the XML files.
0
 
jdanaAuthor Commented:
Thanks Hoggzilla,

Perfect solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.