Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-19 : 21:38:14
|
| Sameer Valluri writes "Hi!I know I can depend on you guys to solve almost anything (including SQL problems)I am facing a problem in transfering data from a delimited text file on an IIS server to a SQL Server 7.0 table at run time.The IIS and SQL Server7.0 are on different servers. After dumping the data into temp tables I have written Stored Procs to validate and manipulate the data.I have made a DTS package to do the job.Since the file to be uploaded does not have a fixed path or filename I have to pass them as a variable at run time to invoke the DTS package.What is the method (Syntax) of executing the package with an input parameter from ASP. I'll be eagerly awaiting your response on this." |
|
|
|
|
|
Problem in DTS