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 |
|
yonabout
Posting Yak Master
112 Posts |
 Posted - 2006-02-22 : 07:28:32
|
| Hi,I'm trying to create a dts package to upgrade a database application.To cut an extremely long story short, I've made a DTS package which successfully populates an access database with data from 2 old access databases.The problem I've got is that the latest version of the application which uses this database also reads data from 2 XML files which were tables in one of the old access databases.Is there any way I can convert the data from these 2 tables into the XML files they need to be within the DTS package. I could do it in other ways, but I'd like to use DTS so it's all one package.Any ideas?Cheers,Yonabout |
|
|
yonabout
Posting Yak Master
112 Posts |
Posted - 2006-02-27 : 10:58:02
|
| It's OK, I fixed it.Basically, I had to write an activex script to do the XML transformation. Took a bit of messing around to get the formatting and stuff right, but it's all working fine now. This page was very helpful:[url]http://www.perfectxml.com/articles/XML/ExportSQLXML.asp[/url]I have got one more question regarding this - How do I shift the package around? i.e. send it to another developer?At the moment I've exported it to a vb .bas file and made it into an exe, which gives me a bit more control over variable file locations and stuff, but initially I tried saving it as a structured storage file - but I couldn't figure out how to import this from my C:\ drive back into the server as a dts package.Cheers,Yonabout |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-27 : 11:03:56
|
| From EM, right click on Data Transformation Services folder...Open Package... |
|
|
|
yonabout
Posting Yak Master
112 Posts |
Posted - 2006-02-28 : 06:25:10
|
| Excellent.Cheers,Yonabout |
|
|
|
|
|
|
|
|
DTS export to XML