Relative Content

Tag Archive for ssis

SSIS Send Mail Task Editor Doesn’t Recognize Any Expressions

I’m trying to set up an SSIS package to send emails. I’ve set up a parameter to pass into the ToLine but when I click on the Send Mail Task Properties –> Expressions it does not recognize the parameter. In fact, it doesn’t recognize anything — I can click on one of the canned functions and it doesn’t recognize any of them either.

SSIS package changes

I am trying to decommission the sql server. I have package I have to decommission that. Before doing that I need to rename and wait for one week to find any problem . If now I need to delete that. So when I renamed the package and deployed it. I am finding two packages in Ssms one original and other renamed one. I need only renamed in ssms catalog. What I have missed here

Time frame effect package run in ssis?

I just inherited a ssis package. one of the variable is calling itself.. so the DALIC is always failing. It scheduled daily in the morning around 7 am est . I fixed it now.
The problem is before I notice that, I deployed to the server in the afternoon. and test ran it.. It succussed!! Then I didn’t do anything, but next morning it failed again?

SSIS Convert time to seconds

I receive an excel file with time fields in the format :00:00, but there are times when the hour will be populated
| Time | Seconds
| ——–
| 1:03:48 |
| :52:10 |

Trying to convert time format 0:00:00 to seconds (integer)

Trying to convert time format 0:00:00 to seconds (integer), to use as a derive column in SSIS. I’ve tried (DT_I4)TOKEN(column,”:”,1) * 60 + (DT_I4)TOKEN(column,”:”,2), but it is not recognizing the hour portion whether it has a leading zero or not