Don't know of any definite reason why MS Access cannot be imported without locking, but I guess an open record may cause dts some confusion. Also, if a record is...

To be honest, it all depends on what suits your own environment and the method you will be displaying the data in.

For example, if you want to expose the data...

This code opens all files in a folder and unprotects them:

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim sFolder

Dim fso

...

The best way is to write a stored procedure that calls the package. That way you can control security to the package through the sp.

If you want them to choose...

You need to write activex task to bring up an input box. Here is the code:

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

DTSGlobalVariables("gvName") = inputbox("put your prompt text in here")

msgbox(DTSGlobalVariables("gvName").Value)

Main =...

That link is an article on xp_sendmail. It has nothing to do with the article in the original link.

Trust me. The smtp is FREE.

Are you sure you have to pay?

I never saw anything about that and a lot of people I know are using it for free.

If you follow these simple instructions, you can be up and running in no time using smtp rather than mapi.

Mapi required server configuration, installation of outlook etc, wherelse this does...

Check BOL for osql utility. This utility allows you to send the results of a slect query to a file from a command line. Various paramaters can be set along...

If you are looking to import the data I would investigate the possibility of using xml. There are plenty of freebie pdf ocnverters out there that convert to all types...

Although dts is a valid ETL tool, I would use the term ETL very loosely.

It's primary function is to move data from one table to another. Transformation is generally limited...

When scheduled to run, the package runds under the account that the sql server agent is logged in as. I suspect you have not chaged the password for that user.

DTS plays a guessing game with excel. It looks at the first 8 rows of data and then decides itaself what data type the column is and whether it expects...

SMTP is probably the best option for you. I use it and it is very reliable. See this link:

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

and this link:

http://www.sqldev.net/xp/xpsmtp.htm#Description

More often than not, errors are down to security. Check that the account that is trying to drop and create objects has the necessary permissions. Remember that if the job...