The dates created in the second expression shown in your last post may not be what  you expect. When I tried this one substituting a hard coded year:  (DT_DBDATE)(01 /...

• This reply was modified 4 years, 10 months ago by  palandri.

I didn't actually test that, just noticed there was a delimiter missing.  I tested this in a derived column:

(DT_DBDATE)("1999" + "-10-11")

and it produced a value of 10/11/1999 in a data...

Do you maybe need a "/"  and perhaps parens:

( "01/01" + "/" + [@$Package::Year] )

Just thought I’d throw this out there….

If your input file is a .csv, an approach that might be simpler to debug would be to do the chunking and importing in...

I have used the MS Access database engine to process Excel files in SSIS.  It's a library, so no user interface, if that makes a difference, regulation-wise.

My wife has a...

You could implement caojunhe24's suggestion in a separate data flow, store the row count in a package variable, and test it before branching to your primary data flow.

If the "Exception has been thrown by the target of an invocation" error is coming from a script task or component, set a break point at the start of the...

This might get you started.  I changed this snippet on the fly after copying from real script, so it might not be perfect, but should give you the idea.

            
September 23, 2019 at 10:44 pm
            
#3682753

            
            
                                                
        

I think if a Foreach loop uses a File Enumerator, it will only populate the variable for files in the target folder, but since you are enumerating a recordset in...

You can use an Expression Task in the loop to concatenate theSource and the filename from the recordset object into another variable, which would be accessed by the FTP task.

You can configure your SQL Task to return a Full Result Set on the General tab, then assign the result to an object variable on the Result Set tab.

To loop...

My preference is to eliminate truncation warnings, etc., it just seems cleaner.  YMMV.

When you query the destination table after execution, any chance you are looking at a different database than...

There is a yellow bang on your OLE DB destination, maybe resolve that first.  I get those if I change the number of columns in the pipeline or the number...

Try setting a breakpoint just after the SQL task and verify the variable values returned by the task are what you expect.

I use Aqua Data or SSMS to develop SQL code, and view the Enter SQL Query window in the SQL Task Editor strictly as a paste destination.   Unless the change...