| Groups | Blog | Home |
|
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 ActiveX Script Syntax Posted by martino at 8/31/2004 7:29:08 PM Hello!
I have this ActiveX script, I need to pass these two files
names check and if they exist before I move onto a next
dts task, but I am having trouble checking both within the
Main function, is there a way to pass two file names as
parameters to a function and have a the the functio...more >>
Job fails, but can't find what's wrong Posted by Amy at 8/31/2004 12:17:28 PM I have a job transforming a foxpro database into a sql
server database. When I run it on our production SQL
Server, it fails; when we run it on a user's local SQL
Server, it runs with no errors. The job FTP's a file,
unzips it, then executes a transformation task. We've
had problems wit...more >>
DTS and ASP Posted by GregIpaper at 8/31/2004 8:54:59 AM I have seen many examples of ASP and DTS package, however
once I try it from the web it is crashing , I am trying
just a simple package that moves an excel doc to a Sql
server table. Works thu enterprise but not thru web. Does
Excel need to be installed on Web server, am I missing a
ODBC or...more >>
Data Driven Query Posted by Peter Newman at 8/31/2004 2:23:01 AM I know i can use a DDQ to Inset and Update records in a table from a text
file, but can i do both at the same time.
Col 1 = Licence
Col 2 = AccountId
Col 3 = Company Name
How can i Update the Company name if the Licence and AccountId are found and
Insert Licence, AccountId and Company ...more >>
Backing up SQL Server problem Posted by Mark at 8/31/2004 1:32:16 AM Hi - I am having a problem backing up my database on my host, onto my
local instal of SQL Server 2000.
I am using Enterprise Manager/DTS:
I use "Copy objects and data between SQL Server databases"
And on the next page I activate:
Create destination objects + all 3 sub options
+ copy dat...more >>
question -- copy database? Posted by fred rosenberg at 8/30/2004 9:36:49 PM hi,
first, i apologize if this is not quite the correct newsgroup for this
question (feel free to point me to another one.)
I notice that databases seem to be stored in: C:\Program Files\Microsoft
SQL Server\MSSQL\Data -- in two files, an MDF and an LDF. basic question.
can i just copy th...more >>
DTS csv import fails when using double quotes as the Text Qualifier, the last column is a char field and all of the records contain null (empty) value Posted by dherbstemail-ng NO[at]SPAM yahoo.com at 8/30/2004 5:14:48 PM I am using DTS to import csv files that I receive from a third party.
Each day I receive many file which I import into many different SQL
Server tables depending on the name of the file. I am doing this as
part of a larger automation process written in C#. Due to the csv
file names differing ...more >>
DTS always breaks. Posted by Jim Moon at 8/30/2004 2:14:38 PM Why does DTS always break when copying all objects and data from one
database to another?
It doesn't seem to matter which version of SQL Server, which server, which
server OS, which settings, which anything ...
Title Bar:
"DTS Import/Export Wizard"
Message:
"Failed to copy objects from ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Preserving package layout when calling SaveToStorageFile Posted by Lee Gillie at 8/30/2004 1:34:46 PM The DTS program manager had this to say about the behavior back in July
2000.
http://www.winnetmag.com/SQLServer/Article/ArticleID/8776/8776.html
"The Microsoft DTS program manager says pVarPersistStgOfHost is a stream
of the layout from Da Vinci (the graphical database viewer you see in
A...more >>
Paradox table import in SQL Server 2000 Posted by Mario Cappa at 8/30/2004 10:56:49 AM I need to import any paradox tables in SQL Server 2000, but i'm having
troubles with char conversion:
Does anyone have any idea about why all accented chars in source paradox
table turn into other chars in the new SQL Table:
à in paradox turns into Ó in SQL
è " " " " Þ ...more >>
No Logging for DTS Batch Posted by Ben at 8/30/2004 8:06:11 AM
I have a database with multiple tables. I perform 2 mass
imports a day on the tables from a txt file. None of the
columns are labeled or are in order so I cannot use any
command line utitlies for the import. I have the import
working in DTS, but I DO NOT WANT IT TO LOG THE
TRANSACTION...more >>
Using DTS to transform a production DB into a sample DB Posted by jsgough NO[at]SPAM mindspring.com at 8/29/2004 7:25:18 AM Greetings,
I'm trying to determine what the best way to go about the following
would be:
1. After making modifications of structure and data to a production
database, I want to make a backup of that db and copy it to multiple
standalone machines to import for further use as part of a sample...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |