And still helping after all that time. Same issue as above:  package configuration is overridden in Agent Job where a slash is part of a file path. Setting the parameters...

Yes and that won't work for non character data types either. Can you use DTS?

From Books On-Line:

BULK INSERT Northwind.dbo.[Order Details]

FROM 'f:\orders\lineitem.tbl'

WITH

(

FIELDTERMINATOR =...

Well, aside from that I can't help. Due to security I can't execute those SP's.

Edited by - jamestow on 03/21/2002 3:53:17 PM

A rather more simple way to do it (if you have rights to do so) is to use xp_cmdshell in the following manner.

CREATE TABLE TMP_TABLE (FILENAME VARCHAR(20))

INSERT INTO TMP_TABLE

EXEC...

Yes it is possible. If they are on the same server you can use fully qualified database.owner.table syntax. For example: select * from database1.dbo.customer

If they are on different servers...

From Books On-Line:

Description

Shows the text description of the selected column.

This can be accessed from Design Table in the Enterprise Manager.

Hope it helps.

Something like this would work. I included the table DDL for clarity:

CREATE TABLE TABLE1 (FULLNAME VARCHAR(20), EMAIL VARCHAR(30))

CREATE TABLE TABLE2 (IDEN NUMERIC(12) IDENTITY(1,1), FULLNAME VARCHAR(20), EMAIL VARCHAR(30))

INSERT INTO TABLE2 (FULLNAME,...