 | |
DTS - Export from SQL to Excel
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS - Export from SQL to Excel -
04-18-2005
, 02:37 AM
#2
| |||
| |||
|
|
I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored proc and the file name (which i thru an active script task append with a timestamp). All is well but i get this error stating that "Microsoft Jet Database Engine couldnot find teh object Sheet1. Please nesure the object exists ....". How do i get around this? I know it is specified int eh destination table for the datapump from SQL to excel connection...but how do i work around it ??? Thanx |
#3
| |||
| |||
|
|
Try this In the excel sheet1 name the sheet the same as name of the stored proc. "big__smile" wrote: I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored proc and the file name (which i thru an active script task append with a timestamp). All is well but i get this error stating that "Microsoft Jet Database Engine couldnot find teh object Sheet1. Please nesure the object exists ....". How do i get around this? I know it is specified int eh destination table for the datapump from SQL to excel connection...but how do i work around it ??? Thanx |
#4
| |||
| |||
|
|
Hi, Thanx 4 ur help...but i cant do that coz i need to create a new file everytime the package is run  ...Lontae Jones <LontaeJones (AT) discussions (DOT) microsoft.com> wrote Try this In the excel sheet1 name the sheet the same as name of the stored proc. "big__smile" wrote: I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored proc and the file name (which i thru an active script task append with a timestamp). All is well but i get this error stating that "Microsoft Jet Database Engine couldnot find teh object Sheet1. Please nesure the object exists ....". How do i get around this? I know it is specified int eh destination table for the datapump from SQL to excel connection...but how do i work around it ??? Thanx |
#5
| |||
| |||
|
|
Hi All, Can someone plzz help with dynamic mapping of source and destination columns. Thanx big__smile (AT) hotmail (DOT) com (big__smile) wrote in message news:<299205ff.0504181420.f41c03c (AT) posting (DOT) google.com>... Hi, Thanx 4 ur help...but i cant do that coz i need to create a new file everytime the package is run ...Lontae Jones <LontaeJones (AT) discussions (DOT) microsoft.com> wrote in message news:<76A3ABF6-1B90-490E-8D7B-5E5401E300DD (AT) microsoft (DOT) com>... Try this In the excel sheet1 name the sheet the same as name of the stored proc. "big__smile" wrote: I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored proc and the file name (which i thru an active script task append with a timestamp). All is well but i get this error stating that "Microsoft Jet Database Engine couldnot find teh object Sheet1. Please nesure the object exists ....". How do i get around this? I know it is specified int eh destination table for the datapump from SQL to excel connection...but how do i work around it ??? Thanx |
#6
| |||
| |||
|
|
Ping me privately. I have a package that does this Takes a SQL Statement in the form of text Parses it Creates an Excel table Undo the previous mappings in the DataPump task Redo Mappings in DataPump task Fire. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "big__smile" <big__smile (AT) hotmail (DOT) com> wrote Hi All, Can someone plzz help with dynamic mapping of source and destination columns. Thanx big__smile (AT) hotmail (DOT) com (big__smile) wrote in message news:<299205ff.0504181420.f41c03c (AT) posting (DOT) google.com>... Hi, Thanx 4 ur help...but i cant do that coz i need to create a new file everytime the package is run ...Lontae Jones <LontaeJones (AT) discussions (DOT) microsoft.com> wrote in message news:<76A3ABF6-1B90-490E-8D7B-5E5401E300DD (AT) microsoft (DOT) com>... Try this In the excel sheet1 name the sheet the same as name of the stored proc. "big__smile" wrote: I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored proc and the file name (which i thru an active script task append with a timestamp). All is well but i get this error stating that "Microsoft Jet Database Engine couldnot find teh object Sheet1. Please nesure the object exists ....". How do i get around this? I know it is specified int eh destination table for the datapump from SQL to excel connection...but how do i work around it ??? Thanx |
#7
| |||
| |||
|
|
Hi Alan, Been trying to mail you but each time th email bounces back allan (AT) no-spam (DOT) sqldts.com>: host no-spam.sqldts.com[207.182.248.71] said: 550 5.7.1 Unable to relay for allan (AT) no-spam (DOT) sqldts.com (in reply to RCPT TO command) Is there another mail id that i cud use or may i plzzz request u 2 mail me on preetchadha (AT) hotmail (DOT) com Alternatively, can i download the code frm somewhere... Thanx "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote Ping me privately. I have a package that does this Takes a SQL Statement in the form of text Parses it Creates an Excel table Undo the previous mappings in the DataPump task Redo Mappings in DataPump task Fire. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "big__smile" <big__smile (AT) hotmail (DOT) com> wrote Hi All, Can someone plzz help with dynamic mapping of source and destination columns. Thanx big__smile (AT) hotmail (DOT) com (big__smile) wrote in message news:<299205ff.0504181420.f41c03c (AT) posting (DOT) google.com>... Hi, Thanx 4 ur help...but i cant do that coz i need to create a new file everytime the package is run ...Lontae Jones <LontaeJones (AT) discussions (DOT) microsoft.com> wrote in message news:<76A3ABF6-1B90-490E-8D7B-5E5401E300DD (AT) microsoft (DOT) com>... Try this In the excel sheet1 name the sheet the same as name of the stored proc. "big__smile" wrote: I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored proc and the file name (which i thru an active script task append with a timestamp). All is well but i get this error stating that "Microsoft Jet Database Engine couldnot find teh object Sheet1. Please nesure the object exists ....". How do i get around this? I know it is specified int eh destination table for the datapump from SQL to excel connection...but how do i work around it ??? Thanx |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.