|
|
|
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 How to get a database from a sql server 2000 to a sql server 2005? Posted by rdufour at 9/7/2006 4:55:59 PM How do you get a copy of a database from a sql 2000 server to a sql 2005
database with the same database name?
Thanks for any help.
Bob
...more >>
Mainframe File using DTS FTP Posted by Shafeek Khalidh at 9/7/2006 12:22:17 PM Hi, I've a data file in mainframe server. Usually I ftp that file into ftp
drive from mainframe and then ftp it out from SQL Server.
Is there any way I can connect to the mainframe server using DTS FTP and get
the files.
Or what is the best method to get the flat file from mainframe using SQ...more >>
DTS text file import Posted by bill at 9/6/2006 2:29:09 PM I am importing a text file into a table within DTS. For some reason, the
import works fine but stops at line 1265 of the text file. Is there some
limitation as to how many characters can be imported in one transaction?
Thanks.
...more >>
Copying table Structure from one server to another Posted by kiran at 9/6/2006 2:51:48 AM Hi all,
I have a small problem. I want to create a table Say
"tab1" from Server A into Server B. I dont want to copy the whole
table.I just want a "create table" String which is derived from tab1 of
server A. I want this to be simple.
Is there any soln.
Thanks,
Kiran G
...more >>
Error Handling in DTS package Posted by jackso95 NO[at]SPAM hotmail.com at 9/4/2006 3:44:55 PM - Sql Server 2000 DTS
- Enabled Multi-phase datapump
- Dell Dual processor 1.2 GHZ w/ 1GB ram
Objective:
I am trying to do some error trapping in DTS so that if an error
occurrs, it will log the error and continue on. I am using an ActiveX
object to do the transformation.
I have set the "M...more >>
Import when you only have "Part" of the file name Posted by mayer4 NO[at]SPAM gmail.com at 9/4/2006 8:15:34 AM Morning,
Is there a way to import a text fie when you only know part of the file
name? What I have is a file that changes dynamically based on the date
and time. I will only have the date. The time always changes. I know
how to pull the date as part of a text file dynamically:
'************...more >>
SSIS and Schedule Jobs Posted by Hooman.B at 9/1/2006 2:50:02 PM We recently upgrade from SQL 2000 to 2005 and everything works great. But I
have a problem which I know due of lack of knowledge.
When I create a SSIS package with "SQL server business intelligence
developer studio" and then import it to "Stored packaged" and schedule it,
then it fails!...more >>
Foreign key constraint violation on import Posted by bostonguy NO[at]SPAM gmail.com at 9/1/2006 2:44:07 PM I posted this on the Integration Services board, but figured the answer
to my problem might not depend on whether I am using SSIS or DTS.
Scenario:
I have a SSIS package that loads a flat file to a SQL Server database
via an OLE DB Destination object. The flat file contains a column,
which ha...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server 2005 and stored procedure Posted by Kalyan at 9/1/2006 11:24:02 AM Hi
I created a new project in BI of SQL Server 2005, a DTS package importing
tables from SQL Server 2000, From BI i am able to execute, works fine. If
i goto Management studio i coultn't find DTS package.
How to execute DTS package developed as project in BI in stored procedure.
I am...more >>
DTS Designer Error No rowset was returned from the SQL statement Posted by Erik at 9/1/2006 7:11:27 AM I am running a stored proc that only has one return select statement
(the others are for inserting into a temp table. But I get the
following error...DTS Designer Error No rowset was returned from the
SQL statement.
Here is my proc
DECLARE @tmpOrg TABLE
(
code varchar(15),
display var...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |