create table varchartest(a varchar(30),b varchar(30))

create table varchartest_1(a varchar(30),b int)

insert into varchartest

--values

select 'xyz','1'

union all

select 'abc','2'

union all

select 'bcd','3'

union all

select 'efg','4'

union all

select 'erer','5'

--union all

--select 'rerer','x'

union all

select'rerer','7'

-- Edit

insert into varchartest_1(a,b) select...

In SQL or Dataware housing , this question asked in interview

Hi,

Diff b/w SQL server 2008 and Sql server 2008 R2 as below :

2008 :

1. added new data type Date, time , Geospatial and timestamp with internal time zone

2....

Thanks for reply 🙂

i have already written the code to get the executable task from SSIS using C# but i need to access the column of ole db source and...

Thanks a lot for your reply , but i have tried this url but i didn't get suitable information.

Can you please tell me which one you are telling

Hi ,

I want to read the DTSX file from C# and read all the object from that ole db source and old db destination and how many column we have...