are you pointing to the correct machine? it should be something line \\machinesource\dirive\folder\file\import.txt

there should also be a map layout of your file on the ssis package.

hope this helps.

SQLProgrammer is also very good to use, specially when you know not or forget the syntax of commands or store procedures.

Hall of fame is correct. unless there is a secret that I do not know, you will also will have to take care of the developmet on the front end,...

You received a lot of sites to visit, but the best of all the oracle site.

is not as bad as it looks, I have been an oracle DB/SQL DBA for...

all suggestions are good, but I did not see anyone making the suggestion to have redundancy by having another server and having a standby database or for that matter replication...

Append just adds to a tape, override means write over an existing data on tape. the best method of back is to do it to backup to disk, then backup...

I Will Agree with SSCommited. the only change I would do is the retirement of the schinkage of the database. if this is the case, you need to redesign the...

Are you attempting to replicate table and data only, correct? if so you need to watch out for the way the table definitions and data structure manipulation. there is no...

Because oracle wants his login, you maybe able to impersonate, but as far as I know, oracle wants you to login.

hope it helps

Q. Have you attempted to fix the problem with unix server? if you have no rights to the windows from the unix box, it does not matter what you do...

all of these are good Questions, but you should know most of them, vendors for the most part do not care how the data is kept or how big the...

There is no ldf on Access, to migrate an application from access to SQL, you use the Upsize Wizard, if this is not available then you just create the database...

are you talking Data and Schema or just the Schema? You can use SSIS, DTS Depending on the server version, you can use a BCP to transport the data, The...

its always nice to have the fastes, meanest, mightiest machines available for SQL Server, but there is quite a bit, you need to learn about what the user requirements are;...

I do not understand the question. are you attenpting to create a database(or restore the db) and then create the user with a triggered?

am correct?