Upgraded packages are not backward compatible. You cannot open a package with greater version on a lower version.

You can see the package version in the text editor like this: ...

As mentioned above by Lowell you have to achieve the desired result executing dynamic SQL.

When using CAST /CONVERT you cannot convert a field to a different data type if not all the values can actually be converted or are compatible. All the INT values...

When you say deploy the package, do you mean deploy to the file system, SQL store, SSIS package store or SSIS catalog?

If you are just trying to deploy a single...

The way metadata is returned in SQL Server 2012/2014 is different than SQL Server 2008 R2.

If you are looking for the quick fix and something that works than change...

If you need to get the current_week that is 15 days before today's date then you can use this statement:

Select current_week from #mytable

where GETDATE()-15 between cast(Left(Ltrim(current_week), 10)as date) and ...

Select cast(DATEPART(week, cast(Left(Ltrim(current_week), 10)as date)) as nvarchar) +'~~'+cast(DATEPART(week, cast(right(Rtrim(current_week), 10)as date))as nvarchar) as [Week Number] from #mytable

Week Number

8~~9

3~~4

3~~4

3~~4

4~~5

5~~6

7~~8

7~~8

This will show on which week the begin and end dates will fall...