I don't entirely understand what it is you are doing.

Are you bringing the results from the dts task into a global variable used for the message?

If you are doing this. make...

See this previous topic:

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

I am not too sure that the sa password will show (unencrypted) in the package when exported to vb.

I was under the impression that...

If you are posting to an access database do not expect very soon.

It's not a good idea to export that many records in access anyway as you do not have...

The most important thing is to make sure the mail gets there. When people leave, change name etc, your mail will not work unless all the recipients are found with...

A quick and dirty way would be to:

a. Create a staging table somewhere that is populated by the mini

b. Do a select from the staging table. If no data...

The best thing you can do is use the 'Dynamic properties task'.

If you haven't used it before, let me explain.

Practically all of the objects in a dts package can be set from...

Why would you want to do it that way?

You are doing exactly the same thing as if you are declaring the value in the global variable by selecting properties/gloabl variabls...

Aplogies. Thought that explained how to install dts without sql. See this link:

http://www.windowsitpro.com/SQLServer/Article/ArticleID/7444/7444.html

You need to register the Microsoft DtsPackage Object Library on the server that you are trtying to create the object on.

If you look at MSDN, or http://www.sqldts.com they tell...

See this previous topic:

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

Glad to have helped. Outlook is so annoying when trying to resolve names. I have never found a way around other than the full mail address.

This link may help you:

http://dbforums.com/t502581.html

Make sure the recipient that you are supplying is recognised by outlook for definite.

Cut and paste the actual recipient string into outlook and click check names. Outlook doesn't recognise a...

I'm guessing that in your code you have something like

Select something from table where id = ?

The failures are probably happening when the global variable (= to ?) is set...

I have never really investigated before so I can't tell you what each option does.

However, I have always created with the user set to ''Self" and never had a problem.

I...