Bulk insert task SSIS

Question

Post reply

Bulk insert task SSIS

ria_ray

Newbie

Points: 5
More actions
July 20, 2010 at 10:25 am

#141227

Hello,
I have an issue while using bulk insert task in SSIS
I am trying to load data from three different workstations in to my server database.
There are changes taking place in data from one particular workstation(say A workstation). the changes take place on a periodic basis. So I have to update the data in my server which the workstation A is sending in the form of a set of INSERT statements.
My issue here is: if one of the insert statement fails then the whole operation is abandoned. I am trying to construct my package in such a way that if an insert statement fails then the next insert statement should insert the values in to the database. Because of this the foreign key dependency should not b effected.
If any of you com across any ways to deal with this situation, do let me know. If you think that using bulkinsert is not the best approach and you have a different approach in mind, even then let me know.
Thank you,

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Phil Parkin

SSC Guru

Points: 247180

July 20, 2010 at 10:33 am

#1195667

Why do the INSERTs fail?

ria_ray Newbie Points: 5 More actions · Answer 2

The insert fails due to values i enter. The set of insert statement i am getting do have some errors in them , somtimes like the syntax error or somtimes like the wrong data is trying to be inserted in to the wrong column.

ria_ray Newbie Points: 5 More actions · Answer 3

The values I try to enter are from the a flatfile sent to me from the vendor with workstation A.

ria_ray Newbie Points: 5 More actions · Answer 4

I cannot make any changes to the insert stmts send to me by the vendor. I cannot add any stmt before or after the insert stmts.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 5

deepthiponguleti (7/20/2010)
I cannot make any changes to the insert stmts send to me by the vendor. I cannot add any stmt before or after the insert stmts.

Are you saying that a vendor gives you a file containing multiple INSERT statements? Eg

INSERT into T1(a,b,c) Values 1,2,3

INSERT into T2(d,e,f) Values 4,5,6

etc etc??

and that you are just trying to run whatever is in this file?

ria_ray Newbie Points: 5 More actions · Answer 6

The vendor sends me the multiple insert stmts in the form of a flat file. I cannot do anything with the data he sends. There is lots of data....... lots of values to be inserted in to the tables. I cannot do anything to the flat file.