DTS WIZARD alternatives?


Joined
Oct 1, 2013
Messages
1
Reaction score
0
I need a freeware software to convert from Excel file to the popular db formats (SQL server is the most important to me at the moment). Visual studio and it's sql server, came with a tool named DTSWizard ( Import and Export Data (32-bit) ), which is lacking the following feature I need:

1) If the row has an invalid value, it should skip it, write it to a log, and continue exporting the other rows.

The dts lacks the proper log mechanism, and every option I tried to make it write the rest of the rows on error have gone down the drain...

Does someone knows of such a program, or I shall write it myself?

Thank you!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top