|
|
|
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 Modifying the Loop-Import-Archive Package Posted by Conan Kelly at 8/31/2006 7:47:16 PM Hello all,
A while back I downloaded the sample Loop-Import-Archive package from www.SQLDTS.com and have put it to good use.
The problem I'm running into now is that instead of importing from a flat text file, I'm trying to modify it to import form MS
Excel. I need to import 2 different she...more >>
Permissions problem running DTS from batch file Posted by JoelB at 8/31/2006 3:44:09 PM We are trying to embed RunDTS.exe into a batch file to kick off a DTS
package. The batch file is run by a user from their workstation. When
logged in as Administrator, it runs beautifully. When run by the user, the
error listed at the end of this post occurs.
The user cannot be allowed ...more >>
Stay with DTS or move to SSIS? Posted by Michael Cessna at 8/31/2006 2:29:33 PM We've been using DTS for several years as part of a commercial application,
and it's worked fine, and still does in SQL 2005 using the backward
compatibility components. We've got existing code that uses the DTS API, and
I'm not sure we need to move to SSIS if DTS is working for us, considerin...more >>
Flat File w/ header and detail records Posted by dtaylo04 NO[at]SPAM gmail.com at 8/31/2006 1:55:31 PM I have a flat file that has both header and detail records in it. The
file is a fixed length and an abbreviated form of it would look like
this (the real file has lines that are 450 chars long with 50+ columns
depending on if it's a header record or detail record):
12340001SomeDealer SomeDe...more >>
Downloading Files From FTP Site Posted by kiran at 8/30/2006 10:47:22 PM Hi all,
This question is regarding downloading a
file from an FTP Server to local (through SSIS FTP Task). I have 2
questions to ask you.
1. I have Downloaded a file of 5.5 MB from FTP Server to Local through
(SSIS FTP Task).It took nearly 4 Minutes 20 seconds (N...more >>
TeraData ODBC - same connection with DTS Posted by Marcel K, MCDBA at 8/30/2006 9:40:02 AM I need to submit multiple Teradata statements using same open connection; The
first statement is a stored procedure that inserts data into a temp table in
teradata, the second retreives with a select from that table. If the
connection from first is closed then the data in temp table does not ...more >>
Exporting Multiple Tables (then importing them to another db) Posted by Mike Collins at 8/29/2006 11:05:01 AM We need to have a DTS package that takes in a parameter and exports records
from a main table that match the parameter and then exports records from
other, related, tables. Then a DTS package that imports this same data into
another db of the same structure. Can someone help me get started on ...more >>
Process OLAP cube via vbscript Posted by Jon Derbyshire at 8/29/2006 9:34:03 AM Hi,
I need to find out how to process an AS 2000 cube via vbscript.
So far I have set the following properties:
' *** Set Task Properties
oOLAPTaskProperties("Description").Value = "Process MyCube"
oOLAPTaskProperties("Datasource").Value = "MyDatasource"
oOLAPTaskProperties("TreeKey"...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Will upgrade to 2005 break dts packages Posted by Chris at 8/29/2006 7:39:01 AM Hello Everyone,
Will upgrading from SQL 2000 Standard Server to SQL 2005 Standard Server
break my exisiting dts packages? We have a large number of packages and I am
hoping that I will not have to recreate them.
TIA,
Chris...more >>
Web Service Task - Passing Variables as input Posted by Dani at 8/29/2006 7:36:21 AM Microsoft says it is possible but I just do not see how. Here is the
link to the help file where it said that variables could be pass as
input to web methods...I do not see the check box they mention on my
IDE.
Any help would be greatly appreciated.
Thanks,
Dani
...more >>
cannot create new ssis project Posted by keith_b at 8/29/2006 3:41:02 AM With SS eval (enterprise edition) I cannot see the template for SSIS projects
(only the one for Reporting Services) - can anyone help?
The report for setup says the SSIS service is correctly installed and the
service is running......more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |