Attaching Incremental data

I have a blank SQL database that will be generated with tables transferred
from an outside source. Once the tables are there, on a daily basis,
incremental data will be sent to an FTP folder in order attach them to the
original tables. What I need to know is how to attach the incremental data t
o
the tables. I know i'll probably schedule a job to run DTS to transform the
data from the FTP folder to the SQL server, then another job to attach the
incremental data once in SQL server to the tables. I need help with the
stored procedure I should use to attach the incremental data.
Thanks
TSTS,
Attach? I think you mean import. Anyway if there are not a ton of records
and you require some data manipulation then DTS would be the way to go. And
you're right scheduling the DTS package as a job will help automate the
import. You'll probably only need one DTS package/job to make this work.
As for the stored procedure help...that's pretty much impossible without
knowing your table structure, data, file format, etc... Please provide us
with more information as you get closer to implementing this solution.
HTH
Jerry
"TS" <TS@.discussions.microsoft.com> wrote in message
news:36C4AC57-E243-4FB1-BDE1-F1A3E3EE06A5@.microsoft.com...
>I have a blank SQL database that will be generated with tables transferred
> from an outside source. Once the tables are there, on a daily basis,
> incremental data will be sent to an FTP folder in order attach them to the
> original tables. What I need to know is how to attach the incremental data
> to
> the tables. I know i'll probably schedule a job to run DTS to transform
> the
> data from the FTP folder to the SQL server, then another job to attach the
> incremental data once in SQL server to the tables. I need help with the
> stored procedure I should use to attach the incremental data.
> Thanks
> --
> TS|||Refer to the post from earlier today titled: "Efficiently Inserting 1
Million records".
"TS" <TS@.discussions.microsoft.com> wrote in message
news:36C4AC57-E243-4FB1-BDE1-F1A3E3EE06A5@.microsoft.com...
>I have a blank SQL database that will be generated with tables transferred
> from an outside source. Once the tables are there, on a daily basis,
> incremental data will be sent to an FTP folder in order attach them to the
> original tables. What I need to know is how to attach the incremental data
> to
> the tables. I know i'll probably schedule a job to run DTS to transform
> the
> data from the FTP folder to the SQL server, then another job to attach the
> incremental data once in SQL server to the tables. I need help with the
> stored procedure I should use to attach the incremental data.
> Thanks
> --
> TS|||Thanks for your response. I'm just curious and I want to make some researche
s
from my side on how to import incremntal data to tables? If you can give me
a
general idea on how to do this or tell me if I can find any documentation on
this.
Thanks
--
TS
"Jerry Spivey" wrote:

> TS,
> Attach? I think you mean import. Anyway if there are not a ton of record
s
> and you require some data manipulation then DTS would be the way to go. A
nd
> you're right scheduling the DTS package as a job will help automate the
> import. You'll probably only need one DTS package/job to make this work.
> As for the stored procedure help...that's pretty much impossible without
> knowing your table structure, data, file format, etc... Please provide us
> with more information as you get closer to implementing this solution.
> HTH
> Jerry
> "TS" <TS@.discussions.microsoft.com> wrote in message
> news:36C4AC57-E243-4FB1-BDE1-F1A3E3EE06A5@.microsoft.com...
>
>

Attachement generated by xp_sendmail

Hello folks, I am sending a email from sql server that consists of results of a query and that's working perfect.
When I open the text file generated by xp_sendmail in notepad it's OK, but when I open it in MS Word or WordPad, I see garbage characters in form of squares added to the content. Those sqare are unicode spaces equivalent to Nchar(140) or Nchar(0020) in SQL. I tried to replace them using the replace function :

declare @.foo varchar(8000)
set @.foo='select top 4 Replace(priMarykey,Nchar(0020),'') as primarykey,
Replace(Sitename,Nchar(0020),'') as Sitename,
Replace(REgNumber,Nchar(0020),'') as REgNumber,
Replace(ContactEmpFirstNames,Nchar(0020),'') as ContactEmp
from organisationsite'
EXEC master..xp_sendmail @.recipients = 'Bertrandk@.Holala.com',
@.subject = 'Test mail',
@.query =@.foo,@.no_header= 'TRUE',
@.message='some attachement',
@.attach_results = 'TRUE'
This does not work, the spaces are still in the file
Is there something I can do to correct this?
Thanks in anticipation for your help.

Hi,

what about converting your whole message to VARCHAR ? Will that work in your situation, or do you need additional stored information in UNICODE from your columns ?

set @.foo='select top 4 CONVERT(VARCHAR(4000),Replace(priMarykey,Nchar(0020),'')) (...)

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||I tried that but it did not help. I would like to know if everyone just uses notepad to open sql attachements or if they do use other text editors, do they also get the same problem that I am getting?|||

No, never has that problem, although dealing with UNICODE data. Could you please post you table definition in here ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word, Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-
Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net.. .
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word,
Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't
a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net...
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word, Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net...
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>