Here is the create table query for all of them.

CREATE TABLE [dbo].[IPv6_Daily_Reporting](

[DAY] [datetime] NULL,

[NODE_ID] [varchar](50) NULL,

[ADDRESS_CLASS] [varchar](50) NULL,

[ACCESS_POINT_NAME] [varchar](140) NULL,

[FULL_HANDSET_NAME] [varchar](150) NULL,

[TAC_LIST] [varchar](20) NULL,

[UNIQUE_MSISDN] [numeric](18, 0) NULL,

[UNIQUE_PDP_ADDRESSES] [numeric](18, 0) NULL,

[UNIQUE_MSISDN_PDP]...

Please find attached indexes information for each table.

Thanks

These tables have no indexes.so if i have to create index which column would be the best in each table .

please find attached query plan for that.

my sources are tables(oledb source)

I want to convert column_A varchar(20) to column_c Nvarchar(20) and Column_B Nvarchar(16) to column_c nvarchar(20).

is this right?

for source column_A having datatype varchar(20)

cast(ColumnA as Nvarchar(20))

for source column_B having datatype Nvarchar(16)...

I have one destination column with Nvarchar(20) and i want to load data from two columns and their data types are varchar(20) and nvarchar(16).so that's why i want to...

using slowly changing dimension transformation in ssis.

i am using code1 as business key ,name as type 2 and code as type 1 .

so then can i insert max value of that column instead of default -1 in place of null values.bcz my manager does want null values in foreign key table...

Is this possible that i can have in this format 12/31/2099 .if we will do like

ALTER TABLE [dbo].[test] ADD DEFAULT ((convert(int,convert(datetime,'12/31/2099')))) FOR [id]. it will set default 73048...

thanks this give me the result .but i donot want by this way .as i want based on workday(where workday='y').bcz i have another columns like workday_international which are all based...

ya. number of days in week means =monday to friday(working days).and for that in my table column workday has 'Y' or 'N'.where y=monday to friday and 'N' means saturday,...

ya..this is my table

CREATE TABLE dt3

(

dates DATETIME,

workday ...

i want the result in this way

insert into dt3 values(2012-03-04,'N','4','21','62','251'),

(2012-03-03,'N','4,'21','62','251')