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 |
|
h2sut
Starting Member
40 Posts |
 Posted - 2008-04-02 : 16:18:02
|
| Hello I have a cvs that i manual convert to a xls file. I have created a SSIS package. I was wondering is there a script or tool that will automatic convert the cvs file to a xls file when i run the package. Other wise i will have to convert all the files manual to xls. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-02 : 17:37:17
|
| and what is the reason you don't import the data from the csv file directly?and how do you convert it manually?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
h2sut
Starting Member
40 Posts |
Posted - 2008-04-03 : 00:40:29
|
The reason is because the csv file they sent is mess up. When i orignally imported the cvs file it was out of wack for some reason. So i convert it to .xls and use vertical bar as the delimter and that fix the problem. I want to see if there was a script or tool that would do it automaic when i run the package just incase if they send another mess up cvs file. Other wise i would have to do that same process again quote:
Originally posted by spirit1
and what is the reason you don't import the data from the csv file directly?and how do you convert it manually?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
|
|
|
|
|
|
|
File conversion