Jason that's a pretty cool function. I'm curious why it's not used more often? Is there any reason to use LEN instead of DATALENGTH, other than if you are trying...

Is it possible that you have spaces which you aren't counting? If SQL Server tells you the length is greater than 20, and when you count the characters you get...

Like Koen said, I'd recommend using the Lookup transform to direct only rows that find no match to your destination.

But you'll need to do one more thing to - and...

What's your full expression?

I tried this, and it worked fine for me:

@[User::TempCreatedFilesFolder] + @[User::OutputFile] + "_" +

(DT_WSTR,4)DatePart("yyyy", GetDate())

+ "_" +RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2)+ "_"

+RIGHT("0" + (DT_WSTR, 2) DATEPART("dd", DATEADD("day",...

You're getting a truncation error because of this:

(DT_WSTR,2)DATEADD("day",-1,GETDATE())

DATEADD return type is DATETIME. DATETIME is considerably longer than two characters.

Try this instead:

(DT_WSTR, 2) DATEPART("dd", DATEADD("day", -1, GETDATE()))

You're much better off doing this in a standard SQL Query than using SSIS.

Try something like this:

SELECT

DateIssued,

COUNT(CASE WHEN [Type] = 'HO-A' THEN [NumSales] ELSE NULL END) AS [HO-A Num Sales],

SUM(CASE...

Oh cool. Good change, glad they did that, was kinda silly needing to use the error handler to redirect no matches.

If the order is important, then yeah your solution is probably the only option. The whole purpose of using a conditional split is to have things go in parallel, which...

There's no need to execute every one of those tasks. If you use a Conditional Split instead, you have all of them executing in parallel instead of in series. You...

You can't have multiple outputs from an OLE DB Source.

What you'll need to do is put a Conditional Split, and direct each to it's own OLE DB Command

Why not have a stored procedure, which takes as an input the name of the table?

Then in the procedure you can have a CASE statement, and depending on the table...

That's definitely more clear, thanks.

You *could* do it with an OLE DB Command, but I don't think it's the most efficient means to what you're trying to accomplish.

A ForEach loop,...

Ah sorry, didn't read that carefully enough. Okay then, ignore me, I've never used that connector before 😛

Use the Lookup Transform

In the properties, use a SQL Query instead of a table.

Your query should be as basic as possible. For your purposes, since you're looking just to check...

Did you try leaving the connection string as it is, and changing the excelfilepath instead?

To make sure everything goes properly, delete the existing one you have. Create a new one,...