DTS/XML conversion utility avaialable?

I recently viewed a webcast called "Microsoft Business Intelligence Product
Architecture for ISVs" where they demostrated the DSO/XML conversion utility
and a DTS/XML conversion utility. I have used the DSO tool but could realy
use the samething for DTS packages. I seached and can seem to find a downloa
d
for it.
Anyone know anything about it or where I can get it?http://www.microsoft.com/downloads/...&DisplayLang=en
Ohjoo Kwon
"bmacatpsi" <bmacatpsi@.discussions.microsoft.com> wrote in message
news:FCABD584-B6D1-4D42-9554-6B8D0054FFD4@.microsoft.com...
> I recently viewed a webcast called "Microsoft Business Intelligence
Product
> Architecture for ISVs" where they demostrated the DSO/XML conversion
utility
> and a DTS/XML conversion utility. I have used the DSO tool but could realy
> use the samething for DTS packages. I seached and can seem to find a
download
> for it.
> Anyone know anything about it or where I can get it?|||Thanks for your prompts response,
However thats for the DSO utility and I am looking for the DTS/XML
Conversion utility.
Anyone?
"Ohjoo Kwon" wrote:

> http://www.microsoft.com/downloads/...&DisplayLang=en
> Ohjoo Kwon
>
> "bmacatpsi" <bmacatpsi@.discussions.microsoft.com> wrote in message
> news:FCABD584-B6D1-4D42-9554-6B8D0054FFD4@.microsoft.com...
> Product
> utility
> download
>
>|||You need to contact the presenter of the webcast. It is his personal
utility.
Drop me an email and I will forward accordingly.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bmacatpsi" <bmacatpsi@.discussions.microsoft.com> wrote in message
news:C13EF544-E01F-4969-AEF7-9DFD9C2CEEB0@.microsoft.com...[vbcol=seagreen]
> Thanks for your prompts response,
> However thats for the DSO utility and I am looking for the DTS/XML
> Conversion utility.
> Anyone?
> "Ohjoo Kwon" wrote:
>
http://www.microsoft.com/downloads/... />
layLang=en[vbcol=seagreen]
realy[vbcol=seagreen]

DTS with SQL Express

We have build a conversion for our customers to convert their data from our existing database system to Microsoft SQL. We've tested it with MSDE and SQL Server 2000. We based this conversion off of 183 separate DTS scripts saved as VB 6 files. We then heavily customized them to produce a final EXE in VB 6 that our end-users can run. They answer a few questions and then poof, SQL database. Works great.

Now enter SQL Server and SQL Express 2005. With no support for DTS in Express we expect out VB application will fail to execute. As 80% of our customers are MSDE/SQLExpress level customers, this is a real problem for us.

What are my options here?

When SQL Server 2005 ships, we will simultaneously release a "Backward Compatibility" redist. It will be available on the web and will contain, among other things, the same updated DTS 2000 binaries that are installed with SQL 2005.

|||That is really fantastic news. Thank you.

DTS vs Excel numeric conversion

I am having a problem importing an Excel spreadsheet. I have a column in
an Excel sheet with alphanumeric text and some of the cells are numeric.
Some of the cells contain numbers like 12345.6 and when DTS is done
importing it into a field that is nvarchar the results are
"12345.600000000001". I have tried:

1. Changing the format of the Excel column to text
2. Using the formula =text(a1,0) which only truncates the .6
3. Using the formula =t(a1) which will remove some numeric representations
4. Exporting the sheet to CSV or TXT first which will not enclose the cell
contents with ""
5. Beating the computer with a nine iron

None of these options work. Any idea anyone?

Don VonderBurgFormatting the cells as text after the data are there won't help.
Copy the cells to another location which is PREformatted as text, then
copy the copy back onto the original cells and try again. :)

On Thu, 13 May 2004 22:03:51 GMT, Don.Vonderburg@.nospam.com wrote:

>I am having a problem importing an Excel spreadsheet. I have a column in
>an Excel sheet with alphanumeric text and some of the cells are numeric.
>Some of the cells contain numbers like 12345.6 and when DTS is done
>importing it into a field that is nvarchar the results are
>"12345.600000000001". I have tried:
>1. Changing the format of the Excel column to text
>2. Using the formula =text(a1,0) which only truncates the .6
>3. Using the formula =t(a1) which will remove some numeric representations
>4. Exporting the sheet to CSV or TXT first which will not enclose the cell
>contents with ""
>5. Beating the computer with a nine iron
>None of these options work. Any idea anyone?
>Don VonderBurg|||Never thought of that one. Thank you.

Don|||Hi,

I vaguely remember that when you import the Excel file through DTS
that you can set the data type somewhere. Perhaps that helps.

When you look at the numbers that are wrongly imported in the Excel
formula bar, do you see the error as well? I guess when this is the
result in an Excel calculcated cell you may expect these rounding
errors. Remember that in Excel you never actually see the underlying
value. All values are always displayed using some kind of a display
mask. You can use the round function in Excel to round your results.
That should take care of it.

Just to make you aware of another way to pump your data into the
database. I wrote an addin for Excel called SQL*XL. Its goal is to
remove these hassles from the end user. You can use SQL*XL to get data
from the database into Excel or to pump data from Excel into the
database. It even lets you change retrieved data in Excel and post the
changes back.

If you are interested, have a look at SQL*XL at www.oraxcel.com

Best regards, Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com

DTS vs BCP vs TSQL

Hi,

As I know, although DTS gives graphical view of the data transformation/conversion work flow, it tend to be slower than BCP and TSQL scripts. So, keeping all that in mind, can I still use DTS (b'cos its a good tool to illustrate what’s happening inside, easy to understand and maintain) but with TSQL scripts (i.e: insert into...) doing the operations instead of DTS copy column or vb scripting, to gain maximum performance provided by the TSQL scripts? If you have other view points pls advice., What is the possibility of calling BCP exe inside DTS ?.

Let me provide you info. about the work I need to do, following are the things I need to do;

1. SQL source to SQL destination (different servers)

2. Transformations same SQL server and the same database

3. SQL source to text files.

Thanx

According to what I found, Yes you can call BCP inside DTS, which is very handy. Furthermore BCP and copy column transformations gave almost same performance.

|||Based on what you need, you definitely will need DTS for the ransformation. BCP is just to prepare your data for bulk copy into staging tables. Scrub and transform your data using DTS

DTS to SSIS migration question

Its probably a little late for this kind of question but, I'm converting several DTS packages over to SSIS and in the conversion I have the ability to run tasks as 'Execute DTS 2000 Package'. My question is, should I use that or do a full re-write of the flows to use the SSIS tasks?

So far I've been removing anything pertaining to SQL 2000 and adding the SSIS tasks. Its becoming very time consuming this way due to some of the DTS packages have a lot of tasks/flows. Is it the best way to do this or should I just use the DTS migration Wizard and then leave the .dtsx files alone once they're created from the wizard?

The Migration Wizard and the Execute DTS 2000 task should be seen as a short-term fix. The correct solution is to re-write your packages in SSIS. The Migration Wizard is not able to make architectural decisions to take advantage of the new capabilities in SSIS. Also, the DTS run-time probably has a limited lifespan. I have not heard anything about DTS support in 2008, but I wouldn't expect it based on what was said when 2005 was released.
|||

thanks, I was thinking the samething. So far I've rewrote almost 40 of them but I was curious on the DTS 2000 task though.

I have 40 down and 110 more to do to rewrite.