Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
Thu, 18 Mar 2010 14:19:44 -0700
I have the same problem as the rest of the group, and i am trying to
read from MySQL (imagine that).
I have implemented the work around as suggested in the KB article,
http://support.microsoft.com/kb/969845.
After giving the DataReader a error row file destination, i put it in
production. The DTS_E_INDUCEDTRANS ...
|
Re: DTS_E_INDUCEDTRANSFORMFAILUREONERROR
Thu, 18 Mar 2010 14:17:39 -0700
I have the same problem as the rest of the group, and i am trying to
read from MySQL (imagine that).
I have implemented the work around as suggested in the KB article,
http://support.microsoft.com/kb/969845.
After giving the DataReader a error row file destination, i put it in
production. The DTS_E_INDUCEDTRANS ...
|
Using SSIS for SQL 2005 I would like to create an XML File using S
Thu, 18 Mar 2010 10:31:01 -0700
So if we created a an OLE DB Source with this SQL
select field_1, field_2, field_3
from table_1 For XML AUTO
It would create xml results from the TABLE then send the data to a RAW file
Destination, But the file is not valid because it is missing
<?xml version="1.0" encoding="ISO8859-1" ?> at the beginning ...
|
SQL 2005 Legacy DTS Package Migration Wizard
Wed, 17 Mar 2010 10:05:01 -0700
It appears I had successfully migrated sql server 2000 dts packages to sql
server 2005. However, I can't find them on sql server 2005. How do you
reference these packages.
Thanks in advance ...
|
How to Execute a DTSX package from VB.Net 2003.
Wed, 17 Mar 2010 06:17:30 -0700 (PDT)
Please advice on How to Execute a DTSX package from VB.Net 2003. ...
|
Importing EXCEL in SSIS with Formaula
Wed, 17 Mar 2010 02:53:01 -0700
Dears,
I'm trying to import excel sheet using SSIS, however if there is any cell
that has formula (C1 = A1 + A2), it appears as null.
...
|
DTS "the specified module could not be found"
Tue, 16 Mar 2010 15:28:23 -0400
I had to change the administrator password on a sql 2000 server and now the
packages under Data Transformation Services will not open up. I get the
error message: "the specified module could not be found" when trying to open
a module up or even trying to create a new package.
...
|
|
|
Predictive Analytics for Business, Marketing and Web 2010
Mon, 15 Mar 2010 14:15:03 -0700 (PDT)
Hi all,
Our training seminar on predictive analytics is coming three times
during 2010: April in NYC, May in San Jose and October in San
Francisco. This is an intensive training for analysts, marketers,
managers and business professionals to make actionable sense of
customer data by predicting buying behavi ...
|
Send Mail in SSIS for each record
Sat, 13 Mar 2010 14:49:01 -0800
I would like to accomplish the following:
1. Send Mail to an email address and individual's name retrieved from a list
retrieved by a select statement.
2. Customize the text in the email to incorporate the individual's name
(e.g. Robert or Sarah).
3. Add an variable attachment file (filename and path) bas ...
|
RE: cannot convert between unicode and non-unicode data types
Fri, 12 Mar 2010 14:23:28 GMT
I have been working this issue and the best solution is ask your DBA to drop the table and recreate it.. The destination data column.. I just resolved this issue... Or check and make sure you use Varchar only in your destn column
From http://www.developmentnow.com/g/103_2007_9_0_0_1023090/cannot-convert-between-uni ...
|