Hmmm,

First thing to check is that the ActiveX Script is doing what its supposed to be doing:

1. Right-click on the ActiveX script and select "Execute Step". Click the message boxes...

Is this what you want?

select

 *

from mytemp

where

 item <> 'BIKE'

or (item ='BIKE' AND userid = 'MANAGER')

???

Regards

GODDAMIT. I've just seen where the problem is - and its entirely my fault, my sincerest apologies.

Try the following:

Function Main()

 dtstr = CStr( DatePart( "yyyy", ...

I imagine the eror you are getting is something like "Unknown connection". Am I right?

Try "Text File (Destination)" instead of "Test File (Destination)"

Spot on. You have the choice of VBScript or JavaScript!

Kris,

It is hard to look at the code and decide which is line 7 (strange but true).

Try commenting out (using an apostrophe) each line one at a time until it...

You don't get Enterprise Manager/Query Analyser type tools bundled with it. I believe there is a downloadable lite-administration tool. Scout around on microsoft.com - its there somewhere I'm sure.

Thats where...

Kris,

The name of your connection is simply "Text File (Destination)".

So, the code you want is:

DTSGlobalVariables.Parent.Connections("Text File (Destination)").DataSource = "\\sun\Kris\I52_Invoice" & dtstr & '.txt'

If I were you I'd change the...

I have just come across this forum for the first time having been a regular visitor to SSC since I joined about 4 months ago.

Is the monthly competition going to...

Data driven query (DDQ) tasks are built to do exactly what you want to do - trouble is performance is bad because it does row-level processing using uncompiled script code.

Essentially...

How did you get on Kris?

Loads of ways

1. Are the records timestamped? If so you can keep track of the maximum value in the timestamp field from the imported records, store it somewhere in a...

Would the author care to post their definitive explanation due to the explanation being offered up on the QOD page being the explanation of YESTERDAY's QOD (well it was when...

Hi Kris,

A few tips.

1. When you look at your DTS package in the package designer your connection object will have a name which is displayed with it. Lets call that <conn_name>

You need...

You may have to elaborate on what the problem is.

DTS doesn't allow you to have the multiple statements where? In an Execute-SQL task? It should do...

One other thing. The syntax...