Hi Arun,Hi Jeff

Thank you very much for the reply.Replies are very helpful,learnt new things

Thanks once again

Yes thank you,that works

Hi there,

Thanks for the reply,but i also need records which doesnt have date set

For Example:

Value1 Value2 Date ...

Hi there,

The script provided works but in my case the table 2 is generated and contains data which is a result of other joins

so when i have a left outer...

hi,

i have a data flow task whose source connection flat file is a csv file located in remote location,the import of data works fine in bids and under msdb,but fails...

Hi,

Thanks for the reply,when i replace the flat file path to old remote location path ,its working but if i replace with the new remote location path it doesnt...

I am trying to work out how to control INSERTS to tables related with foreign keys,like some of the data may not be there when updated,while it was intial state...

Hi,

Booking Table Schema

BookingID(primary key),

bookingtypeID

.

.

BookingStates Table Schema

StateID (primary key) BookingID(primary key)

States Table Schema

StateID(primary key) StateName(Primary Key)

Booking Data ...

If i understood correctly, i need to specify 5 state variables and carry insert on them,please calrify and please suggest on how to carry update on this,some times a...

Hi,

I am still confused,whether to go ahead with lock or no lock on queries for example while one user is booking a product or editing a product and...

Hi,

I think you need to use Data Conversion component if you havent already before derived column and after flat file source component.

Hi

Its resolved now.Thanks very much

Hi,

Thanks for the reply, Can you please help in understanding on how the suitable code page can identified to set in the flat file source

Thanks

Of course yes.Thanks Bob and everybody.Hope I can help somebody on the forum like you people on one day when i get trained very well in T-SQL

Thanks

Hi Lutz and Bob,

I understand Lutz didnt mentioned not to post on sundays since intial post.I was only apologising that i have taken some of your time especially on weekend(of...