You don't need to use ActiveX to pass a variable from one package to another; you can do this by correlating the inner and outer variables in the "Execute Package"...

No, the package does not have a hardcoded path.  You point it at a directory (global variable "gv_FileLocation") and it loops through it and imports all files.

cl

PS:  You could also...

Sam's idea is good, only you should use a real table instead of a temporary one; Like dynamic SQL, using temp tables is bad for optimization.

If the schema for each file is different, you're on your own (hope you're good at VB!).  If every file is the same, though, you can modify the package in...

Kanga,

I'm having a hard time understanding what you are trying to do.  It seems like a simple update process that needs to happen once an hour, where it would be...

Ferrell,

When you think about it, your case statement is simply another array of values.  This could also be represented in a table, and could be processed much more efficiently. ...

Not just XML, but there is a whole world of interoperability opening up with Web Services, and XML (SOAP) is becoming quite popular. As a DB developer in a web dev group I've...

use pubs

declare @sql varchar(8000),

  @TableName sysname

select @TableName = 'authors'

select @SQL = isnull(@SQL + char(9) + sc.Name + ' = isnull(' + sc.Name + ', ''<NULL>'')', '') + char(10)

from  sysobjects so (nolock)

JOIN syscolumns sc...

"Where exists (Select NULL From....)" should probably be changed to "Where Exists (Select 1 From...)", but I'm not sure that will change anything.

I think your problem has to do with...

Joe,

I could not get your query to run on MS SQL 2K.  There were problems with the substring functions (From..For...), plus problems using || (is this two bitwise ORs).

Why is...

Alright, even though this will compile, the way you're handling transaction is funky.  You're opening a transaction in the procedure, and commiting/rolling back the transaction in the trigger.  While technically...

 strQ.Parameters.Add("@JobId", SqlDbType.SmallInt).Value = JobId

@JobID is declared as an Output parameter.  It's been a while, but I believe you have to declare output parameters differently.  Usually I don't use output parameters...

No, haven't read it. 

I've used a variation of your "nested set" model to build a navigation tree for our company website (I do webdev as well as DBdev).  It...

>>I had two advantages over you;<<

Quite a few more than that, I imagine!    Thanks for the input; I will look for these "portability...

Joe, your point is quite applicable when handling more complex functionality like vectors.

But, sometimes there is only one question with one yes/no answer. The only way I know to explicitely enforce...