|
|
|
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 DTS package log data? Posted by dj at 9/21/2006 10:19:02 AM Do anyone know where to find the package log details that can be displayed by
right-clicking a package and choosing "Packages Logs..."?
It would be very useful to be able to query this table or tables.
TIA!
dj
...more >>
Run Task at the End of the Package? Posted by psandler70 NO[at]SPAM hotmail.com at 9/21/2006 9:25:41 AM All,
This is for SQL 2000 DTS.
It is possible to run a task (ActiveX in this case) at the completion
of a package, regardless of sucess/failure of any of the steps?
I have a package that has a number of steps, each of which run only
when the preceding step was sucessful. I would like to ...more >>
Moving DTS package to another server loses Destination info Posted by Bruce Hendry at 9/21/2006 7:54:15 AM Hi all,
I have a sql2000 DTS package I'm moving between windows2003 serves on the
same network. The moved package appears to lose all column definitions
defined for an output text file (source is a sql query). Clicking on the
"Define Columns" button in the Destination tab of the Transform D...more >>
SQL Server Import Question Posted by ThreeHun at 9/20/2006 3:03:41 PM Hi,
I have 100 tab-delimited text files I have to import every day into
their respective tables on SQL Server 2000. The data in each of the
files is not homogenious, i.e. some files have 3 columns, some have 50
and weigh 200 Mb, etc. I download all files from an ftp site.
The big picture ...more >>
DTS Import DB2 to SQL 2000 Posted by jeffnelson3 NO[at]SPAM mchsi.com at 9/20/2006 2:49:42 PM Hi, I'm trying to import data from DB2 to SQL 2000. The import works
great, however, when I try to edit the 'Transform Data Task' on the
workflow display, my Enterprise Manager just hangs. This only happens
when trying to modify a task that imports from DB2. Does anyone have
any ideas?
...more >>
SSIS Derived Column rounding Errors Posted by SQLIdiot at 9/20/2006 7:12:09 AM I am using a derived column to calculate values for exploded sales
estimates. The formula is pretty simple (Estimate *
(sales/Summedsales)). Each of these numbers are decimal(12, 4). The
problem is that the derived column values are not the same if I just
did the math. An example (149947.439...more >>
Not loading reaming records if any one record fails in the bulk lo Posted by Veeru at 9/20/2006 2:56:02 AM Hi
I am trying to load the 30 records into the database table. I have created
one Format File and one .sql file to load the data. I observed one problem
during loading the data into table, if there is any problem in the first
record of my 30 records, the sqlcmd is rejecting the entire dat...more >>
How can I extract all relevant meta data from a ConnectionManager of type "FLATFILE" Posted by Amnon at 9/19/2006 5:11:33 PM Hello,
I am writing a custom Data Source that accepts an instance of a flat file
connection manager.
Once I have a reference to this connection manager (ConnectionManager object
with CreationName="FLATFILE"),
does anybody know how can extract all its relevant meta data - especially
the ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Connecting to the database via an OLEDB connection manager within a script task Posted by John Hardin at 9/19/2006 4:01:59 PM Folks:
We have the need to write a lot of SSIS script tasks that talk directly to
the database. We use OLEDB connections, and log into the database using
database users rather than Windows integrated security.
Within a script task I'm able to create a new OLEDB connection object using
th...more >>
I need a simple solution to a DTS problem Posted by timedrifter NO[at]SPAM gmail.com at 9/19/2006 11:55:23 AM I need to set up 2 exports in DTS, they both go to an Excel File. In
both cases I need the file name to be dynamic, i.e.
company_<todaysdate>.xls
1. The first one will be run weekly and dropped into a
folder on the shared server. What I need to do is make the file name
dynamic and ...more >>
Migrating DTS packages from SQL2000 to SQL2005 Posted by Chris Wood at 9/19/2006 8:04:56 AM Hi,
My initial tests show that this feature will only see DTS Local Packages.
How can we migrate the DTS Meta Data Services Packages?
Thanks
Chris
...more >>
SSIS and DBF files Posted by JC HARRIS at 9/18/2006 4:10:21 PM I need to import into SQL dbf files. In SQL2KDTS there was an option for
this, but in SSIS I do not see an option for dbf files. I tried a few that I
thought MIGHT be the instance but nothing has worked so far. What file type
do I use for this now?
TIA
...more >>
The ole db provider 'SQLOLEDB' was unable to begin a distributed t Posted by Raj at 9/18/2006 9:59:02 AM Hi
When I am trying to insert value in remote server (Linked Server) or trying
to run query with BEGIN TRAN & COMMIT from query analyzer I am getting
following error.
*********************************
The operation could not be performed because the ole db provider 'SQLOLEDB'
was unabl...more >>
Trimming Transformation not working Posted by Patrick at 9/18/2006 9:40:02 AM Using SQL Server 2000 latest SP and DTS Designer.
I am using a String trim transformation with
-Text file (~ delimited) as data source
-SQL Server table as a destination
Although ticked "Leading" and "Trailing" spaces to be trimmed.
~ ~ (tilda space tilda) is not trimmed, resulting in a s...more >>
Managing Connection Problems within DTS Posted by sonny NO[at]SPAM nellhead.pointyhats.com at 9/18/2006 8:22:55 AM Hello. This question was asked by "LucasC" about a year ago and no one
answered. I'm having the same issue now. To paraphrase LucasC:
"We are using a DTS that basically transforms data from a Table in one
repository to a Table in another repository using a DataPump Task.
We also has a succes...more >>
Import data from Excel Posted by Ava at 9/18/2006 7:55:02 AM Hi, I am import data from Excel to SQL Server using DTS. But the column name
is in the second row (some cells in the first row merged). How can I define
the column name from second row?
There is password in this file. How can I put password in DTS package?
Thanks for your help
Ava...more >>
Transfer Database Task fails Posted by amzd at 9/18/2006 7:24:01 AM Hallo,
Ich wollte eine (kleine) DB zum Test von einem SQL Server 2000 auf einen
anderen kopieren. Beide sind in der gleichen Domäne. Das Windows NT-domänen
Konto hat auf beiden sysadmin-Rechte.
Auf Register 4 [File locations] habe ich
oben einen grünen Haken bei "files are ready to be move...more >>
Executing a DTS Package from VB.NET forms Posted by damian_meleo NO[at]SPAM hotmail.com at 9/17/2006 11:44:52 PM Hi,
I am getting an error "[DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied." when I try and execute a DTS
package from VB.NET (forms) using the method LoadFromSQLServer.
I am trying to execute a package from a remote SQL Server. The package
has one connect...more >>
Trasnformation SQL 2k Posted by Enrico at 9/16/2006 6:46:01 PM Hi, I need to know how can i transform a value to a letter:
It goes from a DB to another...
Ex: if 0 to 30 = A, if 31 to 60 =B
anyone can help me please?
Thanks a lot...more >>
SSIS - Error trying to converting the string "(null)" to a null va Posted by John A at 9/16/2006 10:16:02 AM Hi all I am trying to convert the string "(null)" in the [PASSWORD] column of
my table to an actual NULL value by using the Derived Column Transformation
tool. I have tried to use two different forms of a conditional operator to
achieve this end. However I am getting the below errors both ca...more >>
SQL 2005 and DTS Posted by Greg at 9/15/2006 10:50:02 AM I have just converted an Access application to SQL Server 2005 with no
problems. Now that everything is working fine I am looking to create a DTS
Package to convert data from existing Access Databases to my SQL 2005
Database. I see now that DTS is a LEGACY thing and only allows you to
import...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |