|
|
|
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 Common Package Error Handler Posted by Fergus at 6/28/2006 3:13:02 PM Can I define a step to be always executed as the last step of a package? I
want to log the error status of each other step in a database table. I know
that the package itself looks at the final status of all the steps at the end
and issues a message for each failure, but I want to write the sa...more >>
Transfer record sequence Posted by sheridan.zhu NO[at]SPAM gmail.com at 6/28/2006 2:12:05 PM I'm using DTS to process a text file in SQL Server and then exporting
it back out as a text file.
I first create a table in SQL Server, then import the text file into
that table. I need the file in its orginal sequence as it goes in and
out of the SEQ Server. However, sometimes, the file is ...more >>
DTS Security in SQL 2005 Posted by Todd C at 6/28/2006 12:40:03 PM I have a job that kicks off a stored procedure. The proc in turn kicks off 25
DTS packages with scripts like
execute master.dbo.xp_cmdshell 'dtsrun /Smtcntsql02 /NNavision_TT_Vendor /E'
for a while, we were using the /U and /P switches with the sa account and
password. The packages still ...more >>
Same package, different servers Posted by Fergus at 6/28/2006 10:32:01 AM Is there a way to load a package from a structured file, in a different
server than the one it was saved from, and then save it back to the same
structured file as a new version under the same package ID?
When I save a package to a DTS file, it has a package ID and each save from
the same ...more >>
Saving packing to reduce file size Posted by rmcompute at 6/28/2006 10:29:02 AM I created a package with is used several times in another package. Because
of the number of times I changed the subordinate package, the file size grew
quite large. To reduce it, I called up the subordinate package and did a
save as newfilename (with the same package name). I then deleted t...more >>
lookup transformation errors to a flat file Posted by leo NO[at]SPAM junquera.com at 6/28/2006 10:14:14 AM I know DTS but am new to SSIS. I am having trouble exporting records
that don't match from a lookup transformation. I get the following
error:
Row yielded no match during lookup.
I would really like to have a list of all records that did not match so
that I could export and examine it.
...more >>
How to Get UpdateRowCount value from global variable Posted by Rajesha at 6/28/2006 7:16:02 AM “GiUpdateRowCount†Global Variable Created DTS package
Update TableName
From TableName2
Where TableName.Col1 = TableName2.Col1
SELECT @@Rowcount AS UpdateRowCount
Above Query is used in Execute SQL Task
Once I execute the Execute SQL Task, UpdateRowCount value should pass to
Gl...more >>
whats the best way to identify, whether dts is currently running or not? Posted by dishan NO[at]SPAM gmail.com at 6/27/2006 11:45:00 PM whats the best way to identify whether dts is currently running or
not?(ms-sql 2000)
Cheers
DF
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Package failure: The package execution failed. The step failed Posted by darren.harris NO[at]SPAM thomson.com at 6/27/2006 1:26:26 PM
When I execute the package manually (right click on the file, Open
With | Execute Package Utility), the package executes normally until it
reaches a line
'Information: Execute phase beginning'. At which point it seems like
processing stops (no other messages).
I'm receiving this err...more >>
import password protected file into SQL Posted by Schuml at 6/27/2006 1:06:02 PM I would like to create a DTS package that will import a password protected
excel file into SQL. But I get get an unable to decrypt the file error when
I try to link it to either a file dsn, or system connection. Does anybody
have any ideas on how this can be accomplished.
It should be simp...more >>
calling SSIS package from stored procedure Posted by hedgracer at 6/27/2006 12:08:20 PM I am going to have a stored procedure that will call and execute an
SSIS package. I was going to use the DTexec utilility but have not
found out how to call that utility from a stored procedure. Is the the
right approach or is there a better way? Is there an alternate way to
call an SSIS package...more >>
Lookups Posted by A.B. at 6/27/2006 10:12:01 AM I have a large table and i am trying to find a way to import only the new
records into SQL Server 2000. Once the records are in the table they are not
updated so i can use the date and time fields to find what is the most recent
record that is not a problem. The problem is how do i use the DTS...more >>
looking for the dts template in 2005 Posted by WebBuilder451 at 6/27/2006 7:12:02 AM ok simple question and maybe i don't even need the template. How do you
create a new dts package in 2005
Note: I have VS2005 pro as well as sql 2005 when i goto Sql server business
intelegence studio VS pro starts but no DTS (Data Transformation Project)
template
--
thanks (as always)...more >>
How to dynamically specify which SQL objects to transfer in DTS package Posted by aksenenko NO[at]SPAM gmail.com at 6/27/2006 6:04:20 AM I am rather new to DTS, I apologize if this has already been covered
elswhere in the group - I couldn't find it.
I am trying to create a package to transfer an arbitrary number of
tables from one database to another on the same server. The criteria
is to transfer all user tables with names begi...more >>
Creating new files each dts execution in SSIS Posted by Alex at 6/27/2006 4:58:01 AM Hi all,
Maybe my doubt is very simple, but i did't find references how to solve this
problem that in SQL 2000 I've used dynamic properties.
The objective is to create a text file destination based in a query. But
each time that the package runs I want to create a file based on the actual
dat...more >>
Using DATAPUMP is it possible to read from 2 different databases on same server in the source tab? Posted by cl NO[at]SPAM yahoo.com at 6/26/2006 5:14:01 PM
we are using SQL Server SP 4 on W2003 box.
we have a source database otr and a destination newbus
we currently read from the source and insert into destination.
now we want to limit what we query from the source by joining it in a table in
destination.
is this possible. how can i se...more >>
DTS Package - Destination Server is now off of domain. Posted by jbiros NO[at]SPAM sppinc.net at 6/26/2006 2:16:51 PM We have a DTS package that refreshes our external website data on a
nightly basis. I recently moved our external website off of our
domain. The SQL Services were previously running as
DOMAIN\Administrator account. When I moved the server off of the
domain, I reinstalled SQL Server and set the...more >>
Parameter Posted by AAA at 6/26/2006 2:03:02 PM I am new to DTS development. Can you please tell me the easiest way to
create a package that will create tables each month that will be the same
except for the month name.
What I am trying to do is copy data from existing tables into archival
tables each month. i.e. In May - copy data from...more >>
Clarification:URGENT DB RESTORE INFO STILL REQUIRED Posted by Frank Srebot at 6/26/2006 11:19:01 AM Hi
I had a previous question and I have to clarify. I am using an Access 2002
Project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server
Espress).
I was wondering if anyone new if it was possible to restore a Database that
was Backed up by SQL Server 2000 developer edition, ...more >>
Workflow not working for Failure Posted by rmcompute at 6/23/2006 2:26:01 PM I set up a workflow in DTS to execute an SQL task when a previous SQL task
fails which worked successfully. I then set up an SQL task to run when a
previous package fails. The package loads data from Access to SQL Server. I
removed the table it loads from Access to get it to fail, however ...more >>
Track a flow of DTS Posted by Rainier at 6/23/2006 10:23:17 AM Good afternoon to all!
I am starting to work with DW and SQL 2000 together with Analysis
Server and am needing to know if it is possible and as to make to track
a flow of dts to be able to identify, when to give problem, in which
stage occurred the problem.
Thanks!
...more >>
URGENT DB RESTORE INFO STILL REQUIRED Posted by Frank Srebot at 6/23/2006 6:54:02 AM Hi
I was wondering if anyone new if it was possible to restore a Database that
was Backed up by SQL Server 2000 developer edition, into an Access 2002
Project. I have been told that it was possible and one of the responses I got
was:
'What you need to do is specify a new file location f...more >>
DTS package execution Posted by Dimitris Nikolakakis at 6/23/2006 12:00:00 AM I have two DBs and I have created a DTS package to import data from one to
another DB and I have saved it in SQL (Data
Transformation Services --> Local Packages).
Is there any way to execute it from Query Analyzer?
Thanks
Dimitris
...more >>
SSIS Problem with Foreach Loop and XML Task Posted by Hasan Quadri at 6/22/2006 9:11:01 PM I'm having a problem using the Foreach Loop container that contains an XML
Task followed by a data flow task.
When I run my package in the debugger, the XML Task fails with the following
errors:
[XML Task] Error: An error occurred with the following error message: "Data
at the root level i...more >>
Type Mismatch when Excuting Dynamicproperties Posted by shumaker NO[at]SPAM cs.fsu.edu at 6/22/2006 7:12:29 PM I am loading a DTS from a local file, setting the DTS parameters, and
the executing the DTS.
When I call Execute on the package it gives me "Type mismatch" for
DTSStep_DTSDynamicPropertiesTask_1
If I run the package manually from Enterprise Manager, then it
completes succesffully.
If I r...more >>
Access memo field to Varchar Posted by Jerry J at 6/22/2006 6:16:02 PM I'm trying to import data from an Access database to a SQL Server database. I
am using SQL Server 2005 Integration Services. The tables already exist in
the SQL server database. I am having trouble with converting the memo fields
(unicode text) to the varchar fields in SQL Server. How can I ...more >>
Creating a flat file destination on a CD-ROM Posted by John A at 6/22/2006 6:09:01 PM Is it possible to send or copy to a writtable CD-ROM drive? I have a
customer in a remote location that is running a completely disconnected (from
the internet) environment. They gather data and then need to get it back to
the real world. The easiest way for them to do it is to copy the dat...more >>
DTSPackage Posted by Derek Hart at 6/22/2006 3:14:19 PM I am running a DTSPackage in dotnet using the COM Microsoft DTSPackage
object. I believe I can log results to the NT log, but is there any way to
give immediate status to the user of errors? What would be great is to show
the number of rows that are being copied using the COM object. Is this...more >>
DTS scheduled job failed after 1st run (SQL 20000 SP4) Posted by Frankie at 6/22/2006 12:48:01 PM I created a DTS package scheduled job through DTS Import/Export Wizard in SQL
Server 2000 SP4. scheduled to run every 10 min (copy tables from DB1 to DB2
on the same SQL server). It ran Ok 1st time, but failed on the 2nd and the
rest of them. I log on as sa to create the job. (see below)
T...more >>
Weird Issue with DTS & EM Posted by TMan at 6/22/2006 10:25:02 AM SQL Server 2000 3a
DB2 Client tools version 7.2
I have a DTS package created by someone else. It has a transformation where
a Mainframe db2 database is the source. I have an odbc connection set up.
The destination is a sql server 2000 table. When I attempt to open the
transformation ba...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |