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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2010-02-15 : 18:27:59
|
| how do i get SSIS to send an email on failure?i set a failure pointer to the send mail task, but it just stops instead of using the send mail task |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-02-15 : 20:55:10
|
| Are you sure the e-mail task is configured properly? Have you tested that part alone? |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2010-02-16 : 00:33:49
|
| i go it working, now i'm having an issue with a process task. i'm trying to pass the current date as part of a parameter when ziping up a file w/ 7zip.i tried: a -mx7 -tzip "\\iis\FTPFolder\file" + [@User:Date] + " out_file.csv inside the arguments parameter but it keeps tossing an error.any advice? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 00:41:53
|
quote:
Originally posted by albertkohl
i go it working, now i'm having an issue with a process task. i'm trying to pass the current date as part of a parameter when ziping up a file w/ 7zip.i tried: a -mx7 -tzip "\\iis\FTPFolder\file" + [@User:Date] + " out_file.csv inside the arguments parameter but it keeps tossing an error.any advice?
whats the data type of Date variable? if its DT_DATE or DT_DBTIMESTAMP you need to convert it to varchar before concatenation using cat operator (DT_WSTR,<length>)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2010-02-16 : 01:06:29
|
| got it, thanks! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 01:08:15
|
greatyou're welcome  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS Failure