hi friends, thanks for this bunch of reply.... 🙂

but the solution is like keeping unique value in the column and allowing more than one NULL value....

but my doubt...

K, thanks

I have one more doubt...

Here is the table named test with coulmns ID and Name

create table test

(id int identity(1,1) primary key ,

name varchar(30) unique

)

when i insert records

insert into...

Hi ,

You jut need to rightclick the database , then select the Export option, it will open up the export wizard, there you need to specify the source(in your case...

Ok.. thanks

Regards,

M.C

Hi thanks for the reply,

I would like to know something like , how search is becoming faster when we create an index on that.

Thanks,

M.C

Hi, thanks for the reply .

Regards,

Mithun C

Hi,

What about creating one view, inwhich you can fetch the id and name , then within SP you can select the records from this view.

Kindly let me know if...

Ok , so in that case do you have any other go?

Hi thanks for the relpy,

I have tried using Data Flow Task , OLEDB Source , Flat File destination as bellow and was able to do it successfully

In control flow tab...

Hi thanks for the reply,

I have tried some alternative using expression and it is fine now.

Regards,

Mithun C

Thank you verymuch Ramesh.

I will try this...

Thanks & Regards,

Mithun C

Thanks Ramesh,

Let me know whether the steps Im folowing is correct or not,

1.In ControllFlow tab get the ForechLoop item

2.Set the Package level variable to the file location

3.In the expression get...

Thanks Ramesh,

So here how can I get the file extension to that variable? (this may be simple, but I'm just a beginner in SSIS 🙂 )

Regards,

Mithun