Did you check your data?, dose it has any extra tab in between to columns?

As far as i think you can achieve all this in one sp itself.

First use bulk insert in your sp by building the dynamic sql

After the data is inserted...

May be your data is having tab in between the row's.

Why don't you try dts?

I found one more way to get the result, but I am not sure will this give the perfect result all the time.

select...

This query should work in best way....

SELECT *

  FROM sysobjects

WHERE OBJECTPROPERTY(id,'IsMSShipped')=0

   AND xtype = 'P'

I think the data in file for column 15 in first row is more then the column size in DB. 

Let me first explain about MSDB.

if your db has some jobs shedule on it, all the information related to those jobs are stored in MSDB db which is system db,...

Following is the code i got of getting my result.

SELECT name FROM master..sysobjects WHERE xtype = 'P' and status > 0

Try this

FIELDTERMINATOR = ''\t'',-- this is for tab

ROWTERMINATOR = ''\n'' -- this is for new line 

Try creating non-clustered index for table T2888_1900_1 on which your joning condition works.

Oho you got me man…

June 16, 2006 at 7:12 am