My boss has a bad case of “Not Invented Here” [closed]
Closed 9 years ago.
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?
“Failed to acquire connection” from a connection string variable
I have an SSIS package with a SQL Connection using the SqlClient Data Provider. Its connection string is set from a variable via an expression.
SSIS package creating a UTF-8 Flat file, need it to produce a ASCII flat file
I have an SSIS package that is producing a flat file. The flat file is currently creating as a UTF-8 file, however I have just found out the flat file output needs to be ASCII. Is there a setting I can change for the flat file destination connection manager?
SSIS dynamically Execute Package Task: Package Name is missing
I want to run multiple packages using Execute Package Task. There is a table in database saves the package names. I create a SQL Query Task first. The query result is a list of package names:
SSIS export SQL result to csv but the column order changed
I am trying to use a Data Flow Task to export a SQL query result into csv file. It’s a very simple SQL. The column PTLASTUPDATEDDTTM is a DATETIME type. My SQL have to convert its format:
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