You are bound to get more than 500 rows as there is a one to many relationship between the tables.

In order to bring back one contact only, use a max()...

There is nothing to the dtsrun utility other than that I wrote.

However, if you are passing paramaters for variables then you need to add that in:

/A "VariableNameString":"8"="a Value for the...

Alteratively select @@rowcount from a sql statement and use a raiserror if @@rowcount = 0.

See this related article.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=224372#bm225473

I would try out this site:

http://www.sqlis.com/

It is the ssis equivalent of the sqldts.com site

Don't bother messing around with vb files or dmo. Use this:

See this article that helped me do such a thing. I now have an asp page that calls the dts...

Do not use this encrypted version. You will find that if you modify the package it will not work.

I am sure that the encryption refers to the version when you...

You will need to write an activex task to do so, but it is possible.

You don't need to install excel as far as I know, but you will have to...

For anyone interested the code to get outlook details is as follows:

Function fnGetMailDetails()

Dim olApp As New Outlook.Application

Dim objName As Outlook.NameSpace

Dim folder As Outlook.MAPIFolder

Dim objMailItem As Outlook.MailItem

Set olApp =...

I've never used a microsoft datalink, but why don't you use a regular ODBC connection instead. That way you can change a DSN to point to a different database.

Basically there are two ocassions where you can run an active x script.

1. As a job step - Select ActiveX Script Task.

This runs a script that is not directly related...

The point here is that the code above is ONLY applicable to an activex script attached to an actual transformation task. As duplicate source and destination names are not allowed,...

IIS on a server is all I use.

It's very easy to use. You just create a virtual directory and point it at a physical folder. The the web address is...

Additionally you can use the 'Transfer sql server job' task using dts. That way you can tick the boxes to copy over multiple jobs in one go.

declare @x as int -- for counter

declare @y as int -- for number of insert statements

set @x = 0

set @y = 10

while @x <= @y

begin

--put insert statement...

Best thing is to search the web for something. I don't know of any offhand I'm afraid.

With regards to asp, if you have a knowledge of visual basic or java,...