Hi Ken,

May I ask, when I import the txt file to SQL using SSIS, if I add a column Linenumber of type identity and let it fill in when importing...

That works!  Thanks so much for your help, Ken.

Regards,

Ddee

• This reply was modified 4 years, 2 months ago by  Dee Dee-422077.

Hi Ken,

There is no relationship between line begin with a 1 and line begin with a 2 except they are next to each other.

So my guess is this cannot be...

Hi Ken,

1. I meant in the result- the first 2 rows have all data fill because it has row start with 3 right below row start with a 2

Column1       Column2      ...

Hi Ken,

Sorry, I wasn't very clear.. Below is a better test data and what I try to accomplish.  Thanks.

INSERT INTO MyTable

VALUES ('2 0A1234 CD00000000614150000000067823000 000000000000000')

,('3000000003815100000000000000000000000000000000005411500000000000000000000000000')

,('2 0A2345 DE00000000123150000000032478000 000000000000000')

,('3000000004639200000000000000000000000000000000003421500000000000000000000000000')

,('2 0A1256 FW00000000234190000000032517000...

Hi Thom,
Thanks for your reply... but I need to have other steps to run if step 2 failed.

Can you please advise me with the question below:

Hi Thom,
Sorry to confuse you but the job set up as:
step 1  on success go to next step; On failure Go to next step
step 2  on success go...

Thanks ZZartin. The 1st suggestion is the one I need but when I run the query. It's extremely slow..i wait for 10 minutes and still executing even...

hi jshahan,

I would like everything from table1 plus any record in table 2 where id is match with table1.

Thank you

Thanks for the static solution.. But nn my table has thousand of rows so I really need the dynamic solution.

Best,

Dee

Hi Jeff,

Thanks for a quick reply.

The maximum price per itemid is 2.

Also the ItemID is dynamic

Thanks,

Dee

Thank you. It works.

Dee

Thank you all, Your solutions work for me

Best,

Dee

Thank you all.

I tried to use SSIS Import and Export Wizard and data import it great except that it bring all the Quotation mark in. How do I get...

Thank you so much for your reply. It's really help me to understand the basic concept that I need for starting working with Data ware house.

I have one more...