Because I'm trying to break normalization. If I followed your example, the system would try to insert multiple primary keys. For example, if I had a name in...

Boy I hate M$ idea of a programming language. From a logical stand-point, I can have columns on both sides that are unused, but not include them in a...

Ok, I'll use that. It's just a mystery to me as to how/why this is all setup this way.

In our defense, this is the first time we've ever needed...

Ok, so what do I do? All I'm trying to do is check to see if there are records in a table before executing the step. I'm trying...

Ok, but I get a runtime error - "Object required: '[string: "select count(*) from"]'"

Here's what I have:

    dim oPkg
    dim oConn
   ...

So...

Dim oPkg

Dim oConn

Dim oRS

Set oPkg = DTSGlobalvariables.parent

Set oConn = oPkg.Connections("myConn")

Set oRS = CreateObject("ADO.RecordSet")

Set oConn.Open

Set oRS = oConn.Execute "SELECT COUNT(*) FROM myTable"

?? ...

No, I'm not trying to create a statement on-the-fly. All I'm trying to do is find out if a table has any rows (count(*)). If not, DTSStepScriptResult_DontExecuteTask.

Please note...

It does help, and even better, it's in direct opposition to the previous poster.

Could you post a code example (I'm not a VB coder)?

Thanks

I suppose I could do that. Do you know, though, how to execute a query through ActiveX?

Well, unfortunately, no, because I'm doing a bulk insert and need to return all newly created idents.

However, I think I've over-come the issue by reselecting back from the table I've...

Well, I hope that someone locked it down - is there any way to tell?

No, EXEC master.dbo.xp_cmdshell 'dir c:\' doesn't work.

The sp_start_job thing is fantastic; that's exactly what I needed.

Now,...

Well, I'm trying to integrate this as part of a larger process. I need to programically send a command to the SQL server to tell it to 'run' the...

You mean in a db? I suppose you could save it in a record as a varbinary... Maybe I don't fully understand the circumstance?

Well, I've looked in the Books, and I can't find anything really explicit or helpful. I've also read through the FAQ at sqldts.com, and tried their suggestions.

I, apparently, don't...

And, the other question is how do I execute this thing? I'd like to do it on command, but I'm not sure the best way. I've looked at...