Hi Data Cruncher,

I guess what you are looking...

It seems that I need a coffee sip badly. 😀

That was awesome! Thanks

Sometimes we do easy things the hard way!

Hey Luis,

Thanks a lot for your solution. Yes I know the Tally table.

I came up with the below solution. Instead of using Tally table, I have used UDF db.GetNums...

Thanks a Lot for your solution.

That's the brilliant use of T-SQL features

Your requirement is not clear to me.

Hope below code will help you to move in the right direction

SELECT *

from act a

inner join

(select jid, pp.f as f1 , p1.f as...

Can You post sample data?

I completely...

Have you tried my solution?

Isn't if suffice your requirement?

Below is one way of doing

Fetch all the Execution statements based on table values into a variable and using dynamic SQL execute it

DECLARE @DELETECUSTID VARCHAR(MAX)

SET @DELETECUSTID =

(

SELECT ...

Hi Karthik,

Oh great!. Can you post your solution (code) here?

Try below code, is it what you want?

DECLARE @HeaderSQL as varchar(4000)

SET @HeaderSQL = (

SELECT

STUFF(

(SELECT ', [' + Param_ID + '] AS [' + Parameter + ']'

FROM [dbo].[lu_parameter]

FOR XML PATH(''))...

Could you please elaborate on points 4, 5 & 6.

How the source database columns and destination database columns mapped? How the data is transferred using SSIS? Which technique ( eg...

Oh wow! Thats a nice use of Regular Expressions! Never tried before.

I am curious to know about how data is migrated?

The code can be changed but how the existing data...

Hi,

You have to change the DataType property of Excel Columns using Advance Editor and the excel source reads first eight rows.

The below article will guide you.

"https://www.simple-talk.com/sql/ssis/importing-excel-data-into-sql-server-via-ssis-questions-you-were-too-shy-to-ask/#second"

A very nice question and there may be chances of giving the wrong answer as with the "SET IDENTITY_INSERT" one can INSERT data into Identity Column but one can never...