I did migraed the dts package from sql server2000 now it is created as test1.dtsx in Business development visual studio. my question is how to call this package from the...

the same file works perfectly with Sql Server2000. we want to migrate all the dts to sql 2005 and it is giving me lot of issues and ofcourse we are...

Hi,

when i refresh the colum i am getting the same message again.

"the last row in the sampled data is incomplete the column or the row delimiter may be missing or...

Hi,

When i use the delimited file to export into the table, it is not seperating all the columns by semicolon. it is seperating only first 10 columns and rest of...

Hi,

I tried hitting enter at the end and now i am gettting differnt error

" You do not have permission to use the bulk load statement"

I am the local admin...

The row starts with 41

sergiy,

suppose if the C1 = 42 then end of the first set. what i want is i just want to move that row 42 above the 51 in that set...

I don't want all the rows to be order by that is the thing right. i want only set of rows order by:)

Thx

Sergiy,

Can you give me some idea using Select? appreciate your help

Thx

hi Sergiy,

i know order by. but this is not i want. one of the staging table has the data like this, see below

C1 C2 C3

41 te cc

51 te cc

42...

Jeff,

I know you are every where. I am just catching up some ideas to post to different forums. some body was telling to try this query, I haven't tried yet....

Jeff,

rbarryyoung is telling it is eaier with identity column. Do you know how to figure out with

identity column?looks like clustered index is not guaranteed as you said. any idea

Thx

Hi,

I can add identity column, Can you tell me how to sort order by. if possible can you show me the query ?

Thanks

Hi,

I am inserting this file into a staging table called Stage1 and it is in the format. C1,C2 and C3 are column Headers.

C1 C2 C3

41 te cc

51 te cc

42...

You are right, 2 id's have the same description. Thanks for your help