Install database on existing MSDE server with unknown SA password?

Question regarding the MSDE SP3a install process...
What happens if I attempt to install MSDE on a server that already has MSDE
installed and the SA password has been changed to an unknown password? Can
I still install an instance for my database without knowing the SA password?
If not, how can I get around this issue?
I can see my app/database being installed at a customers site that already
has a version of MSDE for a different application they have already
installed and are using.
Thanks,
Jim K.
You should be able to install using Windows authentication, assuming you
know the password for an administrator on the box.
With that, you can also reset the sa password for an existing instance using
sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
"Jim K" <krusej@.megsinet.net> wrote in message
news:u$W9756gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Question regarding the MSDE SP3a install process...
> What happens if I attempt to install MSDE on a server that already has
MSDE
> installed and the SA password has been changed to an unknown password?
Can
> I still install an instance for my database without knowing the SA
password?
> If not, how can I get around this issue?
> I can see my app/database being installed at a customers site that already
> has a version of MSDE for a different application they have already
> installed and are using.
> Thanks,
> Jim K.
>

Inserting XML with SSIS - VERY URGENT!!!

Hello everybody,

I have a problem. I need to insert an unknown number of xml files in a database (all files are always in the same folder), in different tables, each file has the same name that the corresponding table. For example:

Files Tables

user.xml user

purchase.xml purchase

...and so

but the number of files is not always the same, I mean, it can be 6 one day and only 4 the next day.
Can I insert the data in the xml files into the tables with a Foreach Loop Container or any other way? If it's possible, how?

Thanks in advance for your help,

Radamante71

You might want to post your question at SQL Server Integration Services forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1.

Inserting with XML files - VERY URGENT!!!

Hello everybody,

I have a problem. I need to insert an unknown number of xml files in a database (all files are always in the same folder), in different tables, each file has the same name that the corresponding table. For example:

Files Tables

user.xml user

purchase.xml purchase

...and so

but the number of files is not always the same, I mean, it can be 6 one day and only 4 the next day.
Can I insert the data in the xml files into the tables with a Foreach Loop Container or any other way? If it's possible, how?

Thanks in advance for your help,

Radamante71

Create a ForEach Loop task to read the files from the directory and assign the name to a variable. Then add a dataflow task to the foreach loop and in your XML source file, select "XML File from variable", then select the variable name.|||

Tom suggestion will work if all file/tables had the same structure, which I doubt. To the original poster: I think what you want to accomplish is not possible. Basically you are asking to create the source-to-target data mapping on the fly and that is something you cannot do in a SSIS package (at least to my knowledge).

Rafael Salas

|||

Rafael,

One question:

Do you speak spanish? Because if you do, we can continue in spanish. I'm spanish and I think that I can explain you my problem in a better way if I do it in my language.

Thanks

|||You are correct. I don't see any way to use a variable XSD file.

However, you could use the "Inline Schema" in the file, that would work.|||

Radamante,

Yes, I do speak; but I don't think it would be a good idea to continue this thread in Spanish; that could irritate some non-Spanish speaker folks in this forum. If you want, send me an e-mail with your problem (be sure to de-spam my email address before) to see if I can help you.

Rafael Salas