I have a similar situation I resolved by

1) move the files from download directory to work directory. files are renamed with current datetime extension to avoid overwrite. the files...

I have a similar situation I resolved by

1) move the files from download directory to work directory. files are renamed with current datetime extension to avoid overwrite. the files...

Perhaps something in here would push you in the right direction:

http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=629

Thanks for the help.

Trying to learn this from an online tutorial which indicated the close had to come after each write to get the text to appear in the file....

I have been using this product for a number of years and have been very pleased with it.

However, I have XP Pro on this box and the latest version (v8)...

You create a new connection using one of the existing connections. This will make the visible and you can then delete it.

Click Connection - in the popup, click the...

Worked fine in W2K. Just won't work in XP, but your logic is sound. Something I will look into later. Deadlines looming

Laptop not normally connected to network.

Managed to get Partition Commander to split drive 0 into c: and d: - packages all work with references to D:.

Thanks for the look-see. Would...

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

duh!! Sending the link might help.

Discussion of some alternatives

Job stress is making me forget my manners.

wz700 - I do appreciate your investment of time in reviewing the question.

Your 2nd solution does return the same result as the...

I probably didn't explain this well enough

In the first result set (using the query of the 2nd solution provided by wz), the TerminationCode of CallId 119 is 'a' - so...

sp_helptext 'proc name' returns text of proc doesn't it?

Thanks again for the assistance. It looks like this will do exactly what I need and I can replace some hard coded stuff to make the package much more flexible.

On your...

Thank you very much for the push.

I modified slightly to get the xtype from the 2nd table and added all data types which concerned me.

Had to add master.. reference...