Thw ay I tend to approach this type of issue is to decide whether or not:

a) The statements are related in some way. E.g Do they insert into the same...

How are you accessing sql server via access? Check to make sure the linked tables are fine if you are using that route.

Or if you are using a dsn, make...

A bit slapped together, but will work for you.

declare @thestring as varchar(100)

declare @i as int

declare @goback as int

declare @counter as int

set @thestring = 'sasas fdfdfewew wwrwewr'

set @i = 1

set @counter...

What you need to do is search for vbscript examples as that is what activex uses. Also, if you record a macro in excel and then view the code, you...

Nice one, Anatol. I was overcomplicating it, trying to get a workaround.

I assumed that would stop the @@rowcount from working, but I have checked BOL and you are right.

"The @@ROWCOUNT...

I may be missing something here, but why not just use the "Send Mail Task" in the dts package.

Saves a LOT of messing about and is easy to use. A...

The only way I can think of achieving this is to use a global variable of an output type.

However, the problem you have is that you can only have...

If anyone were to come into my company and see how these generic lookup tables have completely eradicated referential integrity and made data warehousing a total nightmare, they would stay...

Load a dts package in design mode. Select

I didn't know you wanted to expand the functionailty to the folder level.

I found this page much easier to follow and I have been using the technique for a year...

As far as I know or have found out, there is no way of retrieving the value of a source file within an activex script. If anyone has the code,...

How are you kicking off the application?

Is it by typing this on the command line?

dtsrunui.exe

Dts packages run on the client so you will find that if you are referencing the c: drive to locate the ini file, the c: drive will be the client...

In theory it is possible to call a stored procedure through activex, but you would have to find a way of looping through a row, calling the sp, looping through...

Unfortunately dts is not built to handle row by row data except for transformation purposes, which it is very good at.

I cannot think of a way of passing each row...