Help with ordering the SSIS packages the way they appear in the project

In solution explorer under SSIS Packages there are many packages. I name them specifically so that they should be ordered with their names, but no the solution explorer shows them in the order I added them, I couldn't figure out a way but removing all the packages and adding them in the right order to fix that problem. I have to kinda redo this if I want to add a new package not to the end.

Any ideas?

All here: http://solidqualitylearning.com/blogs/erik/archive/2005/08/08/1269.aspx

-Jamie

|||Thank you, I didn't want to edit the configuration without knowing what I was doing.

help with LIKE syntax...

HI All,

I am writing some code where i want to get a list of all the company names that start with say, M...

here is what i have:

Dim M_company, companyID_M
Set M_company = adoCon.Execute("SELECT company FROM tbl_exib WHERE company LIKE 'm%'")
companyID_M = M_company( 0 )

but this is only returning the first company in the list that starts with M. Can anybody help with getting it to return more than one value?

thanks,
Leissa1. this is a 'classic' ASP question. this is an ASP.NET forum.
2. that code is doing exactly what I'd expect it to
3. you've neglected to loop through the returned recordset. are you new at this by any chance?|||hmm...yes i am... how'd you guess? :)

so i need to loop something to make it read all the records? any help on how i can do this?|||couple of things :

1. take a decent beginner's tutorial. try www.asp101.com, www.aspin.com, www.4guysfromrolla.com - it'll fill you in on more than a simple forum post.
2. use a classic ASP forum - the ASP.NET snobs here will either ignore your question or tell you you're behind the times (they're wrong, but hey). try www.aspmessageboard.com - you'll usually find me there answering questions.

it's like this

While not recordset.EOF
 ' do stuff here
recordset.moveNext()
Wend

|||Thanks for your help in pointing me in the right direction... :)

i am using the while not statement like this:

Dim M_company, companyID_M, allRecords
' create a recordset
Set allRecords = Server.CreateObject("ADODB.Recordset")
While NOT allRecords.EOF
Set M_company = adoCon.Execute("SELECT company FROM tbl_exib WHERE company LIKE 'm%'")
companyID_M = M_company( 0 )
allRecords.MoveNext
WEnd

however i get this error:

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/spiritxmas/displayExhibList_M.asp, line 17

Any quick fix? or should i just start over with the tutorials...

thanks,

Leissa