Hi Ronnie,

@@servername also returned NULL. I have used addserver with out 'Local' option. Will try that and will update the post accordingly.

Hi there,

This will defintely work but some point we might face repeatation. Possible solution is to consider identity column on the table.

Ta

Hi,

Thank you for your script. But I think all the numbers generated on a day will fall in to same value. For eg. If I have to create a 10...

Slick,

Yes it makes more sense to use Outer. Thank you SSC Journeyman for your help.

Ta

Hi Matt ,

yeh, It worked... My brain should have been drained out !!!! 🙂

hi jack,

At last I did create a table and used it.

Thank you

Hi Paul ,

A great thank you because this was exactly the same problem with my other post http://www.sqlservercentral.com/Forums/Topic741031-145-1.aspx were I was using PIPE as delimiter. Accidently it...

Hi Paul,

I have specified that option already. I think problem lies either at the record or process level.

Error

Bulk Insert fails. Column is too long in the data file...

Hi Paul,

Thats exactly where the problem was!!

Thank you

Rene. May be in future we might use SSIS for ETL but as of now we will be using BCp or BULK Insert. I will go through the link ....

yes that what I figured it out as well. I will need to use BCP or Bulk Insert instead of DTS PACKAGE. According to my knowledge Bulk insert will provide...

Hi yeh,

This bulk operation is carried out using following statement in DTS package.

select fields from table.

This statment performs bulk insertion and Im not sure how to set...

I will look in to BOL then update the post

HI Flo,

As there are no time stamp columns on the table , I have considered trigger option. I will using triggers to write information about insert/update/delete to the view which...

We need to get updated data. Let me clearly explain my scenario.

Source and target's datamodel are different and that I wrote stored procedure to load bulk data which take...