I suggest that you use a SQL query as the source for your dataflow, with output to a single column. Something like this:

DROP TABLE IF EXISTS #Place;

CREATE...

Is this a blog post, or do you have a question?

This is a very long post containing precisely zero questions.

Vetting such code is a job for a paid consultant.

To generate such a script, launch SSDT and select Tools/SQL Server/New Schema Comparison.

Select your source and target databases.

Go into Settings and select only Indexes.

Run the comparison and script out the...

Here is a dirty solution. Maybe there's a pretty solution out there that someone will come up with!

DROP TABLE IF EXISTS #Account;

CREATE TABLE #Account
(
   ...

Can you provide some sample data which we can test with?

• This reply was modified 3 years, 1 month ago by Phil Parkin.

OK, then add a Data Conversion task and convert the ContentId to an INT32, then map the converted column to ID.

What is the datatype of the target ID column? VARBINARY, perhaps?

Is it ContentTypeId that you are mapping to it?

If yes, to both, try setting the SSIS datatype to Byte Stream.

I'd also use a Script Task, though I'm more inclined to use C#.

Alternatively, run a DOS one-liner with an Execute Process task. The command would be something like this:

Combining two columns is a piece of cake with my code, like so:

SELECT i.employee_code
      ,i.paydate
      ,Over_time =...

Can you please post the full text of the error, as taken from the SSISDB All Executions report?

Also from the All Executions report, on the 'Overview' page, check that the...

Here's a solution which does not rely on PIVOT:

SELECT i.employee_code
      ,i.paydate
      ,Over_time = MAX(IIF(i.Paytype = 'Over_time', 1,...

doesn't work if there are more than 9 floors, or the ground floor does not have leading zeros (which it won't if it is an INT) or if basement...

Something like this should do it:

SELECT CONCAT('USE ', u.DBName, '; ALTER ROLE [db_owner] DROP MEMBER [', u.Username, '];')
FROM @USER_table u
WHERE u.Username = 'Frodo'
ORDER BY u.DBName;

I'm not sure I am convinced. How do you manage version control for the database objects which are being generated? Doing this means that you lose many of the consistency...