|
|
|
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 Problems connecting DTS packages to SQL 2005 DBs? Posted by crowelldj NO[at]SPAM gmail.com at 10/31/2007 7:32:38 AM I am working on a project that has hundreds of DTS packages in use.
The company plans to convert the database engine to SQL Server 2005
next month. We do not have time to convert all of the DTS packages to
SSIS.
Is there a problem with having the DTS packages connect to SQL Server
2005 data...more >>
How to transform a global variable value to Visual FoxPro Fee Tabl Posted by May at 10/31/2007 1:46:02 AM
I am new to DTS. I would like to know how to transform a global variable
value to Visual FoxPro Fee Table? I created a Execute SQL Task with data
source from Visual FoxPro Fee Table, then I go to "Parameter" to set the
input parameter from global variable, but there is no dropdown list for...more >>
DtsPipelineException Invalid Class String Posted by mystical potato at 10/30/2007 9:51:03 AM I'm trying to run an SSIS package via a web service on my sql server. The
following code is generating error DtsPipelineException -2147221005 "Invalid
class String".
I can't seem to find anything searching for this error. What I'm doing is
pretty straight forward. Does anyone have any th...more >>
Error importing Excel Columns larger than 255 characters Posted by Marios at 10/30/2007 6:08:00 AM Guys,
I am trying to create a package where an Excel file is imported to a SQL
Server 2000 Database. Some columns contain text that is larger than 255
Characters. When I try to import I get the following error message:
Data for source column 6 ('....') is too large for the specified buffer s...more >>
Setting up Global [parameters in SQL 2000 DTS Posted by stainless at 10/30/2007 4:04:30 AM This problem is taken from an earlier post of min ebut I felt it
needed to be in its own post.
Is it possible to use a Global parameter passed in via DTSRUN, to set
up another Global parameter?
I will try and expand on this.
A DTS package is going to be reused for several different jobs. ...more >>
Schedule DTS Posted by ¤j¬Ó at 10/30/2007 12:00:00 AM Hi,
I have migrated some DTS from SQL2000 to SQL2005, how can I schedule a DTS
under SQL 2005?
...more >>
The number of failing rows exceeds the maximum specified. Unspecified error Posted by jay via SQLMonster.com at 10/29/2007 3:45:53 PM I received the following error on a failed DTS package 'The number of failing
rows exceeds the maximum specified. Unspecified error'.
I found the following error in the package log:
'Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:The statement has been ter...more >>
SQLServer Error: 536, Invalid length parameter passed to the SUBST Posted by JackO at 10/29/2007 12:18:00 PM I am trying to run an SSIS package from SQL Server 2005 Standard Edition with
SP2 and I am getting the following error: 'SQLServer Error: 536, Invalid
length parameter passed to the SUBSTRING function. [SQLSTATE 42000]'. I am
storing the packages in the SQL Server database and I have setup cre...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dynamic destination table Posted by stainless at 10/29/2007 12:00:00 AM I am writing a package that is dynamic based on a parameter passed in
via the DTSRUN command.
This needs to do the following, where the package parameter amend the
global parameter DataType before execution :
Loop until end of files:
Read 1st file in folder of name DataType (se...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |