Basic Question about password and logon command

I have running SQL queries all day and have been getting tired of selecting the DATA SOURCE NAME and then having to type in the appropriate password. What can I add to my SQL command to do this for me?
Thanks for the help!
NormDo you mean like a connect line in your script?|||Originally posted by exdter
Do you mean like a connect line in your script?

Yes, exactly|||Is this what you mean?
The first line of your script should be
conn[ect] user/password/database
The problem with this is that your password won't be encrypted, so someone can see it.
I hope this helps.|||Originally posted by exdter
Is this what you mean?
The first line of your script should be
conn[ect] user/password/database
The problem with this is that your password won't be encrypted, so someone can see it.
I hope this helps.

Forgive my ignorance but I don't think I asked for the right thing.

Here's what I'm looking at....

I'm in Access and I run an SQL query such as:

select COUNT(*) from employee_data where title = 'Programmer'

and the next thing you know is a window pops up where I need to click on the "Machine Data Source" tab and then the appropriate "Data Source Name" which then has me type in my password.

Thanks for the help.

Norm|||Oh, sorry. I can't help with that one.
I don't know Access.

Bad data in source file kills package?

I'm reading data from sets of CSV source files with " text qualifiers. Most of the data is good, but I do run into some bad data that doesn't seem to get handled by redirecting rows. The type of data that is killing me is this:

"Business ID","Business Name","Business Phone"
"12345",""A" SPOT, THE ","555-555-5555"

Access sees this as an unparsable record and continues with the rest of the data. SSIS seems to choke on it. I've set the package to allow 1000 errors with no change.

I did set up an error file from my source file, with error output set to redirect row on error and on truncation. The error output seems only to show columns for "Flat File Source Error Output Column", "ErrorCode", and "ErrorColumn" too. (I'm sure there's a good reason, but I've found it really frustrating that it doesn't use the source file column mappings.)

What I'd like to do is redirect (or fix) the bad rows and continue with the rest of the load.

The Execution Results tab shows the following errors.

[Flat File Source [2082]] Error: The column delimiter for column "Business Phone" was not found.
[Flat File Source [2082]] Error: An error occurred while processing file "\\Share\Files\flat_file.csv" on data row 464.
[DTS.Pipeline] Error: The PrimeOutput method on component "Flat File Source" (2082) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.
[DTS.Pipeline] Error: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
[DTS.Pipeline] Error: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
[DTS.Pipeline] Error: Thread "WorkThread1" has exited with error code 0xC0047039.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0047039.

Any help would be much appreciated!

two years past...I encounter the same problem.

Just output the source file to other format: tab as delimiter, execl..... to skip the problem.

|||Hi lund,

This is because you were using " as text qualifier and there was a data that had value just the same as the text qualifier. The solution is you should replace the " of your data value with another character like '. Or just use another text qualifier.

Best regards,

Hery|||

The other two posters are correct. If you have any control over the source file consider changing the delimeter (to tabs) and/or the text qualifier (to something that doesn't appear in your text.)

Failing that, I have had some success in the past in pre-processing files. Basically you can load the file line by line, treating each line as a single record, and do some processing on the line to clean it.

Then you output the clean lines back into a new file.

Processing could be simple (eg count the number of commas in a row, or verify that if you split a row you get a set number of columns, and they are the correct width.)

Preferred approach is to fix the source data to export to something other than comma separated, though. There is a good reason that .tab files were invented!

Dylan.

BackupIoRequest::WaitForIoCompletion - Unable to find ryme or reason!

Event Type: Error
Event Source: MSSQLServer
Event Category: (6)
Event ID: 17055
Date: 8/11/2002
Time: 8:00:08 PM
User: xxxxxxxxxx
Computer: xxxxxxxxxx
Description:
18210 :
BackupIoRequest::WaitForIoCompletion: read failure on backup
device 'd:\mssql7\data\Debtors_Data.MDF'. Operating system error 1453
(Insufficient quota to complete the requested service.).

This is the event log view from a SQL7 No service pack server on a W2k server SP2.

The D: drive where the backup file is going has over 13GB free !

Has any one else had this error ? M$ have no information :(

Cheers

DaveRE:
read failure on backup device 'd:\mssql7\data\Debtors_Data.MDF'. Operating system error 1453 (Insufficient quota to complete the requested service.).
This is the event log view from a SQL7 No service pack server on a W2k server SP2.
The D: drive where the backup file is going has over 13GB free !
Has any one else had this error ? M$ have no information

Q1 Has any one else had this error ?
A1 This looks like it may be a disk quota related error.

Q2 The D: drive where the backup file is going has over 13GB free!
A2 Fine, but if disk quotas are enabled, how much is available on the D:\ drive for the service account under which sql server is running?

S1 Are you able to complete any (small) backup dumps? (If not, some DB may have already grown to meet an existing quota limit.)

S2 Try deleteing all existing backup files and then attempt a (very small) backup dump, say for master.|||Hi,

No Quota's are enabled

The 'Job' ran successfully the following morning after the initial error.

This morning (Tuesday) the Job ran successfully.

I am thinking that the Quota reference is 'system resources' rather than disk quota.

I think that even though the source is MSSQLSERVICE i believe its a W2K issue.

OS W2K SP2
1x 1Ghz CPU
Memory 2GB
Hardware RAID
2x Database.
Cataloging 3,2xx,xxx records (manual incremental population)

I have read where people have Service Packed there OS to SP3 but this still doesnt fix [there] problem

Dave|||RE:
Hi, No Quota's are enabled
The 'Job' ran successfully the following morning after the initial error.
This morning (Tuesday) the Job ran successfully.
I am thinking that the Quota reference is 'system resources' rather than disk quota. I think that even though the source is MSSQLSERVICE i believe its a W2K issue.

OS W2K SP2
1x 1Ghz CPU
Memory 2GB
Hardware RAID
2x Database.
Cataloging 3,2xx,xxx records (manual incremental population)

I have read where people have Service Packed there OS to SP3 but this still doesnt fix [there] problem Dave

Q1 [No Quota's are enabled]
A1 That's too bad it would have been an easy fix.

Q2 [I am thinking that the Quota reference is 'system resources' rather than disk quota. I think that even though the source is MSSQLSERVICE i believe its a W2K issue.]
A2 Well yes, kind of (probably); the API likely ends up calling the same lower level drivers in any case.

S1 The issue may also be related to driver corruption, driver coding issues / bugs and / or authentication and / or ACL issues. If you happen to have also very recently updated any disk / array drivers, you might consider either attempting to refresh the driver update(s) and / or undoing them?
As far as I understood there (were / are in 99 / 00?) some issues having to do with "IO set completion" that had / have something to do with switches between different levels of kernel drivers that array controller drivers initiate (maybe related, maybe not?).
As to authentication, I've seen (and experienced) problems with some network domains wherein every now and then the (domain controller?) decides the Sql Server / service account doesn't have the neccessary rights to dump wherever (usually, but not always, also accompanied by logon failures in the event log), which causes similar issues.|||Event Type: Error
Event Source: MSSQLServer
Event Category: (6)
Event ID: 17055
Date: 8/11/2002
Time: 8:00:08 PM
User: xxxxxxxxxx
Computer: xxxxxxxxxx
Description:
18210 :
BackupIoRequest::WaitForIoCompletion: read failure on backup
device 'd:\mssql7\data\Debtors_Data.MDF'. Operating system error 1453
(Insufficient quota to complete the requested service.).

This is the event log view from a SQL7 No service pack server on a W2k server SP2.

The D: drive where the backup file is going has over 13GB free !

Has any one else had this error ? M$ have no information :(

Cheers

Dave

Q1 This is the event log view from a SQL7 No service pack server?
A1 I missed that detail previously. If I read that correctly why is that? You may want to check out MS Q274310 (or "Why you may consider applying Service Pack 3 for Microsoft SQL Server 7.0")?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;274310