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 |
|
skillman
Starting Member
1 Post |
 Posted - 2008-04-02 : 06:19:41
|
| HI All, 1)I have a question. I have a column in nvarchar format which is called close_date and is in the following format: 29.02.2008 ( example). I need to convert it to date format.I also add that data conversion not working as column apper blank on table. Do you have any idea?2)Also the second problem is how to unzip the file stored on the shared drive in the package before uploading.Any help much appreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 06:44:00
|
| Use derived column task and put (DT_DATE) your column |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-02 : 09:09:59
|
| For question # 2)You're going to have to use "Execute Process Task" on Control Flow and pass the unzip executable, WinZip, 7Zip, WinRar (or whatever compression utility you use)... |
|
|
|
|
|
|
Convert nvarchar to date format in SSIS