Comments by xyz from Bangalore

xyz from Bangalore 7-Feb-14 6:26am View

video is not loading..

xyz from Bangalore 6-Jan-14 10:44am View

Hi, thanks for ur reply. I have to do bulk insert..I am binding gridview data to list. I have use same list for inserting data. how can i do it?

xyz from Bangalore 6-Jan-14 3:55am View

NO..I dont have any idea..can u plz help me.

xyz from Bangalore 6-Jan-14 0:49am View

T is class of items which contains both string and integer

xyz from Bangalore 6-Jan-14 0:05am View

I have generic list,I need to insert that to database. and bulk insert.

xyz from Bangalore 6-Jan-14 0:03am View

Yes, I have to insert generic list. and have to insert bulk.

xyz from Bangalore 5-Jan-14 12:26pm View

Thanks for your reply.I have list of items. I need to insert those items to database table.

xyz from Bangalore 11-Nov-13 6:01am View

Thank you thatraja

xyz from Bangalore 10-Jul-13 2:26am View

Hi Syed,
I want load xml files. Link is about excel files

xyz from Bangalore 27-Jun-13 1:46am View

Hi Prasad,
I saw links and tried to concatenate base path with file name but I am getting error saying that Subquery returned more than 1 value.I concatenated base path with file name selecting from table.
Can you please help me.

xyz from Bangalore 26-Jun-13 8:33am View

Can you explain me briefly.I need to store file name with extension and without extension and path of each file inside a folder.

xyz from Bangalore 26-Jun-13 6:11am View

In stored procedure it will read file name without extension and with extension. And I am inserting those two into a table along with file path.I want same process should loop through all files in a given folder path.

xyz from Bangalore 26-Jun-13 6:06am View

Hi Prasad,
I tried that also but I need to insert file name and path into another table.By above procedure I will get only single file foe specified path.This should happen for entire files in folder.

xyz from Bangalore 25-Jun-13 9:45am View

Hi Radhadeep,
It giving error when I execute procedure saying that the file does not exists.

xyz from Bangalore 25-Jun-13 0:29am View

Hi,
I used bulk insert task but its giving error saying 'String or binary data would be truncated.
The statement has been terminated'.
I have text file which contains some information separated by ','.The stored procedure should read file and store that data into table along with file name and location.

xyz from Bangalore 25-Jun-13 0:04am View

Sorry. I am not getting how to proceed this problem.Not getting how to read file so that it will store data into table.

xyz from Bangalore 24-Jun-13 23:55pm View

ya.

xyz from Bangalore 24-Jun-13 23:51pm View

Those are text files only but column delimiter is '*'.

xyz from Bangalore 24-Jun-13 1:38am View

Ya sure.In constraint evaluation operation I just changed Expression or constraint.And its working fine.

xyz from Bangalore 21-Jun-13 6:04am View

Thank you for ur response. I got solution.

xyz from Bangalore 21-Jun-13 5:09am View

No error. Its showing finished but not executing execute package task. control is not going to those package.

xyz from Bangalore 29-May-13 9:00am View

Ok,I wil try for that. Thank you...

xyz from Bangalore 29-May-13 8:50am View

I tried that but it is giving same error.Its giving error for 0

xyz from Bangalore 29-May-13 8:45am View

Sorry,I didnt get that.I am new SSIS. Where I need to hardcode connection string?

xyz from Bangalore 29-May-13 8:26am View

ya. I have given package scope and value to path of file

xyz from Bangalore 29-May-13 8:14am View

Its giving error for that provider expression, character number "0" is not recognized

xyz from Bangalore 29-May-13 8:06am View

Ya..

xyz from Bangalore 29-May-13 7:56am View

When I provided provider for connection string its giving error as "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + @[User::FileName] +
“;Extended Properties=\”Excel 8.0;HDR=YES\”;”
0 is not recognized.The expression cannot be parsed because it contains invalid element

xyz from Bangalore 29-May-13 7:51am View

Deleted

When I provided provider for connection string its giving error as "provider=...."
0 is not recognized.The expression cannot be parsed because it contains invalid element

Comments by xyz from Bangalore (Top 29 by date)