|
|
|
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 Using LoadFromSQLServer fails with OLAP tasks in a package Posted by Jim Trowbridge at 12/28/2005 6:35:02 PM I can use LoadFromSQLServer successfully unless the target package contains
OLAP tasks, then it appears to hang this procedure.
Anyone got a workaround ?
TIA...more >>
producing a date time report in SQL/DTS Posted by Blasting Cap at 12/28/2005 6:26:18 PM I have need to produce a report (excel sheet actually) from SQL that
would run each Tuesday and each Friday of every week.
What needs to be on the Tuesday report is everything that came in from
the Friday midnight time, until the Monday midnight time. The friday
report(sheet) would have ev...more >>
Importing Excel files to SQL Posted by pomarina at 12/28/2005 12:32:36 PM Hi everybody,
I have 1 to n Excel spreadsheets I need to load to SQL tables. Excel
files names are table names in database and Excel column names are
table columns. I need to check if table exists in db, rename existing
one to name_bak, create a new table and insert data into it from Excel.
...more >>
DTS text file import Posted by Manish at 12/28/2005 8:39:03 AM When i try to import a file with 471000 rows of data using Microsoft text
driver to a SQL Server (version 7), DTS only imports about 416000 rows and
give me a success message.
I tried deleting a few rows of data and inserting a few rows of data, and
also checked the full data set to make su...more >>
Export from table to multiline text file Posted by kapsolas at 12/28/2005 8:39:03 AM I am not sure if this is possible or not but I am trying to do the following.
I need to export data to a test file in the following format:
[Users]
firstname=john
lastname=smith
when Creating my table which stores this information, I am using T-SQL to
concatenate my values into one row, ...more >>
Use global variable to update a table Posted by txksa at 12/27/2005 1:41:40 PM In part of a DTS package a user will input a value. I need to take that
value and update a table. Something along the lines of
"UPDATE dbo.OLSParms" & _
" SET dbo.OLSParms.Val = '" & DTSGlobalVariables("Category").Value & "'"
From within the activex script task, how would I write this?...more >>
Flat File import Posted by Bigal at 12/27/2005 1:37:53 PM Hello,
I need to import data from a flat file into a sql server 2000 database. The
Fate file has no delimiters. I have the specs for this file so I do knowthe
layout of this file. Can somebody point me in the rigvht direction to
accomplish this.
Thanks...more >>
How To Create DTS package on Setup Program ? Posted by Haki at 12/27/2005 5:29:03 AM I' m using setup program for making my project's install.exe. How can I
create my DTS packages from command or query if is possible....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS/DTS or simple insert? Posted by nick at 12/25/2005 11:45:02 PM I need to dump Access MDB files to SQL Server 2005. No extract and transfer,
just transfer the raw data. However, the mdb files can be reaching the
limitation of 2G.
Is there any benifit (especially performance) to use SSIS to load the MDB
files? Or a simple SQL statement (with openquery to...more >>
DTS Step should run Last Posted by (jariwala_b NO[at]SPAM rediffmail.com) at 12/25/2005 9:23:32 PM I have created one DTS package with 5 tables transfer from source to destination db.I am transfering incremental data from source comparing timestamp column value from each of these tables.for this to i am storing datetime value in global varaible called Last_Export_Date.
I am updating Last_Expor...more >>
Moving Full database to Empty database Posted by Roy Goldhammer at 12/24/2005 2:05:16 PM Hello there
I have database with many relationsips
At the start it is empty and when i'm trying to import to it data. some of
the tables are failed due to key violations
Is there a way to import the data in this cases?
...more >>
Log File is growing Posted by Roy Goldhammer at 12/23/2005 2:26:58 PM Hello there
I've run dts between two servers that connected by the internet, and one of
the tables failed.
I've transfered 78Mb, and the log file has increased in 100Mb.
Whayd did the log file has increased that mutch?
and how can i prevent it?
...more >>
DTS 6 TXT each with 9000 rows, 900 columns in SQL Server 2000 Posted by AppDev at 12/23/2005 1:05:01 PM Windows 2000 Server SP4, Dual 2.4 GHz P4 Xeon machine, 3776 MB RAM
SQL Server 2000, all patches and service packs applied
I am trying to import 6 text files (comma separated data) with roughly 9000
rows and 900 columns (file extension is .txt not .csv). Each file is about 10
MB in size.
I...more >>
Transform Data Task limit? Posted by Mike Austin at 12/23/2005 11:37:03 AM I have a DTS package with 12 Transform Data Tasks in it (along with 2 data
sources and 3 sql tasks).
When I run the entire package one or more of the Transform Data Tasks do not
execute. I can run them manually, but that is not the point.
No error messages are generated.
Is there a limi...more >>
Status Column vs. ExecutionStatus/ExecutionResult Posted by John Saunders at 12/22/2005 8:42:04 PM I'm using DTS in SQL Server 2000. This is the first time I've used it
extensively.
I have a task which is trying to "manually" roll back a set of steps if any
errors have occurred in a previous step. In the Execution Progress dialog,
the previous step shows up with "Errors occurred (nnn)". Yet...more >>
DTS in SQL 2000 Workgroup Posted by mtncruzr at 12/22/2005 5:34:02 PM If DTS is not supported in the new Workgroup version of SQL 2000, how does
one get data and SPROCs in and out of a server? Is there some
replication-like process to transfer from one SQL site to another without all
of the transfomation capabilities of DTS?...more >>
Help! I need a simple way to import an Excel file... Posted by Jim at 12/22/2005 3:39:13 PM Hi,
I recently upgraded my dev machine to SQL 2005. It's the only machine on
our network that's running SQL 2005; everything else is on SQL 2000. It's
been a bit of a struggle getting used to the new management console, but
mostly liveable. However, now I'm getting totally frustrated by ...more >>
Table changes not showing up in the DTS transformation task Posted by Larry Bird at 12/22/2005 9:02:02 AM I have a DTS package that performs data transformation from a flat file to a
database table. I've added two columns to the table but, the two table do
not show up when I look at the transformation tasks in mu DTS package.
Shouldn't the new columns show in the transformation step automatica...more >>
Encoding problem Posted by SoccerManic at 12/22/2005 2:03:46 AM Hi,
Is it possible to output the content of a table into .txt file using UTF-8
encoding and how?
Thanks in advance.
...more >>
Error with DTS package Posted by Fr NO[at]SPAM nk at 12/22/2005 12:37:03 AM Dear all,
Since I'm reasonably new in this field, I hope you can help me with a
strange problem. At least: for me it's strange!
I have made a few data copy-and-filter steps, copying data from one table to
another, using DTS-packages based on queries. These DTS-packages are combined
in a ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |