Hi Jeff,

Let me know explain the scenario clearly,

i have a table called balance sheet as follows

Dept Acct Date credit ...

Hi,

First of all thanks your detailed reply and your kind coordination

sample data

Emp,Dept,EmpCode,join_date

surya,Admin1,A0012, 12.12.2008

rakesh,HR,T001, 10.12.2008

shree, Finance, F001,

shan,Tech,H002, 5.12.2007

as you said i am connecting flat file to look up transformation,...

Hi,

Would you like to explain what it is meant by

a) different rows via different routes

b) columns through

c) normal process

Thanks,

Surya

Hi,

Thanks for your detailed explanation. I am able to create successfully a sample package. I have few more doubts. I will mention them below

1) Is it possible to send multiple...

Thanks for SQLBOT and John Rowan Its working fine now

Surya

First of all thanks for your quick reply.

Exactly now i am trying like that

I have few quries in this

if we give connection string in expressions

by default what connection we...

Thanks for your reply. I will go through the article

Surya

I am thanking every body in this forum because all them spend their valuable time for me. Especially I am very much thankful to Jeff...

Thanks you Jeff, it worked. I changed my file into .prn format, then i got the solution. I am once saying sorry for giving trouble to  people here.

comma is delimiter of file

hi jeff,

I am sorry to if i have disturbed people here , but  i am  hitting the wall from the past 15 days,  the  excel file is as shown in...

First of all i plead sorry for writing  ur last name wrong, second thing  i query i ran was

BULK INSERT testcsvtable

   FROM 'c:\surya.csv ' 

    WITH  ( FIRSTROW = 2,...

Yes modem

The query i ran is as follows.

BULK INSERT dbname.dbowner.tablename  

FROM '\\machinename\path\Sample.csv'

   WITH

      (

         FIELDTERMINATOR = ',',

         ROWTERMINATOR   = '\n',

         FIRSTROW        = 2,

         ROWS_PER_BATCH  = 50000 

      )

The sample file i obtained...

HI modem,

              I am very much thankful to you

surya