If you're looking only for those rows where the 'latest' status is 'bad', something like this should work:

if object_id('tempdb..#GoodBad', 'U') is not null

drop table #GoodBad;

create table #GoodBad

...

Maybe there's a better way, but this seems to work.

declare @StartTime nvarchar(10) = '12:10';

declare @EndTime nvarchar(10) = '12:30';

declare @Diff time(1) = cast(@EndTime as datetime) - cast(@StartTime as datetime);

select StartTime...

As far as I know, you cannot use Python in a Script Component, so I think you are limited by that.

nshockley (5/29/2015)

---

On SQL Server 2008 R2 some SSIS packages created and regularly scheduled to run have worked perfectly for over a year.

These packages have been upgraded on our...

You could do the whole thing (parsing, splitting, outputting one row with multiple columns per @ group) using an asynchronous Script Component, but it would take a fair chunk of...

Just to confirm. You changed the package and the project, setting Don't Save Sensitive for...

My broad answer to your equally broad question is that these are initialisms for different sets of functionality.

Perhaps you would take...

Change your package and project to "Don't Save Sensitive" and redeploy. After adding suitable configuration info to supply passwords etc at run time, the error should go away.

Are there any other error messages appearing before or after this one?

Yes it can.

Create table [schema].[name] (Id int identity(1,1) primary key clustered)

Never mind 'even', that one of the first things I try! Then a repair install.

Never had that problem. Good luck fixing it.

Minnu (5/22/2015)

---

Hi Team

using below code to replace the city names, how to avoid hard coding of city names in below query and get from a table.

select id, city,

LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(city,

'JRK_Ikosium', 'Icosium'),...

Do a schema compare between your project and your database.

vipin_jha123 (5/20/2015)

---

Hi ,

In my SSIS Project I am having many lookup.

for example flow is like below

having 1 OLEDB Source with 4 lookup task

then task task is conditional split is...

What is the datatype of SchoolYear?