Marcus Perryman explains the correct use of Connection Manager when a Windows Mobile application requires network data.
MSDN Magazine December 2008
View Complete Post
Can any one help me in this .
[Flat File Source ] Error: Data conversion failed. The data conversion for column "acct" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
[Flat File Source ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "acct" (373)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "acct" (373)" specifies failure on
error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error
messages posted before this with more information on why the thread was cancelled.
can any one help me in this error :
[Lookup ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Lookup" (465)" failed because error code 0xC020901E occurred, and the error row disposit
I have built a custom SSIS component for connecting to SQL Reporting Services in SSIS - including a custom data source and custom connection.
It works fine using 32bit DTEXEC and dtsdebughost, but I cannot get it to load in a 64bit environment.
Initialy I was compiling the dlls as MSIL (target=any), then I recompiled specifically targetting x64 (copying the dlls to the 64bit location and deploying to the GAC), just to see whether the problem was because of using an MSIL binary.
The 32bit version works as expected - are there any additional registration steps required for a 64bit Connection manager beyond copying to the /connections directory and installing into the GAC?
The output from DTSEXEC:
c:\Program Files\Microsoft SQL Server\90\DTS\Binn>DTExec.exe /f "e:\temp\SSISCus
tomADComponent\TestSSISSolution\Integration Services Project1\Package.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:07:30 p.m.
Error: 2010-09-22 12:07:43.89
Description: The connection type "SSRS" specified for connection manager "SQL
Server Reporting Services" is not recognized as a valid
Is there a way to use Excel Connection Manager with OpenRowSet
when the worksheet has a space in the name (e.g. "My Sheet"). I am using SQL Server 2008R2.
OpenRowset works fine without spaces in the worksheet name, but generates an error when a space is present. I have tried multiple  and ' ' combinations to bracket the worksheet name.
JG4 documented the same problem in a posting titled "Skipping leading rows in Excel"
(at the bottom of the thread):
i have problem with SSIS, Send Mail Task.
What the difference between Send Email using Database Mail and Send Mail task?
Because with Database Mail i can send test email successfully. And can get email using msdb.dbo.sp_send_dbmail.
But when i type SMTP Server on SMTP Connection Manager i get error.
Sending duration is ~10 seconds and error: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond [IP]."
It maybe problems because of firewall? But why i can send email through Database Mail?
I'm trying to read Connection Manager properties, but am stumbling when trying to access anything beyond the generic ConnectionManager objects. In it's stripped down format the code i'm using to read a Property is this:
string InputProperty = string.Empty;
PropertyInfo PropInfo = null; // Uses System.Reflection to get property info
foreach (ConnectionManager v in package.Connections)
PropInfo = typeof(ConnectionManager).GetProperty(InputProperty);
However if i'm trying to read an input property that's specific to a type of connection manager, e.g. Flat File Connection manager property HeaderRowsToSkip, the above code fails as the ConnectionManager object only serves up a few generic properties.
Now, I assume that I need to cast or similar to get the IDTSConnectionManagerFlatFile Connection type... but at this point I get lost. Can anybody give me a helpful pointer?
I have installed a default installation of SQL SERVER 2008 R2. Using the connection manager in BIDS (ie Add new data source for any project SSIS,SSAS,SSRS) I cannot obtain a list of databases from my server. The SQL Browser
service is running on the LOCAL SYSTEM, and TCP/IP & Named pipes are Enabled.
In the connection wizard, I do not get an error. The drop down box for available database simply shows up blank.
I would appreciate any help/suggestions
My connection managers don't save the passwords. The definitions are read from a configuration file, but when I view the properties, I see a blank field, and then if I fill the password, close the dialog and open it again, the field is blank again, although
I checked the "Save my passwords" checkbox.
What's going on?