I fortunately discovred whats wrong, and I want to share this experience may it help other people in the forum
In fact, if you have more than an sql server instance within your server or box or machine and you dont specify the server name then the bcp connect to the default instance by default, then if your data table stored procedure or what
ever it is, is stored within one of the named instances and Of Corse if you dont specify that server named instance full name, then the Native error = 208 will be raised and this is obviously logic because the data source that
you are handling exists within the named instance and not on the default one, hence the command must be
bcp <databasename.schema.tablename> in|out <complete target path where data will be imported|exported> -S<Full server named instance name> -T |or specify credentials through -P/-U -c|-n
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.