@lalit sir.. the plan is now to use linq or clr store procedure. Can u suggest which one is better and why.

Don't need link server. Simply give..

select * from databasename..tablename

Hi Pravasis,

thanks for reply. can u tell me how to do that in two dataset. Because there are loop, temp tables, insert, update, delte in some sp's. Is it possible...

Hi Steve,

We are now migrating some part of one vb 6 application to .net. The database for vb 6 is sql 2000 and it will be in one server. In...

1. Select only those columns in source which are required.

2. Increase max row size and max buffer size.

3. Avoid asynchronous transformations.

4. Try to do order by and aggreate by sql...

Hi,

Your question is not clear. If you want to insert data into sql server with unicode then you can take help of data conversion.

Regards,

Ashis

Hi,

Please add data viewers in dataflow and check whether records are inserting in destination or not.

Regards,

Ashis

Hi,

The Sql code will be

insert into tbDestination

select 1,col from tbSource

select top 3 sal from order by sal

Use constraint

Goto jumpstarttv and see videos.

You can check http://www.jumpstartstv.com and then database link.

take one string variable and assgin the file name to it. and give the expression to it. the file name will be added in your dataflow.