Nils Wolf wrote:
>try
>
>C:\>bcp DBA..Publisher In
>c:\newpubs.dat -c -t',' -r\n -Sserver -Uuserid -Ppassword
>
>Nisse
>
>> Hi,
>>
>[quoted text clipped - 16 lines]
>> C:\>bcp DBA.dbo.Publisher In 'c:\newpubs.dat -c -t, -r\n -Sserver -Uuserid
>> -Ppassword

> Hi Nil,
>
> The BCP is still not working it gives me an error message "Unable to open
> BCP
> host data file".
>
> I used Bulk Insert and I get a "Bulk insert data conversion error (type
> mismatch) for row 1, column 7 (EventDate). The trigger at the end of the
> statement is suppose to change the data type, but doesn't work when Bulk
> Insert .
>
> e.g:
> BULK INSERT PUBS.dbo.[Eventheader]
> FROM 'c:\abc.txt'
> WITH
> (
> FIELDTERMINATOR = ',',
> ROWTERMINATOR = ':\n',
> FIRE_TRIGGERS
> )
>
>
>
>
> Nils Wolf wrote:
>>try
>>
>>C:\>bcp DBA..Publisher In
>>c:\newpubs.dat -c -t',' -r\n -Sserver -Uuserid -Ppassword
>>
>>Nisse
>>
>>> Hi,
>>>
>>[quoted text clipped - 16 lines]
>>> C:\>bcp DBA.dbo.Publisher In
>>> 'c:\newpubs.dat -c -t, -r\n -Sserver -Uuserid
>>> -Ppassword
>
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200510/1