Is this as part of a data flow? If yes, add a derived column to your data flow and put the calculation in there.

ExecuteSQL tasks do exactly what they say...

• This reply was modified 7 years, 3 months ago by Phil Parkin.

i think you need to execute a script after the dacpac deployment. a dacpac will create tables and objects, but there's no scripting involved, so no, no script can...

• This reply was modified 7 years, 3 months ago by Phil Parkin.

I cannot see how executing a SELECT query in a post-deployment script will achieve anything useful. Where are you expecting the SELECTed data to go?

And I just logged in to respond to your original message! 🙂

How can we resolve this issues without changing any code?

Your options are limited.

Reducing the length of one or more of the underlying table columns is the best idea that comes...

That's how...

I get that error when i run my code against a very large table. Most Prod_IDs have two dashes. I want to pull the value between the dashes.  This...

• This reply was modified 7 years, 3 months ago by Phil Parkin.

SELECT ...

FROM ...

WHERE @SomeTime >= StartTalk AND @SomeTime <= EndTalk

Try this

DROP TABLE IF EXISTS #SomeTable;

CREATE TABLE #SomeTable
(
    Id INT
   ,EventId INT
   ,A VARCHAR(20)
   ,B VARCHAR(20)
  ...

There is an option, but it's well...

Can you briefly explain why this is required?

And if there are three rows of source data, what do you want to see?

@Phil Parkin When you say put the source code into the project, do you mean the dll?  They exist in the assemblies folder.  Or do you mean the actual...

You need to put the source code for the assembly into your database project. It is part of the build.

If start date is 1/1/2019 and end_date is 5/5/2019 and attended_day is Monday, which date should be used?

As you have no access to the source database and no way (in code) of identifying rows which have recently been added, modified or deleted, you are in a very...