OK, I understand. But will there be the same number of columns for every customer, or will the number of columns vary depending on the number of products for each...

celine.godines (10/28/2015)

---

I have the following results:

CustomerProductName ValueChargesNewCharges

13AZ 40005056

13BY 30023

13BX 50003536

13BW 16001312

13BV 107009392

13BU 7000109110

And would like to...

revanappa.shivanagi (10/28/2015)

---

Hi,

In my SSIS package , I have changed one of table column name from upper case to lower case for Ex."EMPLOYEEID" to "employeeid".

After changing case i am facing an...

Thanks Steve, I didn't know about this. Very useful.

shkoli (10/27/2015)

---

CREATE TABLE [dbo].[Managements](

[ManagementId] [int] NOT NULL,

[FTAManagementNo] [varchar](35) NULL

)

CREATE TABLE [dbo].[MgmtCountries](

[MgmtCountryId] [int] not null,

[CountryId] [int] null,

[ManagementId] [int] null ,

[FTAManagementNo] [varchar](35) NULL

)

i want to get only those ManangementId which is available...

Have a read here and see whether that helps you at all.

Even negatives can be coded in a positive way, to help avoid possible double-negative mistakes.

Rather than 'IsInactive', I'd use 'IsDead' or similar.

I also recommend SQL Compare, though if your databases are developed using VS DB projects, there is a Schema Compare tool built in.

Check the mappings on your OLEDB destination.

Each of the derived columns should map to its target column.

Your fact key columns should always have matching entries in their associated dim tables, even if that entry is -1 (unknown, N/A, or whatever default you choose).

Once you have this...

sqlbaby2 (10/26/2015)

---

Hi

I've data as below

1111 null ...

It's a warning, not an error. If you're happy with the suggested alternative, just go ahead.

Why use DATEPART(), when you can use YEAR() for this?

Change it to don't save sensitive and redeploy

david.dilworth (10/23/2015)

---

As a C# developer I believe it's better to show the intent of the code or schema with a positive naming convention. Therefore I'd definitely favour the "IsActive"...