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 - 2004-02-18 : 08:03:04
|
| Kishor writes "Dear Sir,Below are my application details.Step 1 . Download a zip file from the server periodically which is a csv file and contain product details separated by commas.Step 2. Unzip the zip file.Step 3. Retrieve Data from the text or csv file and insert data into database.Step 4. Modify the data with respect to other tables in the database.I have performed 1,3 and 4 tasks successfully. All the tasks are performed only after previous task was successfullt completed.To unzip a file i have an dll which does the work for me.Question : Can i add this dll in DTS - Custom Task and make use of it? If yes then please let me know.Awaiting for the answer" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-18 : 08:28:53
|
| Why not use winzip to do the unzip and call it from the command line.Why use dts for this?seehttp://www.nigelrivett.net/ImportTextFiles.htmlJust add an xp_cmdshell call to unzip the files.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS - Custom Tasks