|
|
|
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 String Trim not working in DTS package Posted by Joel at 4/30/2004 3:51:06 PM I used the DTS wizard to create a DTS package that would use string trim to remove leading spaces in strings in a column. First I configured it to make the transformation to the same column on the same table in the same database. The DTS package appeared to hang and didn't finish after waiting for...more >>
Local DTS Packages Backup? Posted by Don Miller at 4/30/2004 1:34:41 PM How do you reliably backup local DTS packages on a server?
I know you can save each package separately as a package or VB file
somewhere that does get backed-up but that certainly requires someone to
ALWAYS save a backup whenever any package is tinkered with. Is there an
easier way?
Thanks....more >>
Recreate table - including new columns Posted by Michael Schamberger at 4/30/2004 12:06:09 PM
My source table is on an AS400. I can access it with ODBC and create my table
in SQL. I wanted to schedule a job that would:
A. Drop destination table
B. Recreate destination table (inluding any new fields/columns in source)
C. Pump in the data
The problem is that my DTS job ignores any...more >>
Call to a dts Posted by Javi at 4/30/2004 9:39:22 AM Hello everybody,
I want to execute a dts from an ASP page. The problem is that this ASP is
not in the same server where the SQL Server is. Is possible to do what I
want?
All examples i found are calling to a local SQL Server.
If it is not possible, can I leave the resultant excer file in ...more >>
searching within a DTS package Posted by Dan at 4/30/2004 8:24:51 AM I'm using SQL Server 2000. I created a function in a dts that I want to use
again but I don't remember which package it is in but I do remember the
function name. Is there a way to search all dts packages for the name?
Thanks,
Dan
...more >>
Automating data insert from email attachment? Posted by Jason at 4/30/2004 7:10:04 AM I work with a client who provides me daily updates of
data on their FTP site. I created a DTS package to load
this data on a nightly basis.
Now they will be sending a weekly email with some other
data that I will be responsible for inserting into our
SQL 2000 DB. For whatever reason the...more >>
strange occurence with DTS Posted by mbarrick NO[at]SPAM yahoo.com at 4/30/2004 7:07:39 AM Hello. I have created a fairly straightforward DTS that queries a SQL
Server database and exports the results to a text file. If I execute
the DTS package from the server it runs successfully.
When I run the DTS package from an ASP page using the following code
(I have not included full code...more >>
problem with export to text file Posted by Yana at 4/30/2004 6:51:02 AM Hi
I found that long strings are cut when import to the text file. Does it mean that something is wrong with my database definition or this is a real bug
I just defined test table with one varchar(6000) column. I put in string with 600 characters. After export to the text file, string was cut to t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DTS services import process terminating Posted by Patrick Kamau at 4/30/2004 3:56:04 AM I recently attempted to install EPO server (McAfee antivirus product) on one of my servers and selected the option for it to create a database to maintain it's logs on our SQL 2000 server that is in another server. The EPO server installation reported an error trying to link to the SQL 2000 server a...more >>
Darren Green - help Posted by Michael Vardinghus at 4/29/2004 10:08:36 PM Sorry bout the personal post....
But I tried to get this to work...but it failed when trying to open it ..
translated from danish ("not valid class string")
http://www.sqldts.com/default.aspx?299
Could it be a language problem ?
\Michael Vardinghus
...more >>
Find ServerName inside DTS Posted by josefszeliga NO[at]SPAM hotmail.com at 4/29/2004 6:21:49 PM My DTS package requires that parameters be set depending on which of
our sql 2000 servers the package runs on. ie the servername determins
the name of the database in development, testing and production.
I created a dynamic property task and used the Environment Variable
"SERVERNAME" to retrie...more >>
OLEDBProperty Error - Running DTS Posted by Jose Inacio Menezes at 4/29/2004 4:21:15 PM When running a DTS package, I often get the following error:
OLEDBProperty '....' already exists in the collection.
The name of the property is allways different, like 'Data Source Name1',
'User ID', etc.
Thanks for any advice.
...more >>
Exporting data into a text file Posted by archiben.muller2 NO[at]SPAM asbbank.co.nz at 4/29/2004 3:25:20 PM Ok I have a problem with column names in my destination text file.
There seems to be a restriction on total length of column name
characters and I'm not talking about maximum characters per column
either.
e.g. Say I ha three columns - "col1,col2,col3" = 14 characters long
If Column Names pr...more >>
Conditional SQL Posted by Bruce Loving at 4/29/2004 12:03:41 PM Trying to create an Execute SQL task that
only runs if a global variable is set
tried the following in Workflow ActiveX script
but if it does not execute then package fails the
next step too.
Function Main()
if DTSGlobalVariables("Action").Value = 1 then
MsgBox( "Good" )
Main = DDTSStepS...more >>
12 million row DTS package Help Reqd Posted by anonymous NO[at]SPAM discussions.microsoft.com at 4/29/2004 11:29:11 AM I've just set a DTS package to copy one database from a
sql7 server to a sql 2000 server. After 5 hours its
finally copied 90% of the tables including one with 12m
lines, but it's now just started to create huge tables
out of the views. I need to cancel the views on 2
fronts - not much d...more >>
Execute SQL Task Posted by EG at 4/29/2004 9:46:10 AM I am using a SQL Task in my DTS package. If the SQL being executed fails, I would like to proceed to a specific task. If it suceeds, I would like to proceed to another. However, if the SQL raises an error, the step fails and none of the other steps run. Fail package on first error is not selecte...more >>
export all tables into a text file Posted by NoName at 4/29/2004 5:11:05 AM I want to export all my tables in one time into a text file, but I can't find it
In DTS there is a possibility to export one table after one table. How can I export all tables together
Thanks a lot for your help...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |