DECLARE @String VARCHAR(100) = '\\Servername\Temp\Foldername\ABCabcprices-20170621122040.txt'
SELECT SUBSTRING(@String, LEN(@String) - CHARINDEX('\', REVERSE(@String)) + 2, 3)

Are you connected to an Express instance?  Express editions of SQL Server don't have maintenance plans, so therefore no maintenance plans folder, and would not be able to load a...

You would most likely be using SSMS 2016 for this, which is perfectly capable of connect to SQL Server 2008 R2.  In your current setup, you can right-click the CMS...

Make sure to select the option "32-bit runtime" on the job step.
Job Step -> Configuration Tab -> Advanced Tab

Download Visual Studio 2015 Community Edition.  It's free.  Then get the SSDT download for it.  You can develop SSIS packages against SQL Server 2012, 2014, and 2016 all in one...

Tools -> Options -> Designers -> Table and Database Designers -> Uncheck "Prevent saving changes that require table re-creation"

I think the title of this article is misleading. It should be called "How to run SSIS Package as a SQL Job" instead of "How to run SSIS Project...

From a programmer's point of view, I couldn't live without these features, which were not available in SQL Server 2005:

Common Table Expressions: https://msdn.microsoft.com/en-us/library/ms175972.aspx?f=255&MSPPError=-2147217396

MERGE: https://msdn.microsoft.com/en-us/library/bb510625.aspx?f=255&MSPPError=-2147217396

ROW_NUMBER(): https://msdn.microsoft.com/en-us/library/ms186734.aspx

SQL Server 2008 - Released 11/6/2008

SQL Server 2008 R2 - Released 7/20/2010

I think you are forgetting the R2 version. Microsoft called it that instead of SQL Server 2010, but...

What you tried should be working. Worked for me.

WITH cte AS (

SELECT 'Prod' AS Col1

UNION ALL

SELECT 'Share' AS Col1

UNION ALL

SELECT 'Sports' AS Col1

UNION ALL

SELECT 'Transportation' AS Col1

UNION ALL

SELECT 'Office'...

In the Registered Servers window create a Central Managment Server and add all the required instances as New Server Registrations. Then you can right-click on the managing server, and...

It will work fine. Express edition databases are still the same structure/format as the other editions. Express server just limits database size and process memory usage.

I know this is an SQL Server forum, but a quick and dirty .Net Console Application does this quite easily. Change the first 3 variables accordingly. Hopefully it's...

Use a data type of nvarchar(the_size_you_need_for_file_name_or_full_path), or varchar(same_thing), if you don't need to worry about international characters and want to save a few bytes of storage space per row.