Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmusson17
Starting Member
3 Posts |
 Posted - 2008-07-28 : 12:11:33
|
| I have a large t-sql statement (select... for xml explicit) that creates a nice sized (17 mb) xml file that I need to ftp to a vendor on a daily basis. I can run the the select statement in management studio where I can open up, view, and save the results as an xml or text file and then manually ftp the file to the vendor. What I am struggling with is automating this process via SSIS. Right now I have the t-sql running in an ole db source component. It generates the output as a DT_IMAGE data type. Now I'm stuck. I have scoured the net and have not been able to successfully apply any of the suggested solutions (bcp with a select statement from the command line, using a datareader destination, etc).Any help/advice is much appreciated.Dave |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 12:56:04
|
| http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx |
 |
|
|
dmusson17
Starting Member
3 Posts |
Posted - 2008-07-28 : 16:24:00
|
| Thanks for the reply. Writing the xml query results out to a variable and then writing the variable out to a file via a script seems to be the consensus. I actually used this one and it worked well:http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/05/22/21084.aspx#27317Thanks again... |
|
|
|
|
|
|
Exporting XML result file via SSIS