You are not going to get dts to do this easily as there is no built in functionailty in dts.

The way I approached this in the past is to perform...

If you are getting problems with the unc path, map a drive and use that instead.

I'm afraid I have never tried to do this. Perhaps someone else out there has attempted to do this and can help you out.

Create a global variable and assign it to the excel output filename.

To do so, select Package/Properties/Global variables. type in a global variable.

Add a dynamic Properties taask to the package. Looks...

Unless the transformation is the same, it's unlikely that the transformation mappings will work.

For example, if you have a spreadsheet with 5 columns as source and a table with 5...

I agree with PhillCart. Don't try to do something with a sql tool that is better handled by the application itself.

If you are trying to encrypt the password in the...

This article will show you exactly what you need to do.

http://www.databasejournal.com/features/mssql/article.php/3073161

More information required.

By looping, are you referring to an activex script that checks and executes previous steps etc...

???

Just checking that you changed the owner of the scheduled job rather than 'login under which the scheduled job runs'.

To make sure, I would login to the server as the...

As you have posted this in the dts forum, the functionality you require is a task known as 'Data Driven Query Task'.

Basically this is a task that perform updates, inserts...

It can be done, but you will have to be willing to do some legwork.

Step 1 - Investigate output paramater global variables. Basically these allow the result of a select...

Also try this:

http://www.sqldts.com/default.aspx?254

Have you tried adding a few dummy lines at the top that aremore than 255 characters and seeing what happens?

May steer you in a different direction.

I take it to mean that you want to switch to an identical table on another server.

Best way is to use the configuration ini file. This is the best article...

BLOB data stands from Binary Large Objects and may not be something you want to dts.

If it is, then this might help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;257425&sd=tech

I wouldn't recommend using RAISERROR as 100% reliable.

If an unexpected error occurs you will assume that the rowcount was zero when perhaps the table definition has changed. You want this...