|
|
|
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 SSIS Timeout error Posted by mystical potato at 7/31/2006 12:08:02 PM I am executing a Data Reader task connecting to a 2000 sql server using a
..net/sqlclient data provider. The task fails after 30 seconds and returns
the following error:
Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout
period elapsed prior to completion of the opera...more >>
Parameters to Insert SQL Posted by Maria at 7/31/2006 10:57:01 AM I am passing multiple variables from Dataflow into a SQL Task in Control
Flow. In SQLTask I have an insert statment, joining multiple tables and also
using variables.
For example
Insert into Table1
(Col1,Col2,Col3,Col4)
SELECT
?,
?,
empID,
getdate()
from blah1
where blah1.col3=99
...more >>
converting strings to Integers in SSIS Posted by namratha.pavar NO[at]SPAM gmail.com at 7/31/2006 8:40:00 AM Hi,
Is it possible to convert string data to integer in SSIS ? I tried
using the cast -- (DT_I8) and the Data Conversion data flow item. It
errors out saying "Failed to perform type cast". The DataConversion
doesnt work either.
Please let me know if you know how to perform this conversion....more >>
Dynamic table load Posted by hanan.taiber NO[at]SPAM gmail.com at 7/31/2006 8:10:14 AM Hi,
I know this subject has been around for quite some time now, but I
couldn't find a decent answer.
Scenario is simple. I have two meta-data tables, the first I'll call
defTables and the second defColumns. The first table defines names of
source and destination tables, and the second of s...more >>
Lotus Notes database transfer to SQL 2000 table having identity co Posted by vilas at 7/31/2006 7:49:01 AM I am using Notes Notes SQL Driver to pull the data from lotus notes database
and add it in SQL 2000. For this I have created a table for destination in
SQL 2000 database with identity column. While transferring the data, it works
well till last record, but once it on last record transfer, it t...more >>
Passing Variables to Control Flow Posted by Maria at 7/31/2006 7:03:01 AM I am passing multiple variables from Dataflow into a SQL Task in Control
Flow. In SQLTask I have an insert statment, joining multiple tables and also
using variables.
For example
Insert into Table1
(Col1,Col2,Col3,Col4)
SELECT
?,
?,
empID,
getdate()
from blah1
where blah1.col3=99
...more >>
Ho to trap 'Transformation Failures' Posted by StuartGMilton at 7/31/2006 4:59:55 AM Hey guys,
I am importing CSV files from a directory. These files may either have
5 columns or 4 columns (missing the last one).
I wish to import the 4 column version into an errors table in the db,
meanwhile the 5 column version is imported into the live table.
Anyone any idea how to go ...more >>
SSIS Package Error Posted by Terry at 7/31/2006 4:56:02 AM How can I determine what is causing the following package to fail?
Error: Error 0xC0012050 while loading package file "C:\Documents and
Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed
validation from the ExecutePackage task. The package cannot run. . ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server 2005 Scheduled Jobs failing Posted by djyoda at 7/31/2006 1:45:47 AM Hi Everyone,
I'm migrating a SQL Server 2000 instance to a new box running SQL
Server 2005. I've installed the SQL 2000 DTS components on the new box
which runs 2005 cause i need my existing DTS packages to keep running
on the new box.
I exported over the DTS packages, and am able to execu...more >>
DTS Package Fails Posted by bierlyt NO[at]SPAM gmail.com at 7/31/2006 1:07:27 AM Here's a situation you won't find every day.
I have a big database project that I am taking over. There is a set of
6 DTS Packages that import 6 tables from the Timberline accounting
software via ODBC every night. A 7th DTS Package calls each one of
these 6 DTS packages and is Scheduled to r...more >>
dts help copy database objects Posted by lara at 7/30/2006 12:00:00 AM Hi,
I need some help from you guys. As part of my new job, I need to create a
DTS Package to syncronize the production and QA Databases.The steps to
follow are
Say for example the databases contains more than 100 tables and we need to
copy the contents of few tables (say tab1, tab2, tab3.......more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |