Link to home
Start Free TrialLog in
Avatar of dionisio_79
dionisio_79

asked on

how to pass initial catalog parameter to bcp

Hi Experts,
can I pass the initial catalog as a parameter to my bcp?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Avatar of dionisio_79
dionisio_79

ASKER


bcp "select * from dbo.app_bretella" queryout "C:\Documents and Settings\EE20019\My Documents\we.txt " -t ; -S ...SERVERNAME -d ...DATABASENAME -U secretoUR -P secretoUR -c
i GET AN UNKNOWN OPTION -d
are you sure you are using the SQL Server bcp, and don't have another bcp in the "path"?
that's what I have seen as usual reason for this "error"
sure, no other bcp executables in the path
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
tryied without spaces, same result
any other suggestions?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial