Dump file

Hi Everyone,
We have a SQL Server creates a dump file & stops the
service. Any help is highly appeciated.
SQL 2000 (SP3A) on a Windows 2000 Box (SP4)
Thanks,
================================================== =========
==========
BugCheck
Dump
================================================== =========
==========
This file is generated by Microsoft SQL Server
8.00.760
upon detection of fatal unexpected error. Please return
this file,
the query or program that produced the bugcheck, the
database and
the error log, and any other pertinent information with a
Service Request.
Computer type is AT/AT
COMPATIBLE.
Bios Version is PhoenixBIOS 4.0 Release
6.0
Current time is 13:27:01
06/18/04.
4 Intel x86 level 15, 3066 Mhz processor
(s).
Windows NT 5.0 Build 2195 CSD Service Pack
4.
Memory
MemoryLoad = 77%
Total Physical = 2046 MB
Available Physical = 465 MB
Total Page File = 3940 MB
Available Page File = 2463 MB
Total Virtual = 2047 MB
Available Virtual = 288 MB
*Dump thread - spid = 68, PSS = 0x52f031c8, EC =
0x52f034f0
*Stack Dump being sent to d:\Microsoft SQL
Server\MSSQL\log\SQLDump0001.txt
*
************************************************** *********
******************
**
*
* BEGIN STACK
DUMP:
* 06/18/04 13:27:01 spid
68
*
*
*
* Input Buffer 224 bytes -
* CREATE UNIQUE CLUSTERED INDEX [PK_promo] ON [dbo].
[promo] ([promo_id]
* ) WITH DROP_EXISTING ON
[PRIMARY]
*
*
* MODULE BASE END
SIZE
* sqlservr 00400000 00B2CFFF
0072d000
* ntdll 77F80000 77FFAFFF
0007b000
* KERNEL32 7C570000 7C622FFF
000b3000
* ADVAPI32 7C2D0000 7C331FFF
00062000
* RPCRT4 77D30000 77D9DFFF
0006e000
* USER32 77E10000 77E6EFFF
0005f000
* GDI32 77F40000 77F78FFF
00039000
* OPENDS60 41060000 41065FFF
00006000
* MSVCRT 78000000 78044FFF
00045000
* UMS 41070000 4107CFFF
0000d000
* SQLSORT 42AE0000 42B6FFFF
00090000
* MSVCIRT 780A0000 780B1FFF
00012000
* sqlevn70 41080000 41086FFF
00007000
* NETAPI32 027A0000 027EEFFF
0004f000
* SECUR32 027F0000 027FEFFF
0000f000
* NETRAP 02800000 02805FFF
00006000
* SAMLIB 02810000 0281EFFF
0000f000
* WS2_32 02820000 02833FFF
00014000
* WS2HELP 02840000 02847FFF
00008000
* WLDAP32 02850000 02879FFF
0002a000
* DNSAPI 02880000 028A3FFF
00024000
* WSOCK32 028B0000 028B7FFF
00008000
* ole32 02CA0000 02D8BFFF
000ec000
* XOLEHLP 02E10000 02E17FFF
00008000
* MSDTCPRX 02E20000 02ED3FFF
000b4000
* MTXCLU 02EE0000 02EEFFFF
00010000
* VERSION 02EF0000 02EF6FFF
00007000
* LZ32 02F00000 02F05FFF
00006000
* CLUSAPI 02F10000 02F1FFFF
00010000
* RESUTILS 02F20000 02F2CFFF
0000d000
* USERENV 02F30000 02F90FFF
00061000
* rnr20 02FA0000 02FABFFF
0000c000
* iphlpapi 02FF0000 03002FFF
00013000
* ICMP 03010000 03014FFF
00005000
* MPRAPI 03020000 03036FFF
00017000
* OLEAUT32 03040000 030DAFFF
0009b000
* ACTIVEDS 030E0000 0310EFFF
0002f000
* ADSLDPC 03110000 03132FFF
00023000
* RTUTILS 03140000 0314DFFF
0000e000
* SETUPAPI 03150000 031DDFFF
0008e000
* RASAPI32 031E0000 03212FFF
00033000
* RASMAN 03220000 03230FFF
00011000
* TAPI32 03240000 03261FFF
00022000
* COMCTL32 03270000 032F3FFF
00084000
* SHLWAPI 03300000 03364FFF
00065000
* DHCPCSVC 03370000 03388FFF
00019000
* winrnr 03830000 03837FFF
00008000
* rasadhlp 03840000 03844FFF
00005000
* SSNMPN70 03F40000 03F45FFF
00006000
* SSNETLIB 03F50000 03F64FFF
00015000
* security 042A0000 042A3FFF
00004000
* msafd 04B90000 04BADFFF
0001e000
* wshtcpip 04C00000 04C06FFF
00007000
* SSmsLPCn 04CA0000 04CA6FFF
00007000
* ntdsapi 04D80000 04D90FFF
00011000
* SQLFTQRY 063E0000 06411FFF
00032000
* CLBCATQ 06420000 064A5FFF
00086000
* sqloledb 064C0000 06532FFF
00073000
* MSDART 06540000 0655EFFF
0001f000
* comdlg32 06560000 0659DFFF
0003e000
* SHELL32 06630000 06877FFF
00248000
* MSDATL3 06880000 06894FFF
00015000
* oledb32 06D30000 06D95FFF
00066000
* OLEDB32R 06DA0000 06DAFFFF
00010000
* msv1_0 06DB0000 06DCEFFF
0001f000
* CRYPT32 06DD0000 06E47FFF
00078000
* MSASN1 06E50000 06E5FFFF
00010000
* xpsqlbot 06E60000 06E65FFF
00006000
* rsabase 07010000 07032FFF
00023000
* xpstar 08830000 08876FFF
00047000
* SQLRESLD 08880000 08886FFF
00007000
* SQLSVC 08890000 088A6FFF
00017000
* ODBC32 088B0000 088E1FFF
00032000
* odbcbcp 088F0000 088F5FFF
00006000
* W95SCM 08900000 0890BFFF
0000c000
* SQLUNIRL 10000000 1002CFFF
0002d000
* WINSPOOL 08910000 0892DFFF
0001e000
* MPR 08930000 08940FFF
00011000
* SHFOLDER 08950000 08957FFF
00008000
* odbcint 08B20000 08B35FFF
00016000
* NDDEAPI 08B40000 08B46FFF
00007000
* SQLSVC 08B50000 08B55FFF
00006000
* xpstar 08B60000 08B68FFF
00009000
* mswsock 08EF0000 08F01FFF
00012000
* xplog70 09960000 09971FFF
00012000
* xplog70 09980000 09983FFF
00004000
* dbghelp 06E90000 06F44FFF
000b5000
*
ec_buftrace.Entry [62]
bpage = 0x1A010000 bhash = 0x00000000
bpageno = (1:744605)
bdbid = 59 breferences = 8336 bstat
= 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [63]
bpage = 0x42F52000 bhash = 0x00000000
bpageno = (1:849240)
bdbid = 59 breferences = 1406 bstat
= 0xb
bspin = 0 bnext = 0x00000000
EXCEPT (null) @.0x0DCEC148
exc_number = 0 exc_severity =
0
exc_func = MSQLErrorHandler+0 Line 0+0x0
Under what circumstances do you see this? Also could you please paste the
"short stack dump" that is present in the error logs.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Dump file

Hi Everyone,
We have a SQL Server creates a dump file & stops the
service. Any help is highly appeciated.
SQL 2000 (SP3A) on a Windows 2000 Box (SP4)
Thanks,
=========================================================== ========== BugCheck
Dump
=========================================================== ==========
This file is generated by Microsoft SQL Server
8.00.760
upon detection of fatal unexpected error. Please return
this file,
the query or program that produced the bugcheck, the
database and
the error log, and any other pertinent information with a
Service Request.
Computer type is AT/AT
COMPATIBLE.
Bios Version is PhoenixBIOS 4.0 Release
6.0
Current time is 13:27:01
06/18/04.
4 Intel x86 level 15, 3066 Mhz processor
(s).
Windows NT 5.0 Build 2195 CSD Service Pack
4.
Memory
MemoryLoad = 77%
Total Physical = 2046 MB
Available Physical = 465 MB
Total Page File = 3940 MB
Available Page File = 2463 MB
Total Virtual = 2047 MB
Available Virtual = 288 MB
*Dump thread - spid = 68, PSS = 0x52f031c8, EC = 0x52f034f0
*Stack Dump being sent to d:\Microsoft SQL
Server\MSSQL\log\SQLDump0001.txt
*
***********************************************************
******************
**
*
* BEGIN STACK
DUMP:
* 06/18/04 13:27:01 spid
68
*
*
*
* Input Buffer 224 bytes -
* CREATE UNIQUE CLUSTERED INDEX [PK_promo] ON [dbo].
[promo] ([promo_id]
* ) WITH DROP_EXISTING ON
[PRIMARY]
*
*
* MODULE BASE END
SIZE
* sqlservr 00400000 00B2CFFF
0072d000
* ntdll 77F80000 77FFAFFF
0007b000
* KERNEL32 7C570000 7C622FFF
000b3000
* ADVAPI32 7C2D0000 7C331FFF
00062000
* RPCRT4 77D30000 77D9DFFF
0006e000
* USER32 77E10000 77E6EFFF
0005f000
* GDI32 77F40000 77F78FFF
00039000
* OPENDS60 41060000 41065FFF
00006000
* MSVCRT 78000000 78044FFF
00045000
* UMS 41070000 4107CFFF
0000d000
* SQLSORT 42AE0000 42B6FFFF
00090000
* MSVCIRT 780A0000 780B1FFF
00012000
* sqlevn70 41080000 41086FFF
00007000
* NETAPI32 027A0000 027EEFFF
0004f000
* SECUR32 027F0000 027FEFFF
0000f000
* NETRAP 02800000 02805FFF
00006000
* SAMLIB 02810000 0281EFFF
0000f000
* WS2_32 02820000 02833FFF
00014000
* WS2HELP 02840000 02847FFF
00008000
* WLDAP32 02850000 02879FFF
0002a000
* DNSAPI 02880000 028A3FFF
00024000
* WSOCK32 028B0000 028B7FFF
00008000
* ole32 02CA0000 02D8BFFF
000ec000
* XOLEHLP 02E10000 02E17FFF
00008000
* MSDTCPRX 02E20000 02ED3FFF
000b4000
* MTXCLU 02EE0000 02EEFFFF
00010000
* VERSION 02EF0000 02EF6FFF
00007000
* LZ32 02F00000 02F05FFF
00006000
* CLUSAPI 02F10000 02F1FFFF
00010000
* RESUTILS 02F20000 02F2CFFF
0000d000
* USERENV 02F30000 02F90FFF
00061000
* rnr20 02FA0000 02FABFFF
0000c000
* iphlpapi 02FF0000 03002FFF
00013000
* ICMP 03010000 03014FFF
00005000
* MPRAPI 03020000 03036FFF
00017000
* OLEAUT32 03040000 030DAFFF
0009b000
* ACTIVEDS 030E0000 0310EFFF
0002f000
* ADSLDPC 03110000 03132FFF
00023000
* RTUTILS 03140000 0314DFFF
0000e000
* SETUPAPI 03150000 031DDFFF
0008e000
* RASAPI32 031E0000 03212FFF
00033000
* RASMAN 03220000 03230FFF
00011000
* TAPI32 03240000 03261FFF
00022000
* COMCTL32 03270000 032F3FFF
00084000
* SHLWAPI 03300000 03364FFF
00065000
* DHCPCSVC 03370000 03388FFF
00019000
* winrnr 03830000 03837FFF
00008000
* rasadhlp 03840000 03844FFF
00005000
* SSNMPN70 03F40000 03F45FFF
00006000
* SSNETLIB 03F50000 03F64FFF
00015000
* security 042A0000 042A3FFF
00004000
* msafd 04B90000 04BADFFF
0001e000
* wshtcpip 04C00000 04C06FFF
00007000
* SSmsLPCn 04CA0000 04CA6FFF
00007000
* ntdsapi 04D80000 04D90FFF
00011000
* SQLFTQRY 063E0000 06411FFF
00032000
* CLBCATQ 06420000 064A5FFF
00086000
* sqloledb 064C0000 06532FFF
00073000
* MSDART 06540000 0655EFFF
0001f000
* comdlg32 06560000 0659DFFF
0003e000
* SHELL32 06630000 06877FFF
00248000
* MSDATL3 06880000 06894FFF
00015000
* oledb32 06D30000 06D95FFF
00066000
* OLEDB32R 06DA0000 06DAFFFF
00010000
* msv1_0 06DB0000 06DCEFFF
0001f000
* CRYPT32 06DD0000 06E47FFF
00078000
* MSASN1 06E50000 06E5FFFF
00010000
* xpsqlbot 06E60000 06E65FFF
00006000
* rsabase 07010000 07032FFF
00023000
* xpstar 08830000 08876FFF
00047000
* SQLRESLD 08880000 08886FFF
00007000
* SQLSVC 08890000 088A6FFF
00017000
* ODBC32 088B0000 088E1FFF
00032000
* odbcbcp 088F0000 088F5FFF
00006000
* W95SCM 08900000 0890BFFF
0000c000
* SQLUNIRL 10000000 1002CFFF
0002d000
* WINSPOOL 08910000 0892DFFF
0001e000
* MPR 08930000 08940FFF
00011000
* SHFOLDER 08950000 08957FFF
00008000
* odbcint 08B20000 08B35FFF
00016000
* NDDEAPI 08B40000 08B46FFF
00007000
* SQLSVC 08B50000 08B55FFF
00006000
* xpstar 08B60000 08B68FFF
00009000
* mswsock 08EF0000 08F01FFF
00012000
* xplog70 09960000 09971FFF
00012000
* xplog70 09980000 09983FFF
00004000
* dbghelp 06E90000 06F44FFF
000b5000
*
ec_buftrace.Entry [62]
--
bpage = 0x1A010000 bhash = 0x00000000
bpageno = (1:744605)
bdbid = 59 breferences = 8336 bstat
= 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [63]
--
bpage = 0x42F52000 bhash = 0x00000000
bpageno = (1:849240)
bdbid = 59 breferences = 1406 bstat
= 0xb
bspin = 0 bnext = 0x00000000
EXCEPT (null) @.0x0DCEC148
--
exc_number = 0 exc_severity = 0
exc_func = MSQLErrorHandler+0 Line 0+0x0Under what circumstances do you see this? Also could you please paste the
"short stack dump" that is present in the error logs.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Dump file

Hi Everyone,
We have a SQL Server creates a dump file & stops the
service. Any help is highly appeciated.
SQL 2000 (SP3A) on a Windows 2000 Box (SP4)
Thanks,
========================================
===================
==========
BugCheck
Dump
========================================
===================
==========
This file is generated by Microsoft SQL Server
8.00.760
upon detection of fatal unexpected error. Please return
this file,
the query or program that produced the bugcheck, the
database and
the error log, and any other pertinent information with a
Service Request.
Computer type is AT/AT
COMPATIBLE.
Bios Version is PhoenixBIOS 4.0 Release
6.0
Current time is 13:27:01
06/18/04.
4 Intel x86 level 15, 3066 Mhz processor
(s).
Windows NT 5.0 Build 2195 CSD Service Pack
4.
Memory
MemoryLoad = 77%
Total Physical = 2046 MB
Available Physical = 465 MB
Total Page File = 3940 MB
Available Page File = 2463 MB
Total Virtual = 2047 MB
Available Virtual = 288 MB
*Dump thread - spid = 68, PSS = 0x52f031c8, EC =
0x52f034f0
*Stack Dump being sent to d:\Microsoft SQL
Server\MSSQL\log\SQLDump0001.txt
*
****************************************
*******************
******************
**
*
* BEGIN STACK
DUMP:
* 06/18/04 13:27:01 spid
68
*
*
*
* Input Buffer 224 bytes -
* CREATE UNIQUE CLUSTERED INDEX [PK_promo] ON [dbo].
[promo] ([promo_id]
* ) WITH DROP_EXISTING ON
[PRIMARY]
*
*
* MODULE BASE END
SIZE
* sqlservr 00400000 00B2CFFF
0072d000
* ntdll 77F80000 77FFAFFF
0007b000
* KERNEL32 7C570000 7C622FFF
000b3000
* ADVAPI32 7C2D0000 7C331FFF
00062000
* RPCRT4 77D30000 77D9DFFF
0006e000
* USER32 77E10000 77E6EFFF
0005f000
* GDI32 77F40000 77F78FFF
00039000
* OPENDS60 41060000 41065FFF
00006000
* MSVCRT 78000000 78044FFF
00045000
* UMS 41070000 4107CFFF
0000d000
* SQLSORT 42AE0000 42B6FFFF
00090000
* MSVCIRT 780A0000 780B1FFF
00012000
* sqlevn70 41080000 41086FFF
00007000
* NETAPI32 027A0000 027EEFFF
0004f000
* SECUR32 027F0000 027FEFFF
0000f000
* NETRAP 02800000 02805FFF
00006000
* SAMLIB 02810000 0281EFFF
0000f000
* WS2_32 02820000 02833FFF
00014000
* WS2HELP 02840000 02847FFF
00008000
* WLDAP32 02850000 02879FFF
0002a000
* DNSAPI 02880000 028A3FFF
00024000
* WSOCK32 028B0000 028B7FFF
00008000
* ole32 02CA0000 02D8BFFF
000ec000
* XOLEHLP 02E10000 02E17FFF
00008000
* MSDTCPRX 02E20000 02ED3FFF
000b4000
* MTXCLU 02EE0000 02EEFFFF
00010000
* VERSION 02EF0000 02EF6FFF
00007000
* LZ32 02F00000 02F05FFF
00006000
* CLUSAPI 02F10000 02F1FFFF
00010000
* RESUTILS 02F20000 02F2CFFF
0000d000
* USERENV 02F30000 02F90FFF
00061000
* rnr20 02FA0000 02FABFFF
0000c000
* iphlpapi 02FF0000 03002FFF
00013000
* ICMP 03010000 03014FFF
00005000
* MPRAPI 03020000 03036FFF
00017000
* OLEAUT32 03040000 030DAFFF
0009b000
* ACTIVEDS 030E0000 0310EFFF
0002f000
* ADSLDPC 03110000 03132FFF
00023000
* RTUTILS 03140000 0314DFFF
0000e000
* SETUPAPI 03150000 031DDFFF
0008e000
* RASAPI32 031E0000 03212FFF
00033000
* RASMAN 03220000 03230FFF
00011000
* TAPI32 03240000 03261FFF
00022000
* COMCTL32 03270000 032F3FFF
00084000
* SHLWAPI 03300000 03364FFF
00065000
* DHCPCSVC 03370000 03388FFF
00019000
* winrnr 03830000 03837FFF
00008000
* rasadhlp 03840000 03844FFF
00005000
* SSNMPN70 03F40000 03F45FFF
00006000
* SSNETLIB 03F50000 03F64FFF
00015000
* security 042A0000 042A3FFF
00004000
* msafd 04B90000 04BADFFF
0001e000
* wshtcpip 04C00000 04C06FFF
00007000
* SSmsLPCn 04CA0000 04CA6FFF
00007000
* ntdsapi 04D80000 04D90FFF
00011000
* SQLFTQRY 063E0000 06411FFF
00032000
* CLBCATQ 06420000 064A5FFF
00086000
* sqloledb 064C0000 06532FFF
00073000
* MSDART 06540000 0655EFFF
0001f000
* comdlg32 06560000 0659DFFF
0003e000
* SHELL32 06630000 06877FFF
00248000
* MSDATL3 06880000 06894FFF
00015000
* oledb32 06D30000 06D95FFF
00066000
* OLEDB32R 06DA0000 06DAFFFF
00010000
* msv1_0 06DB0000 06DCEFFF
0001f000
* CRYPT32 06DD0000 06E47FFF
00078000
* MSASN1 06E50000 06E5FFFF
00010000
* xpsqlbot 06E60000 06E65FFF
00006000
* rsabase 07010000 07032FFF
00023000
* xpstar 08830000 08876FFF
00047000
* SQLRESLD 08880000 08886FFF
00007000
* SQLSVC 08890000 088A6FFF
00017000
* ODBC32 088B0000 088E1FFF
00032000
* odbcbcp 088F0000 088F5FFF
00006000
* W95SCM 08900000 0890BFFF
0000c000
* SQLUNIRL 10000000 1002CFFF
0002d000
* WINSPOOL 08910000 0892DFFF
0001e000
* MPR 08930000 08940FFF
00011000
* SHFOLDER 08950000 08957FFF
00008000
* odbcint 08B20000 08B35FFF
00016000
* NDDEAPI 08B40000 08B46FFF
00007000
* SQLSVC 08B50000 08B55FFF
00006000
* xpstar 08B60000 08B68FFF
00009000
* mswsock 08EF0000 08F01FFF
00012000
* xplog70 09960000 09971FFF
00012000
* xplog70 09980000 09983FFF
00004000
* dbghelp 06E90000 06F44FFF
000b5000
*
ec_buftrace.Entry [62]
--
bpage = 0x1A010000 bhash = 0x00000000
bpageno = (1:744605)
bdbid = 59 breferences = 8336 bstat
= 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [63]
--
bpage = 0x42F52000 bhash = 0x00000000
bpageno = (1:849240)
bdbid = 59 breferences = 1406 bstat
= 0xb
bspin = 0 bnext = 0x00000000
EXCEPT (null) @.0x0DCEC148
--
exc_number = 0 exc_severity =
0
exc_func = MSQLErrorHandler+0 Line 0+0x0Under what circumstances do you see this? Also could you please paste the
"short stack dump" that is present in the error logs.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

dtsx with config file?

Hi all

This is the situation: I've a dtsx package wich creates a tab delimited txt file from a sql server 2005 databasetable. Now this all works just fine. But what I want to do is that the user can choose the destination path of that created txt-file. Right now I've declared the path when I created the flat file source.

On the net I found that a config file for a dts package (sql server 2000 - Dynamic Property Task) could do the trick...

Any help plz?

thx!

There are a number of ways of doing this. You could use a configuration file but that would mean editing the configuration file each time and I don't think that's what you want to do.

You could change the value using the /SET option of dtexec.exe. Will that work for you?

-Jamie

DTS zipping a file

Hello there.
I have this DTS that creates 5 files. The last step on the DTS is anActiveX task that moves the files to a certain folder. Bun?t now what I really need to do is zip the file and leave it on the server.

This DTS is executed by a job on the SQL Server, and the files are created on a network share with access to the SQLServer user that executes the job.

I've been trying to find out information on how to zip the folder and I've come up with two options:

1. install winzip on the server and run winzip32.exe passing arguments to it.
2. use the standard zipfldr.dll that comes with Windows to do the job.

Number one is out of my reach since IT department don't want the software installed, I have to stick with number 2.

Now I've read that using rundll32.exe I can run the dll as an exe, but I need the entry point to the dll wich I cannot find besides the RouteTheCall %L, which actually opens an explorer window with the folder or zip file I pass to it as an argument.

Does anyone know if this is possible either using rundll32.exe or automating the task through an AttiveX task?

TIA.

I would really like to find the answer to this question as well but, I don't see any replies and I noticed that this posting is 8 months old. I also could not find any information on the web as of yet. If I find anything I will respond to this post.

Steve

|||I recently think of the 2nd method. But it's too difficult. If you find how to use the zipfldr.dll .Please tell me. Thanks a lot. And , I will tell me if I get a clear using.|||

I programming to compress the data. I want to call am usable zipfldr.dll with C#.NET programming, eager to know that must use which order in the calling uses. please tell me at jenkarn_7@.hotmail.com, thanks.

|||

I just searched for "zip file" on msdn... http://blogs.msdn.com/dotnetinterop/archive/2006/04/05/567402.aspx

|||Easiest method of compressing files is to use rar.exe (WinRar CLI).

rar -a C:\FilesToCompress\*.xxx C:\MyCompressedfile.rar

Can run that through a CLI in SSIS and DTS.

DTS zipping a file

Hello there.
I have this DTS that creates 5 files. The last step on the DTS is anActiveX task that moves the files to a certain folder. Bun?t now what I really need to do is zip the file and leave it on the server.

This DTS is executed by a job on the SQL Server, and the files are created on a network share with access to the SQLServer user that executes the job.

I've been trying to find out information on how to zip the folder and I've come up with two options:

1. install winzip on the server and run winzip32.exe passing arguments to it.
2. use the standard zipfldr.dll that comes with Windows to do the job.

Number one is out of my reach since IT department don't want the software installed, I have to stick with number 2.

Now I've read that using rundll32.exe I can run the dll as an exe, but I need the entry point to the dll wich I cannot find besides the RouteTheCall %L, which actually opens an explorer window with the folder or zip file I pass to it as an argument.

Does anyone know if this is possible either using rundll32.exe or automating the task through an AttiveX task?

TIA.

I would really like to find the answer to this question as well but, I don't see any replies and I noticed that this posting is 8 months old. I also could not find any information on the web as of yet. If I find anything I will respond to this post.

Steve

|||I recently think of the 2nd method. But it's too difficult. If you find how to use the zipfldr.dll .Please tell me. Thanks a lot. And , I will tell me if I get a clear using.|||

I programming to compress the data. I want to call am usable zipfldr.dll with C#.NET programming, eager to know that must use which order in the calling uses. please tell me at jenkarn_7@.hotmail.com, thanks.

|||

I just searched for "zip file" on msdn... http://blogs.msdn.com/dotnetinterop/archive/2006/04/05/567402.aspx

|||Easiest method of compressing files is to use rar.exe (WinRar CLI).

rar -a C:\FilesToCompress\*.xxx C:\MyCompressedfile.rar

Can run that through a CLI in SSIS and DTS.

DTS zipping a file

Hello there.
I have this DTS that creates 5 files. The last step on the DTS is anActiveX task that moves the files to a certain folder. Bun?t now what I really need to do is zip the file and leave it on the server.

This DTS is executed by a job on the SQL Server, and the files are created on a network share with access to the SQLServer user that executes the job.

I've been trying to find out information on how to zip the folder and I've come up with two options:

1. install winzip on the server and run winzip32.exe passing arguments to it.
2. use the standard zipfldr.dll that comes with Windows to do the job.

Number one is out of my reach since IT department don't want the software installed, I have to stick with number 2.

Now I've read that using rundll32.exe I can run the dll as an exe, but I need the entry point to the dll wich I cannot find besides the RouteTheCall %L, which actually opens an explorer window with the folder or zip file I pass to it as an argument.

Does anyone know if this is possible either using rundll32.exe or automating the task through an AttiveX task?

TIA.

I would really like to find the answer to this question as well but, I don't see any replies and I noticed that this posting is 8 months old. I also could not find any information on the web as of yet. If I find anything I will respond to this post.

Steve

|||I recently think of the 2nd method. But it's too difficult. If you find how to use the zipfldr.dll .Please tell me. Thanks a lot. And , I will tell me if I get a clear using.|||

I programming to compress the data. I want to call am usable zipfldr.dll with C#.NET programming, eager to know that must use which order in the calling uses. please tell me at jenkarn_7@.hotmail.com, thanks.

|||

I just searched for "zip file" on msdn... http://blogs.msdn.com/dotnetinterop/archive/2006/04/05/567402.aspx

|||Easiest method of compressing files is to use rar.exe (WinRar CLI).

rar -a C:\FilesToCompress\*.xxx C:\MyCompressedfile.rar

Can run that through a CLI in SSIS and DTS.

DTS using #temp tables

I have a rather complex SP that creates a #temp table and then populates tha
t
table using several select/inserts/update statements. I need the results of
this #table to be exported to external text file nightly so that our
mainframe FTPs can grab it.
DTS apparently wont let me use #temp tables. I get invalid object errors.
Ive heard of global ##temp, but even changing the table all the references
to be ##table isn’t solving the problem.
Is there commands I can place in the SP to create the external file without
using DTS, or can I define the #temp table in a way that DTS can see it?
Help appreciated
--
JP
.NET Software DeveloperHi
This seems similar to http://tinyurl.com/82fqd
Temporary tables have a limited scope see the section in:
http://msdn.microsoft.com/library/d...r />
_4hk5.asp
Depending on what you are trying to do, you may not require the temporary
table or you could use a permanent table that you clear down before each run
.
Alternatively using a derived table or use of the CASE statement may be
possible options.
John
"JP" wrote:

> I have a rather complex SP that creates a #temp table and then populates t
hat
> table using several select/inserts/update statements. I need the results o
f
> this #table to be exported to external text file nightly so that our
> mainframe FTPs can grab it.
> DTS apparently wont let me use #temp tables. I get invalid object errors.
> Ive heard of global ##temp, but even changing the table all the reference
s
> to be ##table isn’t solving the problem.
> Is there commands I can place in the SP to create the external file withou
t
> using DTS, or can I define the #temp table in a way that DTS can see it?
> Help appreciated
> --
> JP
> .NET Software Developer
>