Mark,

       This issue has been resolved. I was not using the server name(-S) flag. Using this resolved my issue.

Thanks,

Srinivas.

Hey Brian, I tried the following syntax and it worked

osql -Uscott -Ptiger -Ssvippagu-2000\sqlserver2000.

svippagu-2000 is the host and sqlserver2000 is the name of the sql server. I wonder why I have...

I can login successfully with the sa account.

Thanks,

Srinivas.

When I installed I think Windows authentication is the default one, but I later changed it to mixed mode from the by right-clicking on the server -->properties-->security. Yes,Scott is set...

AJ I tried your suggestion and I still couldn't login :

C:\Documents and Settings\svippagu>osql -Uscott -Ptiger -Ssvippagu-2000

Login failed for user 'scott'.

What do you mean by "scott user set-up properly". Is there...

Thanks Darrell !!! It worked.

Thanks for the response. I am not using the BULK INSERT task in my mapping. I am using the Transform data task. Are you advising to change this. Below is...