DTS Package SQL Server 2000

[woony]

Hi

I've created a dts package that executes a sql - statement, the resultset is put into a global variable and with that I use a vbscript that goes through the resultset, makes textfile and emails the specific file to someone in the company.

Now a problem occurs. The sql server uses sql authentication it has a username with a blank password. But when I save my connection with the blank password it fills in some ****** password which makes the connection not usable for the sql-statement. And I don't get results.

Anyone an idea how I can keep the password blank ?

The error message I get when I try to build my Query is: HResult of 0x80004005 ( -2147467259) returned Unexpected error occured. an error result was returned without an error message.

thx

[ck9663]

Hi

I've created a dts package that executes a sql - statement, the resultset is put into a global variable and with that I use a vbscript that goes through the resultset, makes textfile and emails the specific file to someone in the company.

Now a problem occurs. The sql server uses sql authentication it has a username with a blank password. But when I save my connection with the blank password it fills in some ****** password which makes the connection not usable for the sql-statement. And I don't get results.

Anyone an idea how I can keep the password blank ?

The error message I get when I try to build my Query is: HResult of 0x80004005 ( -2147467259) returned Unexpected error occured. an error result was returned without an error message.

thx

I'd take it this is a problem on your vb apps and not on the DTS package?

-- CK

[woony]

true... I redid whole my code and It got fixed :)
so my bad ;)

[antonopn]

I'm interested in the way you can assign a result to a global variable and use it through VB.

I'm trying to do exactly the opposite.

Can you send me a sample code on how you do the process?
Or a link-guide on how can I do one of these?

Thanks in advance!