By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

DTS Package SQL Server 2000

P: 11
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
Apr 17 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
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
Apr 17 '08 #2

P: 11
true... I redid whole my code and It got fixed :)
so my bad ;)
Apr 21 '08 #3

antonopn
P: 42
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!
Apr 22 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.