If I understand you correctly, if you enter a list of 4 parts you want to find all codeId which have those 4 parts.

One way of  doing this is to...

To find the time difference between to rows then you could use lead or lag.  Here is a rough example

Use TEMPDB;



DECLARE @Employee TABLE (
EmployeeId INT
,Name VARCHAR(50)
)

INSERT @Employee
VALUES
...

You can use partitioning with aggregate functions to determine whether to count the record in different time periods:

select 
distinct ID
, Today = SUM(CASE WHEN CreatedDate >= DATEADD(day,...

Does this work for you:

select
[Period]
,[Site]
,ISNULL(b.SACC,a.Account) as [Account]
,SUM([Value]) AS [Value]
from
xdbExample a
LEFT JOIN xsumExample b
on b.ACC = a.Account
GROUP BY
[Period]
,[Site]
,ISNULL(b.SACC,a.Account)

What problem are you trying to solve by renaming the solution?  It sounds like a version control problem (V1/v2) in which case you might be better off using GitHub or...

We rejected the notion of a complete redesign over complexity and risk.  We would have to remap 6,000 source to destination columns.  Also trying to extract 6,000 columns from a...

Hi Phil,

There is only one import file which is delimited with column names in the first row.  The structure is outside my control and I cannot change it. ...

According to this link https://msdn.microsoft.com/en-us/library/ms141747.aspx only you can open the package. For all others, the sensitive information is replaced with blanks.

In my experience, when I have had to store...

Temp tables only persist which the connection that created them is still active.

Why do you want a temp table?

Best practice is to create a persisted table...

Hi Rocky,

You cannot use a Lookup as this is an exact match only and between is not permitted.

There are a number of ways that you could do this

1. Do the...

I used SSIS against an Oracle DW a few years ago.

Generally it wasn't too bad but the oracle drivers for SSIS are not as good as the ones fro SQL...

I think this is a logic problem.

If a record is 'n/a' then is does not equal 'n/a~' so it is true.

Try changing the || or && (i.e. OR to AND).

Jez

Also, do you have Rows per Batch set to anything or Maximum insert commit size set?

These can affect insert performance.

Jez

Generally I use OLEDB sources and destinations in data flow tasks.

Try changing both the source and the destination to OLEDB.

Jez

Have a look at this:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e7987d8c-4f90-4ce1-9ba6-e3460b01248c/is-it-possible-to-extract-data-from-microsoft-word-docx-from-ssis?forum=sqlintegrationservices

I've not tried it and it looks just as problematic as importing from Excel.

Jez