COM+ won't accept Identity for Admin account

People haven't answered my post on 'dev.component', 'programming.component',
etc. I don't know where else to post this..
Hello.
Somehow my Component Services is all messed up on our productions site.
Normally, in test and all other environments I need to click "Identity" in
Com+ and put in "run as" Administrator of some other account with
privileges. It always works fine, except now on our production site it says
"The user account or password entered is not valid. If you entered a domain
account, make sure the name is prefixed with the domain name". Well, I am
positive that the account I am using is correct and has full privileges. I
even created a new account and made it an admin account- then tried that
both with and without the domain account (domain\user). No matter what I
do, it does not accept accounts that are absolutely valid. I've been
working on this problem for some time and have tried everything I can think
of.
Any ideas?Is the SQL server installed on the same box? If not, then that could
be a problem. Is the Windows account mapped to a SQLS login and have
permissions in the database?
-- Mary
MCW Technologies
http://www.mcwtech.com
On Mon, 15 Dec 2003 14:56:17 -0500, "Tom" <none@.none.com> wrote:

quote:

---

>People haven't answered my post on 'dev.component', 'programming.component'
,
>etc. I don't know where else to post this..
>
>Hello.
>Somehow my Component Services is all messed up on our productions site.
>Normally, in test and all other environments I need to click "Identity" in
>Com+ and put in "run as" Administrator of some other account with
>privileges. It always works fine, except now on our production site it say
s
>"The user account or password entered is not valid. If you entered a domai
n
>account, make sure the name is prefixed with the domain name". Well, I am
>positive that the account I am using is correct and has full privileges. I
>even created a new account and made it an admin account- then tried that
>both with and without the domain account (domain\user). No matter what I
>do, it does not accept accounts that are absolutely valid. I've been
>working on this problem for some time and have tried everything I can think
>of.
>Any ideas?
>

---

ColumnNamesInFirstDataRow Expression

I have a SSIS package I am trying to create that will accept two types of files. They are the same exact file except for one contains a header and one does not. So I setup a conneciton manager to the csv file. I then set a variable of bool type, and then assigned that to the ColumNamesInFirstDataRow expressions property of the conneciton manager.

So the pacakge runs. Loops a directory, runs a script that sets the Header variable to true/false based on the file name. But when it gets to the data flow it always ignores the property and never bypasses the header row. The variable is being set. I tried datarowstoskip and set it to 1 instead of the above mentioned property, and that does not work either.

How can I accomplish this?

There is a known bug in evaluation of flat file connection properties that might be causing this. IT is scheduled to be fixed for the next release. Unfortunately, I do not see an easy workaround...

-Bob

|||Is there any know work around to this with .net code or anything else?|||

You could set up two connection managers (one with headers, one without) and two dataflows to match, and use a script task to check the file for a header row. Then use precedence constraints to pick the data flow to execute.

Or you could parse the whole file in a script source, but that could be a lot of work, depending on the complexity of your file.

ColumnNamesInFirstDataRow Expression

I have a SSIS package I am trying to create that will accept two types of files. They are the same exact file except for one contains a header and one does not. So I setup a conneciton manager to the csv file. I then set a variable of bool type, and then assigned that to the ColumNamesInFirstDataRow expressions property of the conneciton manager.

So the pacakge runs. Loops a directory, runs a script that sets the Header variable to true/false based on the file name. But when it gets to the data flow it always ignores the property and never bypasses the header row. The variable is being set. I tried datarowstoskip and set it to 1 instead of the above mentioned property, and that does not work either.

How can I accomplish this?

There is a known bug in evaluation of flat file connection properties that might be causing this. IT is scheduled to be fixed for the next release. Unfortunately, I do not see an easy workaround...

-Bob

|||Is there any know work around to this with .net code or anything else?|||

You could set up two connection managers (one with headers, one without) and two dataflows to match, and use a script task to check the file for a header row. Then use precedence constraints to pick the data flow to execute.

Or you could parse the whole file in a script source, but that could be a lot of work, depending on the complexity of your file.