Do you want an accurate count, or are you happy with an approximation?

8GB of RAM on a server that is hosting a SQL Server data Engine as well as needing to process large files in SSIS is a tiny amount. I would...

Sent something across. Covered a couple of extra bits like font weight, and using T-SQL to adjust the conditional formatting too, which I find very handy.

Cheers Steve!

Don't mind doing this, if no one else offers. Shouldn't take too long.

Then you need to. Part of having a "Data Driven" Subscription is having a subscription. The hint is in the name. 😉

I tend to get it from the agent task was created when you created the subscription.

At what point is the error failing? If you had already created the data flow task, and then changed the code page of the file, SSIS can have a habit...

This is an unfortunate failing in SSIS, in my opinion. You are correct, in that the variables can't hold NULL values in SSIS. Therefore, unfortunately, you have to handle this...

I don't believe this is what he was looking for - it appears to me that he wants to setup a single connection manager for 2 different file formats. ...

This is actually really easy in SSIS. Select the connection manager in the connection managers pane and hit F4 to open the properties pane. Find Expressions, and open that up....

Perhaps my script Count non-NULL rows and get definition answers this? Difficult to really know what the OP is really after with such a vague requirement.

All my comments on your cross post on Stack Overflow remain here. Your screenshots suggest that you uninstalled the instance (some how), so you'll likely going need backups to...

Since Sue's message nothing has changed. SQL Server 2016 does not have the CONCAT_WS function.

What's wrong with the all the existing conversion functionalities already within SSIS and SQL Server? Why didn't what you've already tried work? Where are you trying to perform this conversion,...

It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)

I'm getting the impression that you...