OptionA:

With XACT_ABORT ON ,I tried to record the error message and rollback action into the database table but when there is an error the transaction automatically roll back and nothing...

Thanks Lowell. It worked great.

All those values are stored in one database table and some of them are integers and some are varchar and I am building this string in a sql query to...

Thanks for your help.

Hi I am able to parse the xml file when it has less than 1000 records. But some of the files have more than 40000 rows. So when I try...

Thanks for the help. It worked for me.

Thank you all.

we are going to receive 10000 rows per day and each row will have around 19 columns.

Securoty wise we will be able to receive either by an API call or...

Yes, I created an sqlserver login to access the application. I was able to query data from all the tables but not able to access one table and getting this...

I am not able to enter new table name even though I selected OLEDB Destination instead of SqlServer Destination.

In this case I dont see the New button at all next...

Hey,

It worked.

Thank you very much.

In the visual studio I am not able to drag and drop the database objects into the blank xsd file from the server explorer. Any ideas?

Thanks.

I have around 60 tables in the database and need to create .xsd file for all the 60 database tables(create table script and indexes and relationships).

Create table script for all...

Hi lynn,

Thanks for your help.

Hi Pradeep,

I need to have a comma between each location. Mark's idea was very close to my requirement .

Thank you very much for your help.