Excel To DataBase (Duplicate Recoards)

for example i exported student table with sno as (PK)

how to handle the upload twise (som of the records already in the data base )

1) How to ignore the existing records in the database

2) How to modify the records which is already exist in the database

1) EXCEL DATA SOURCE(STUDENT.XLS)

2) DATA CONVERSION

3) DESTINATION DATABASE (SQL SERVER 2005 STUDENT TABLE)

this is i have please tell me how to ignore/update the exisitng records

koti

It may be a good idea to load the excel data into a staging table first. This would give you a lot more flexibility than trying to run sql statements on the excel file.

To ignore duplicate records, you could then just do a look up from the staging table to the destination table and only load the rows that fail the lookup.

To update the records is a bit more tricky, as you have to use the OLE DB Command and write the SQL statement yourself.

Hope this helps,

Chris

|||

from the 1st page of this forum:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1211340&SiteID=1

Excel Rendering Question

When a report is exported to Excel, each page in the report becomes a
worksheet. The worksheets are named as 'sheet 1', 'sheet 2' etc. Is there
any way to name the sheets as page headings?Hi Sanjay,
My grouping is exactly the same. However, I also have pagebreakatend set:
<Grouping Name="list1_Country_Name">
<GroupExpressions>
<GroupExpression>=Fields!CountryName.Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
A.
"Sanjay" wrote:
> I have the following grouping element in my report:
> <Grouping Name="list2_Details_Group">
> <GroupExpressions>
> <GroupExpression>=Fields!customer_name.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> Excel is rendered as each customer in a different sheet but I also need the
> sheet name to be =Fields!customer_name.Value.
> Andrew,
> Can you post the rdl extract where your groupings are named?
> Thanks
> Sanjay
> "Andrew Byrne" wrote:
> > I have seen this whenever I export to Excel and have my report grouped. For
> > example, if I group by country then excel will render with each sheet=a
> > country. In my case the country names were written to the Sheet Name, so
> > maybe you just need to name your groupings in the report?
> >
> > "Sanjay" wrote:
> >
> > > When a report is exported to Excel, each page in the report becomes a
> > > worksheet. The worksheets are named as 'sheet 1', 'sheet 2' etc. Is there
> > > any way to name the sheets as page headings?

Excel page setup / Email subscriptions

Hi,
I'm a newbie when it comes to Reporting Services, so please bear with me.
I am having 2 issues:
1) I am trying to get an exported Excel report to automatically select the
correct paper size. I have a report that is fairly wide, so I set the
report page up to 14" x 8.5" (Legal) and set the margins to .25" on each
side. Based on the limited info online, I was hoping this would translate
into Excel's Page Setup, but I was wrong. When I open the resulting Excel
workbook, the pages are set up as Landscape (which I hoped would happen),
but they are still Letter (11" x 8.5") sized. Is there any way to force
Excel to include Legal in the page setup?
2) I set up several Windows users with the role "Browsers" in Reporting
Services. I want them to be able to subscribe to a report via email. When
the user creates a new subscription, the "To" field is disabled, and is
populated only with their Windows username (ie, "jmarx"). The email
generated by the system fails (I think) due to not being able to resolve the
username into an email address. The server being used to send the emails is
Exchange 2000, and everything is integrated with Active Directory. If I go
to the Reporting Services site (I have all permissions on the site), I can
set up a new subscription with no problems, as the To, Cc, and Bcc fields
are all enabled and I can type in the full email address(es) as needed. The
email(s) get sent with no issues that way. Any ideas on how to map the
usernames to email addresses, thus allowing users with only "Browser" access
to subscribe to reports?
Thanks in advance for any help you can offer!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]Jake,
I have the same problem. When a user (with "browser" privledges)
subscribes to a report, only their "username" show up in the TO: box
for email and it is greyed out so they can't change it. Hopefully,
someone from Microsoft is monitoring this board and will provide a
solution...
Pete|||Hi Pete,
hradecky wrote:
> I have the same problem. When a user (with "browser" privledges)
> subscribes to a report, only their "username" show up in the TO: box
> for email and it is greyed out so they can't change it. Hopefully,
> someone from Microsoft is monitoring this board and will provide a
> solution...
I finally figured that one out from searching google groups, but I'm not
entirely happy with the answer. You can enable this field by changing the
following in your RSReportServer.config file:
<SendEmailToUserAlias>True</SendEmailToUserAlias>
to
<SendEmailToUserAlias>False</SendEmailToUserAlias>
I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
and that will be appended to all users' aliases. So if all your users are
in the same domain for email purposes, you could leave
<SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
Unfortunately for me, I have users in 2 domains, so this won't work. I
would really like to know how to map user aliases to email addresses, but I
haven't had the time to figure it out yet (or if it can even be done).
Changing <SendEmailToUserAlias> to False gives me an interim solution
anyway.
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Did you ever find your answer to your printing question? We're having
the same sort of problem.
"Jake Marx" <msnews@.longhead.com> wrote in message news:<urY4CcemEHA.1908@.TK2MSFTNGP14.phx.gbl>...
> Hi Pete,
> hradecky wrote:
> > I have the same problem. When a user (with "browser" privledges)
> > subscribes to a report, only their "username" show up in the TO: box
> > for email and it is greyed out so they can't change it. Hopefully,
> > someone from Microsoft is monitoring this board and will provide a
> > solution...
> I finally figured that one out from searching google groups, but I'm not
> entirely happy with the answer. You can enable this field by changing the
> following in your RSReportServer.config file:
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> to
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
> and that will be appended to all users' aliases. So if all your users are
> in the same domain for email purposes, you could leave
> <SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
> Unfortunately for me, I have users in 2 domains, so this won't work. I
> would really like to know how to map user aliases to email addresses, but I
> haven't had the time to figure it out yet (or if it can even be done).
> Changing <SendEmailToUserAlias> to False gives me an interim solution
> anyway.|||Did you ever find your answer to your printing question? We're having
the same sort of problem.
"Jake Marx" <msnews@.longhead.com> wrote in message news:<urY4CcemEHA.1908@.TK2MSFTNGP14.phx.gbl>...
> Hi Pete,
> hradecky wrote:
> > I have the same problem. When a user (with "browser" privledges)
> > subscribes to a report, only their "username" show up in the TO: box
> > for email and it is greyed out so they can't change it. Hopefully,
> > someone from Microsoft is monitoring this board and will provide a
> > solution...
> I finally figured that one out from searching google groups, but I'm not
> entirely happy with the answer. You can enable this field by changing the
> following in your RSReportServer.config file:
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> to
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
> and that will be appended to all users' aliases. So if all your users are
> in the same domain for email purposes, you could leave
> <SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
> Unfortunately for me, I have users in 2 domains, so this won't work. I
> would really like to know how to map user aliases to email addresses, but I
> haven't had the time to figure it out yet (or if it can even be done).
> Changing <SendEmailToUserAlias> to False gives me an interim solution
> anyway.