MS SQL Data Warehousing - How can I pass the file to sql server ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How can I pass the file to sql server ?

IMRAN

2006-01-08, 8:23 pm

I have created a component which parses some flat
files and stores in Sql database. Now I want to move
that COM object to database server.

Now the scenario will be like this :

1) ASP page will get the file from the client

2) Then ASP page will call the stored procedure
alongwith the file data as parameter.

3) Store procedure will store that file on local hard disk
of databa server and will call the com object passing
the file path with name to it.

How can I pass the file to sql server ?

I am thinking about passing it as binary data.

Please advise !

Sponsored Links