Sending Email using ActiveX Script task
Mon, 14 Jul 2008 22:29:00 -0700
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.
When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.
Is it possible to ...
|
Huonoja nuo Tenoxit
Mon, 14 Jul 2008 22:11:14 -0500
*Jälleen kerran on syytä tuoda esille sitä faktaa, erttä ydinvoima on
menneisyyden tekniikkaa ja tällaiset alla olevat mm. päästöttömän polton
laitokset tulevat VARSIN nopsaan syrjäyttämään ydinvoiman kaikilla
keskeisillä sektoreillaan. Ja hyvä niin! On suorastaan hävytöntä miten
systemaattisesti maamme ydinmono ...
|
Error 80004206a, no error message
Mon, 14 Jul 2008 14:11:02 -0700 (PDT)
I am trying to move data from a flat text file to an Oracle database,
using a DTS (it's a long story). I am using a DTS because some of our
servers are 2000 and some are 2005, so until everything is converted,
DTS is preferable to SSIS.
Right at the moment, I have a simple transform defined: one source (a
fl ...
|
where is it saved? - SQL 2005
Mon, 14 Jul 2008 13:22:01 -0700
Hi,
I created a DTS package using import/export wizard in SQL 2005 SP2
eviroment, then I saved it on server. However, when I looked for it, couldn't
find it in SMO. It is different from 2000.
Thanks a lot,
sg ...
|
Calling Sub Packages....
Fri, 11 Jul 2008 07:57:01 -0700
Hi,
I am trying to call a sub DTS package from the main DTS package. When i
trying to call, i am getting the following error.
Step 'DTSStep_DTSActiveScriptTask_1' already exists in the collection.
Please let me know what the issue is? Thanks in advance.
---------------------- ...
|
Latest updates in SQL server tools and techniques
Thu, 10 Jul 2008 18:21:52 -0700 (PDT)
Get the latest updates in SQL server 2008 tools and techniques and
more about database management, software testing, flowchart
prepartation and many more
http://www.sqlserversoftware.blogspot.com ...
|
Encrypt/Decrypt table columns inside stored proc?
Thu, 10 Jul 2008 07:45:01 -0700
I need to encrypt and decrypt certain columns in certain tables inside a
stored proc. Can this be done and if so how? Thanks for any advice. This is
SQL Server 2005. ...
|
|
|
SSIS or SQL Agent?
Wed, 9 Jul 2008 13:36:00 -0700
We need to set up a monthly 'job' that reads and writes from our SQL Server
2005 database and creates FTP files. The logic is quite complex, its goes way
beyond a simple transfer of data. Would it be better to use SSIS or SQL
Server Agent to do this? What are the pros and cons? Thanks. ...
|
Temp table and rollback in SSIS Package
Wed, 9 Jul 2008 02:56:03 -0700
Hi,
I have an SSIS package that use a #temp table to store the list of ID to
compute in different DataFlows and SQL Tasks.
This package has 2 connection managers (OLE DB), Source and Destination.
In order to create the #temp table, RetainSameConnection is set to true on
the Source connection and tasks that ...
|
Lost data importing from Excel
Tue, 8 Jul 2008 04:22:53 -0700 (PDT)
I'm trying to import a small spreadsheet from Excel into a pre-created
SQL Server table. One column is defined as char(2), and the data
values are actually 2 digits. When the leading digit is non-zero, the
data transfers OK, but if the code is, say, '06', I get a null in SQL
Server. I'm running SQL Server 2000, ...
|
