Hi Brian

The problem is that we are regularly restoring the SQL Server 2008 database from a backup

We don't have a visual studio project for the database but we can script...

I wasn't aware of Try_Cast so will check that out

Thanks guys.That really helped

Hi phil

OK the error message we got was that

The task "Get Filename" cannot run on...

On my development machine , im running SQL Server Standard Edition (64-bit)

On the target server , Enterprise Edition (64 bit) is running

Also the CLR Version is the same on my...

Hi Thom

OK I have now installed SP3 and the update for that on my local SQL Server machine.

I was running the package via a SQL Server agent job and get...

Thanks Phil

Re upgrading our SQL Server environment , I wish I could . But the powers that be ...seem to be at the mercy of product owners and happy to...

Hi phil

I figured this one out. OK  in SSIS 2008....the Evaluate function for Variables is not in the Variables pane

Its actually in the properties of the Variables

So what I had...

Sure please find this attached

Hi Phil

There doesn't appear to be an Evaluate expression for variables in 2008 like you have in 2016, 2017

In my SSIS Variables window... I used this for the value

exec [System].[csp_LoadPushPortfolioData_Seg]...

Hi

Ok I found out how to do this.

Install Microsoft Visual Studio 2008 professional

Then Download Microsoft SQL Server 2008 R2 SP2 - Express Edition with Advanced Services.

This has Integrated Full-text Search...

Thanks Frederico

Ok I got this working as follows:

string fileName;

string path = Dts.Connections["Output_ExistingFile"].ConnectionString.ToString();

fileName = System.IO.Path.GetFileName(path);

That gives me just the filename  Existing_SVPP_XXXX_00001_00021_20200424_231245.csv

Thanks all for your all help on this

Thanks all

Hi Tim

Thanks for you reply

Ok so I can set the property for FileSpec to  @[User::FileImportMask] ie SVPP_ROYA_00001_00021_20200225_**.csv

Now I can I loop through and capture each of my file names ] which...

Thanks Eddie that works for me!

Hi All

I found a solution to this

What you need to do is to cast the variables @pFirstRow and @pLastRow to varchar variables and then

handle the nullable value

For example

DECLARE

@pDataTableName varchar(1000) =...