Remember:

Never assume anything because it can make a donkey out of u and me

Won't let me SUBSTRING('assume',1,3) 😀

I use SSIS and WinSCP.

That makes the day start off well 😀

Only just read it so I didn't notice what date it was from. Busy thinking of all the problems it would cause.

Good one. 😀

I found this. Useful whilst waiting for a file to ftp or download.

http://www.konesans.com/filewatcher.aspx

Ah.

That would explain why I couldn't find the b@##y st??%d table

Exactly that. Set password to empty ("") and SaveAs. Then the connection manager shouldn't complain.

$comments = @'

Script name: Remove-Password.ps1

Created on: Tuesday, July 03, 2007

Author: Kent Finkle

Purpose: How can I...

At least in 2k8 we have Intellisense otherwise it might be a tad difficult remembering which symbolic (or should that be shambolic) table is which 😉

Now was it...

My first thought was that you may be able to use Poweshell. A quick look around and I found this:

http://www.eggheadcafe.com/software/aspnet/34092087/can-i-open-a-password-pro.aspx

Just tried it out on a 2005 version and the pop-up appears but not on 2008 :w00t:

Nothing here unless I hold down CTRL, then I can click the link.

LogMeIn?

I know you might need help reading the screen but...

Duplicate post?

http://www.sqlservercentral.com/Forums/Topic887100-338-1.aspx

You just need to tweak Arjuns code a bit

create table #t(customernumber varchar(10), notes varchar(10), lastvisitdate smalldatetime)

insert into #t values(100000, 'text 1', '10.feb.2010')

insert into #t values(100000, 'text 2', '10.feb.2010')

insert into...

I use WinSCP. It supports UNC paths.