You could send the client the file + table structure + format file and ask
the client to use BULK INSERT tsql statement
You could send him the file and then use BULK INSERT task in DTS which will
let you create the format within.
You could use bcp.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"rajesh jacob" <rajeshjacob (AT) yahoo (DOT) co.in> wrote

dear Allan Mitchell,

thanks for your prompt reply. i tried this already by
sending him a sql script file and data file performing
BULK INSERT. OUR CLIENT doesnot have any power to execute
bulk insert and he can not copy any file in to the server
where data base lies.

i want to make a dts package that client needs to execute
that only which will perform the action.is it possible.i
mean only the package i can send ,the server details and
database ... the package has to take from a system or user
dsn as i can not choose any server while making a package
as its not accessible.

thanks

rajesh

You can then

1. Send him a DTS package (.DTS)
2 A VBScript file (This will call the package using the DTS object model)
3. Inside the VBS file ask for input from the person running it and pass
these details to the object model and set properties in your package i.e.
servername, databasename, filename etc etc etc.
4. A text file containing the data

So long as he has the DTS library on his box this should work.

The package will simply use a DataPump task.

If the guy you send it to does not have the DTS library installed then send
him detailed instructions on how to use OSQL (for the CREATE TABLE Script)
and BCP (For the import)


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"rajesh jacob" <rajeshjacob (AT) yahoo (DOT) co.in> wrote