|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Scheduling database copy Posted by hb at 3/31/2006 12:05:03 PM Server: SQL2K
I want to have a backup server ready to deploy in case my production server
gets damaged. One of tables has identity column, and the other has no
primary key. So, I gave up Replication method. (Does Replication still
work?)
I chose DTS to copy database. When the backup...more >>
migrate DTS from sql2000 to sql 2005 Posted by mecn at 3/31/2006 10:50:02 AM Hi,
I am trying to migrate DTS package from sql2000sp4 to sql2005/legacy.
I got this error, an error has occurred while establishing a connection to
the server. whne connecting to sql server 2005, this failure may be caused
by the fact that under the default settings sql server does not allo...more >>
SSIS - Export to Excel Posted by Pat at 3/31/2006 10:16:03 AM I am exporting two different views to the same spreadsheet but different
sheets. The first export works fine but the second creates the second
worksheet with the same headings as the first. Both exports are created
using the wizard so they are in different packages.
Anybody tried this suc...more >>
Invoking a DTS Package Posted by Jim Heavey at 3/31/2006 5:22:01 AM I read in a book that the DTS packages could be invoked by a program (in my
case a C# program) as long as you provided the login ID and password. Now I
am looking for an example. Is it possible and where could I find an example.
Thanks in advance for your assistance!!!...more >>
Copying Packages Posted by Jim Heavey at 3/31/2006 5:17:03 AM I want to copy the contents of one package into another package. I can bring
up the 2 packages side by side in DTS Designer and I can copy things like
the Connection and the Text file, but I can't copy the transform between the
2 opjects....Is there a way to copy the contents of one package i...more >>
Shortcut to start DTS Posted by Waldy at 3/31/2006 12:00:00 AM Hi there,
is there any way that a DTS package can be executed via a
shortcut? I need to make this as simple as possible for a customer who is
not familiar with Enterprise Manager.
...more >>
DTS to Excel New Spreadsheet Posted by javathehutt at 3/30/2006 3:37:35 PM Hi
I am trying to schedule DTS jobs that would pull from SQL and extract
the data to specific Excel files. These jobs are being run daily at
8am.
Eg. Pull data from SQL Table A and copy to Excel File A.
Also, I am discovering some wierd behavior; the new data being pulled
from SQL, adds to the...more >>
Handle task error Posted by talldrink NO[at]SPAM gmail.com at 3/30/2006 3:26:54 PM Hello all,
quickly: I want to be able to be able to have a specific task fail, run
a stored procedure to log the error, and then continue processing the
package as if nothing had gone wrong. When it gets to the end, I'd like
the package to act as if it had suceeded.
More detail: I'm working...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
After install SQLServer2005_DTS.msi Posted by mecn at 3/30/2006 11:37:45 AM Hi,
I have both sql2000 and sql2005 server in my computer.
In order to open legacy/DTS package in design mode sql2005 I installed
SQLServer2005_DTS.msi.
I was able to open DTS in sql2005. Now my problem is I can user sql2000
anymore.
It gives error says that The procedure entry point?
pr...more >>
SQL 2K: Help needed with dynamic output file names Posted by Matthew Speed at 3/30/2006 10:51:23 AM I have been asked to produce a set of csv output files for a number of
subsets of data from a database. I have created a DTS package that
can output each query to a hardcoded filename specified in the
Destination file object in the package. As I have to do this
appoximately 160 times I need to...more >>
SSIS in sql2005 Posted by mecn at 3/30/2006 10:08:17 AM I can't find SSIS in sql2005? the SSIS service is running.
Thanks
...more >>
TDS package from sql2000 to sql 2005 Posted by mecn at 3/30/2006 9:50:15 AM Hi,
After I upgraded the sql2000 to sql2005. I see the dts package under legacy.
but i can open it.
WHY?
Thanks
...more >>
Sql2k dts. Just a question Posted by Enric at 3/30/2006 12:56:01 AM dear gurus,
I don't understand a feature. It is in Package Properties->Logging and it's
called as 'Fail package on first error'
What the heck! Any of our dts end up when any task fails. is it referring to
warnings or something like that?
Please, let me know how works that option button and ...more >>
Calling the same stored proc multiple times to execute diff DTS Pk Posted by DeniseMe at 3/29/2006 1:31:01 PM Hello!
I have a stored procedure (FL_LIGenerateNextPkg) which I call to set the
global variables of a DTS Pkg and execute it (Pkg A). Pkg A then runs a
couple of stored procedures and after they have successfully completed, it
calls FL_LIGenerateNextPkg again, passing different parameters ...more >>
Help: Using DDQ to update another DB's table Posted by memiller NO[at]SPAM westernsurety.com at 3/29/2006 1:21:59 PM I'm using MS SQL 2K. I'm trying to design a DTS that uses DDQ that
uses a query as its source from DB1, then using that data it needs to
update a table in a second DB (DB2). Both DBs are defined in the DTS
as a Connection. I have the source query completed and tested, I've
defined my binding ...more >>
DTS OWNER Posted by Tom Reis at 3/29/2006 1:05:13 PM Is there a way to change the owner of a DTS Package. I am running SQL 2000
Enterprise with SP4. Thanks.
...more >>
DTS - Multiple Column Lookup Posted by Asim Siddiqui at 3/29/2006 10:51:02 AM Hi,
I would really appreciate if anyone of you can help me. I am new to the DTS
and working on multiple column lookup under ActiveX script. I am using SQL
Server 2000.
Lookup Query:
SELECT STATUS_DATE,STATUS_CODE,DELIVERY_DATE
FROM PRODUCT_ORDER
WHERE (PRODUCT_ORDER_ID = ?)
The Trans...more >>
Keeping object selection when changing login Posted by ksteilbe at 3/29/2006 10:23:02 AM When I modify the server connection to change the login ID when I transfer a
DTS package to a different server, the tables I selected for copy on the
original package get de-selected. How can I preserve the object selection
when changing a connection login? This is in SQL Server 2000. Thank...more >>
Copy SQL Server Objects task won't copy table Posted by Francis at 3/29/2006 6:53:01 AM I am using the Copy SQL Server Objects task in DTS on SQL Server 2000 sp4 to
copy a number of specific tables from one database to another on the same
server. The package fails with the error message "Could not find check
constraint for table 'x', although the table is flagged as having one."...more >>
Import Multiple Text Files Posted by molsonexpert at 3/29/2006 5:57:04 AM I'm new to DTS so bear with me.
I have an app that exports several tab-delimited files throughout the day.
I'd like to then schedule a time when these can be imported into an SQL
database. I've got it to work fine on a test server using DTS for one file.
The exported files generated have diff...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |