SSIS OLE DB Command Fatal Error
Mar 24, 2008
I have a pretty simple senario.
In a data flow task, I have a OLE DB Source, which is a simple select statement. That is then connected to a OLE DB Command object, which executes a stored procedure on a different server, with the columns of the source as parameters to the stored procedure. I then have that connected to another OLE DB Command object, that will update the row in the source, marking it processed if there wasn't an error (no errors raised) in the stored procedure.
This seems to work just fine. Rows that had errors will error out, but I have the max allowed errors set very high to prevent the task from stopping. The problem that I have noticed is that if the very last row of the original source has an error, the component will fail with a fatal error and not go back and mark the rows that did succed as processed.
The fatal error looks like this:
Error: 0xC0047022 at OrderItems, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Insert OrderItem" (97) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
At this point I really believe this is a bug in SSIS, because if the last row succeeds, reguardless of how many rows failed in the middle, the last step runs, and updates the source as processed for the rows that did not fail. But if the last row fails, it doesn't execute the next step.
Has anyone experienced this before. I really hope there is a minor configuration change that can be made so I do not have to redesign the package. My only alternative at this point is to redesign the stored procedure to not raise an error, and return any errors in an output parameter, and then use a conditional split to determine what rows to go back and update at the source, and then rather than relying on the package output to see the errors, I'll have to write the errors to a table somewhere.
- Eric
View 1 Replies
ADVERTISEMENT
Nov 4, 2006
Hi All,
i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables,
enterName - String packageLevel (will store the name I enter)
myVar - String packageLevel. (to store the query)
I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName = " + @[User::enterName] + " )"
Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error.
Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E0C.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object.".
Can Someone guide me whr am going wrong?
myVar variable, i have set the ExecuteAsExpression Property to true too.
Please let me know where am going wrong?
Thanks in advance.
View 12 Replies
View Related
Sep 24, 2015
Got this error running a query with ssms2014
on SqlServer2014
but db has Compatibiliy level 100 (sql2008)
no sql error code in message and no error found in eventviewr (sqlserver log, windows log, application log ecc)when i run that query i got this message in "messages" tab, and in results tab i got a strange result, indeed the value returned doesn't exists in table.
ex table1.field1 possible values= 2,3
it returns 1113344
we got that error thru jdbc too...that query use a lot of joins, unfortunatley i can't post it here. today got this error, so i make a copy of 1 of involved table into another db in the same instance, re run the query on the original db, and it works well.
View 2 Replies
View Related
Sep 21, 2006
I have written a stored procedure that accepts 33 parameters. I am trying to execute the stored procedure from a SSIS OLE DB Command task. The code I am putting into the "SqlCommand" property is "Exec dbo.CO_PROD_UPDATE ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
View 6 Replies
View Related
Jun 15, 2006
Hi,
when we are using OLEDB Command we are getting the following error?
when we use sql server as the source its working fine .but its throwing error when we try to connect the orcale database .
Error at Data FLOW TASk[OLE DB Command[3863]]: An OLE DB error has occured :0x80040E51.
An OLE DB record is available. Source : "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E51
Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".
ERrror at Data Flow Task [OLE DB Command [3863]]: Unable to retrieve destination column description from the Parameter of the SQL Command
Thanks & Regards
Jegan.T
View 4 Replies
View Related
Jul 20, 2006
Hi
I've got an SSIS package, I'm in a Data Flow step that has a OLE DB Command Data Flow Transformation.
The SQLCommand in the OLD DB Command is:
______________________
UPDATE Employment_Episode_Dim
SET Commence_Serv_Date = ?
WHERE AGS_Number = ?
______________________
The package will run through successfully, but I don't see any updates
in Employment_Episode_Dim. I ran a trace, and this is a sample of the
SQL that is being executed:
______________________
exec sp_executesql N'UPDATE EMPLOYMENT_EPISODE_DIM
SET COMMENCE_SERV_DATE = @P1
WHERE (AGS_NUMBER = @P2)',N'@P1 datetime,@P2 int',''2005-01-27
00:00:00:000'',78577229
______________________
If I take that SQL and execute it in a query window, it fails due to
two single quotation marks placed around the date parameter being used
as @P1.
Why does SQL/SSIS put two singles around the date? It's outside of the
string to be executed, so it doesn't seem to need to have the double.
Can anyone please help?
Thanks
Earth
View 2 Replies
View Related
May 25, 2007
hi,
I am having trouble executing a DB2 stored procedure using OLE DB command task.
The stored procedure takes 2 paramters.
1. filename 2. logfilename
filename - servernamefoldername extfilename
logfilename - servernamefoldernamelogfilename
Both are user defined variables with data type string. i created 2 dervied columns FILE and LOG to pass these values.
FILE takes the filename value
LOG takes the logfilename value
When I execute it gives me the following errors.
[OLE DB Command 1 [77]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: "[DB2/NT] SQL0811N The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row. SQLSTATE=21000 ".
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Command 1" (77) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009.
Can anyone please help me resolve this issue.
I can execute the SP using execute sql task but the problem is I need to pass the rejected rows to a reject table for logging purposes. thts why am tryin the OLE DB command.
Thank You
View 7 Replies
View Related
Feb 3, 2006
When trying to improve my app, I actually broke it (as you do) and came up with the error message reproduced herein. Any help in understanding the nature of the error and how to go about resolving it would be more than handy
Server Error in '/' Application.
Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734854
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlDataReader.HasMoreRows() +150
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214
System.Data.SqlClient.SqlDataReader.Read() +9
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +156
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +172
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
Thank you in advance.
View 4 Replies
View Related
Aug 18, 2006
Extended error: [What='Offending SQL: Select max(CommitTime) as LastChangeTime from ChangeTable;Warning: Fatal error 823 occurred at Aug 18 2006 8:42AM. '] [LCID='1024'] [SourceFile=''] [SourceFileLine='-1'] [DebugInfo=''] [RecommendedAction='The ODBC data source may be incorrectly configured, the database may not be running, or there may be incorrect data in the database.'] [ExtraInfo=''] [UniqueErrorId='4005'] [Severity='5'] [Source='(ISOK File serverwrapper.cpp, Line 501)'] [CategoryId='0']
what does this error means & how it cud be resolved.
View 3 Replies
View Related
Jun 22, 2008
Here is the SQLDump log from our system. This database has not been backed up for a long time and a recent backup attempt failed. Without a recent backup, what would you advise our next step be?
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.3054.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is INTEL - 20030825
BIOS Date: 08/25/03 14:08:08 Ver: 08.00.09
Current time is 14:38:58 06/20/08.
1 Intel x86 level 15, 3 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.
Memory
MemoryLoad = 69%
Total Physical = 3054 MB
Available Physical = 929 MB
Total Page File = 4416 MB
Available Page File = 2393 MB
Total Virtual = 2047 MB
Available Virtual = 322 MB
DBCC RESULTS
--------------------
<DbccResults>
<Dbcc ID="0" Error="8966" Severity="16" State="2">Unable to read and latch page (1:258137) with latch type SH. 23
(Data error (cyclic redundancy check).) failed. </Dbcc>
<Dbcc ID="1" Error="8966" Severity="16" State="2">Unable to read and latch page (1:260400) with latch type SH. 23
(Data error (cyclic redundancy check).) failed. </Dbcc>
<Dbcc ID="2" Error="8954" Severity="10" State="1">CHECKDB found 0 allocation errors and 2 consistency errors not
associated with any single object.</Dbcc>
<Dbcc ID="3" Error="2533" Severity="16" State="1">Table error: page (1:258137) allocated to object ID 885682303,
index ID 16, partition ID 72057594204127232, alloc unit ID 72057594215858176 (type In-row data) was not seen. The
page may be invalid or may have an incorrect alloc unit ID in its header.</Dbcc>
<Dbcc ID="4" Error="8976" Severity="16" State="1">Table error: Object ID 885682303, index ID 16, partition ID 720
57594204127232, alloc unit ID 72057594215858176 (type In-row data). Page (1:258137) was not seen in the scan alth
ough its parent (1:257976) and previous (1:258136) refer to it. Check any previous errors.</Dbcc>
<Dbcc ID="5" Error="8978" Severity="16" State="1">Table error: Object ID 885682303, index ID 16, partition ID 720
57594204127232, alloc unit ID 72057594215858176 (type In-row data). Page (1:258138) is missing a reference from p
revious page (1:258137). Possible chain linkage problem.</Dbcc>
<Dbcc ID="6" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 3 consistency errors in t
able 'ActivityPointerBase' (object ID 885682303).</Dbcc>
<Dbcc ID="7" Error="2533" Severity="16" State="1">Table error: page (1:260400) allocated to object ID 1339971950,
index ID 1, partition ID 72057594205503488, alloc unit ID 72057594217365504 (type In-row data) was not seen. The
page may be invalid or may have an incorrect alloc unit ID in its header.</Dbcc>
<Dbcc ID="8" Error="8976" Severity="16" State="1">Table error: Object ID 1339971950, index ID 1, partition ID 720
57594205503488, alloc unit ID 72057594217365504 (type In-row data). Page (1:260400) was not seen in the scan alth
ough its parent (1:14431) and previous (1:260391) refer to it. Check any previous errors.</Dbcc>
<Dbcc ID="9" Error="8978" Severity="16" State="1">Table error: Object ID 1339971950, index ID 1, partition ID 720
57594205503488, alloc unit ID 72057594217365504 (type In-row data). Page (1:260401) is missing a reference from p
revious page (1:260400). Possible chain linkage problem.</Dbcc>
<Dbcc ID="10" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 3 consistency errors in
table 'AsyncOperationBase' (object ID 1339971950).</Dbcc>
<Dbcc ID="11" Error="8989" Severity="10" State="1">CHECKDB found 0 allocation errors and 8 consistency errors in
database 'Mindsharp_MSCRM'.</Dbcc>
<Dbcc ID="12" Error="8957" Severity="-1" State="1">DBCC CHECKDB (Mindsharp_MSCRM) WITH no_infomsgs executed by MI
NDSHARPAdministrator found 8 errors and repaired 0 errors. Elapsed time: 0 hours 7 minutes 16 seconds.</Dbcc>
<Dbcc ID="13" Error="8958" Severity="10" State="1">repair_allow_data_loss is the minimum repair level for the err
ors found by DBCC CHECKDB (Mindsharp_MSCRM).</Dbcc>
</DbccResults>
**Dump thread - spid = 62, PSS = 0x52C0D320, EC = 0x52C0D328
***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLLOGSQLDump0002.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/20/08 14:38:58 spid 62
*
* DBCC database corruption
*
* Input Buffer 82 bytes -
* DBCC CHECKDB WITH NO_INFOMSGS
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
PSS @0x52C0D320
---------------
CSession @0x52C0C278
--------------------
m_spid = 62 m_cRef = 14 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 11 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x52C0C040
m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x83e0 m_fBackground = 0
m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 540428 m_eclClient = 5 m_protType = 6
m_hHttpToken = FFFFFFFF
m_pV7LoginRec
---------------------
00000000: 3c010000 03000a73 00100000 00000006 840c0000 †<......s............
00000014: 00000000 e0830000 00000000 00000000 5e000500 †................^...
00000028: 00000000 00000000 68002e00 c4000500 ce000000 †........h...........
0000003C: ce001c00 06010000 06010000 0007e959 912e0601 †...............Y....
00000050: 36003c01 00003c01 00000000 0000†††††††††††††††6.<...<.......
CPhysicalConnection @0x52C0C188
-------------------------------
m_pPhyConn->m_pmo = 0x52C0C040 m_pPhyConn->m_pNetConn = 0x52C0C7B0 m_pPhyConn->m_pConnList = 0x52C0C260
m_pPhyConn->m_pSess = 0x52C0C278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 4096
m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0
CBatch @0x52C0CAB8
------------------
m_pSess = 0x52C0C278 m_pConn = 0x52C0CA18 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0085B4C8
EXCEPT (null) @0x3447B748
-------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x02416380
Task @0x0085B4C8
----------------
CPU Ticks used (ms) = 118929 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x0
ThreadId = 0x141c m_state = 0 m_eAbortSev = 0
EC @0x52C0D328
--------------
spid = 62 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 __fSubProc = 1
ec_dbccContext = 0x3447F560 __pSETLS = 0x52C0CA58 __pSEParams = 0x52C0CCF8
__pDbLocks = 0x52C0D618
SEInternalTLS @0x52C0CA58
-------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x0085B4C8
m_activeHeapDatasetList = 0x52C0CA58 m_activeIndexDatasetList = 0x52C0CA60
SEParams @0x52C0CCF8
--------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x276C06B8 m_pSessionLocks = 0x52C0D828
m_pDbLocks = 0x52C0D618 m_execStats = 0x525CA508 m_pAllocFileLimit = 0x00000000
Thank you,
Tim
View 2 Replies
View Related
Oct 16, 2007
Hello,
I have tried two ways for executing a query and creating a dependency
on it, one using plain Sql commands, the other using Enterprise
Library wrapped commands.
I keep getting:
Warning: Fatal error 682 occurred at Oct 12 2007 11:01AM. Note the
error and time, and contact your system administrator.
string xml = cmd.ExecuteScalar() as string;
When I execute it. Does anyone know what could cause this.
I have read both of these posts and have not yet been able to
investigate the SQL machine's event viewer though:
http://forums.asp.net/p/959871/1188606.aspx#1188606
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1203630&SiteID=1
The "value" column is an XML datatype field.
Thanks,
Josh
public static ContentXmlUtilResult GetContentXml(
string key,
bool createDependency)
{
ContentXmlUtilResult result = new ContentXmlUtilResult();
string connString = Global.Current.ConnectionString;
using (SqlConnection conn =
new SqlConnection(connString))
{
SqlCommand cmd =
new SqlCommand(
"SELECT Value FROM dbo.ContentXml WHERE [Key]
= '" + key + "'",
conn);
if (createDependency)
{
System.Web.Caching.SqlCacheDependency dependency =
new SqlCacheDependency(cmd);
result.Dependency = dependency;
}
conn.Open();
string xml = cmd.ExecuteScalar() as string;
conn.Close();
result.Content = xml;
}
return result;
//SqlCommand cmd = (SqlCommand)
// Global.Current.Database.GetSqlStringCommand(
// //@"SELECT Value FROM dbo.ContentXml WHERE [Key] =
@Key");
// @"SELECT Value FROM dbo.ContentXml WHERE [Key] = '"
+ key + "'");
////cmd.Parameters.Add("@Key", SqlDbType.VarChar).Value =
key;
//if (createDependency)
//{
// System.Web.Caching.SqlCacheDependency dependency =
// new System.Web.Caching.SqlCacheDependency(cmd);
// result.Dependency = dependency;
//}
//string xml = Global.Current.Database.ExecuteScalar(cmd)
as string;
//result.Content = xml;
//return result;
}
View 1 Replies
View Related
Jul 23, 2005
Whats happening:Error#: 40002Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement hasbeen terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,Column4, Column5, Column6) VALUES("","Value1","Value2","Value3","Value4","Value5")'Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement hasbeen terminated.Active Form: frmFormForm Name:---GETID Stored Procedure:---CREATE PROCEDURE GETID @strsql text ASPRINT cast(@strsql as varchar(4000))EXEC(" "+@strsql + " select @@identity as id")GO---Anyone know what could be causing it? The database has changed - thefrontend code hasn't, so it has to be a database problem. Whathappened was a few tables became incorrect so we restored them from abackup. Everything else seems to work, apart from adding a new recordto this table.You can edit current records etc..just not add.Thanks in advance,
View 1 Replies
View Related
May 13, 2008
While staring up ( XP home edition) I have the following error message: Fatal Error-Open Reg Key ex0 Failed, followed by Load Failed message.
The system boots up but the desktop item/icons & task bar keeps going on and off for awhile until only wallpaper is displayed. Mouse pointer still active but right/left click not responding.The system does not respond anymore at this point. When rebboting same thing happens.
Any idea what caised the problem and how to fix it?............thanks, LP
View 1 Replies
View Related
Oct 25, 2006
Hi all,I don’t know what happened to this function which was working OK for a few month and today it doesn’t work.In debug mode I kip getting “InvalidOperationaException was unhandled by user code”On this line:dtrResults = cmdSelect.ExecuteReader()Same behaviour on developping PCI cant find anithing that would create that problem. Function GetUserInfo(ByVal myUsr As String, ByVal strRequest As String) As String
Dim strConString As String
Dim conUsers As SqlConnection
Dim cmdSelect As SqlCommand
strConString = ConfigurationSettings.AppSettings("conString2")
conUsers = New SqlConnection(strConString)
Dim dtrResults As SqlDataReader
Dim intField As Integer
Dim usr As String
usr = "select " & strRequest & " user_ID from userlist where ul_user='"
usr &= myUsr & "'"
conUsers.Open()
cmdSelect = New SqlCommand(usr, conUsers)
dtrResults = cmdSelect.ExecuteReader()
While dtrResults.Read()
For intField = 0 To dtrResults.FieldCount - 1
GetUserInfo = dtrResults(intField).ToString()
Next
End While
conUsers.Close()
dtrResults.Close()
Return GetUserInfo
End Function Any Help will highly appriciated.Alex.
View 1 Replies
View Related
Sep 13, 2007
Hi All,
In one of my SSIS package (which connect to DB2) i save the DB2 username and password in SSIS packge itself by using option "EncryptAllWithPassword".
When I try to run the packge using dtexecui.exe it works perfectly fine. It prompts me for package password and then run fine.
Now I am trying to run it using command line dtxece.exe and i get fooolwoing error. Please suggest and help!!!
DTExec.exe /FILE C:pkgDB2Load.dtsx /CONFIGFILE C:ConfigpkgConfigMaster.dtsConfig /Decrypt mypassword /CHECKPOINTING OFF /REPORTING EWCDI
Error Message:
----------------------
Description: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "IBM OLE DB Provider for DB2 Servers" Hresult: 0x80040E21 Description: " SQL30082N Attempt to establish connection fa
iled with security reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001
"
Thanks
Sid
View 1 Replies
View Related
Feb 9, 1999
Has anyone ever seen fatal error 1109, I cannot find any info on it. Also, our msdb was either corrupted at a clients site or someone deleted it and tried to recreate it to cover themselves....any how...all of the stored procedures are missing from it and it will not let us back up data or schedule tasks...do I need to re-install SQL Server 6.5 to fix this?
Thank you.
View 1 Replies
View Related
Aug 22, 2006
Hi,
I created one Installation file with below settings
[Options]
USERNAME=Developer
COMPANYNAME=Worldspan
INSTALLSQLDIR="C:SQL Server"
INSTALLSQLSHAREDDIR="C:SQL Server"
INSTALLSQLDATADIR="C:SQL Server"
INSTALLASDATADIR="C:SQL Server"
ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_FullText,Notification_Services,NS_Engine,NS_Client,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,Tools_Legacy,SQL_Documentation,SQL_BooksOnline,SQL_AdventureWorksSamples,SQL_Samples
SAMPLEDATABASESERVER=".LOCALDEV2005"
INSTANCENAME=LOCALDEV2005
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
SQLACCOUNT="NT AUTHORITYSYSTEM"
AGTACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=1
SECURITYMODE=SQL
SAPWD=L0ca1Dev$a
DISABLENETWORKPROTOCOLS=2
If I do the installation with the default path the installation goes fine or else the Installation fails with a fatal error. I have pasted the error log below :
Microsoft SQL Server 2005 Setup beginning at Mon Aug 21 22:13:33 2006
Process ID : 3060
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/7/21 22:13:33
Complete: LoadResourcesAction at: 2006/7/21 22:13:33, returned true
Running: ParseBootstrapOptionsAction at: 2006/7/21 22:13:33
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/7/21 22:13:33, returned true
Running: ValidateWinNTAction at: 2006/7/21 22:13:33
Complete: ValidateWinNTAction at: 2006/7/21 22:13:33, returned true
Running: ValidateMinOSAction at: 2006/7/21 22:13:33
Complete: ValidateMinOSAction at: 2006/7/21 22:13:33, returned true
Running: PerformSCCAction at: 2006/7/21 22:13:33
Complete: PerformSCCAction at: 2006/7/21 22:13:33, returned true
Running: ActivateLoggingAction at: 2006/7/21 22:13:33
Complete: ActivateLoggingAction at: 2006/7/21 22:13:33, returned true
Running: DetectPatchedBootstrapAction at: 2006/7/21 22:13:33
Complete: DetectPatchedBootstrapAction at: 2006/7/21 22:13:33, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__3060" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2006/7/21 22:13:33
Complete: PerformDotNetCheck2 at: 2006/7/21 22:13:33, returned true
Running: InvokeSqlSetupDllAction at: 2006/7/21 22:13:33
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [LHDQSKUMARR]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
Instance Name = LOCALDEV2005
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Machine = LHDQSKUMARR, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = XMLDomDocument, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = Processor, Result = 70010 (0x1117a)
Machine = LHDQSKUMARR, Article = PhysicalMemory, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = OSVersion, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = OSServicePack, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = OSType, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = iisDep, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = AdminShare, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = PendingReboot, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = PerfMon, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = IEVersion, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = COMPlus, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: LHDQSKUMARR
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements.
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2006/7/21 22:13:54, returned true
Running: SetPackageInstallStateAction at: 2006/7/21 22:13:54
Complete: SetPackageInstallStateAction at: 2006/7/21 22:13:54, returned true
Running: DeterminePackageTransformsAction at: 2006/7/21 22:13:55
Complete: DeterminePackageTransformsAction at: 2006/7/21 22:13:55, returned true
Running: ValidateSetupPropertiesAction at: 2006/7/21 22:13:55
Complete: ValidateSetupPropertiesAction at: 2006/7/21 22:13:55, returned true
Running: OpenPipeAction at: 2006/7/21 22:13:55
Complete: OpenPipeAction at: 2006/7/21 22:13:55, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2006/7/21 22:13:55
Complete: CreatePipeAction at: 2006/7/21 22:13:55, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2006/7/21 22:13:56
Complete: PopulateMutatorDbAction at: 2006/7/21 22:13:56, returned true
Running: GenerateRequestsAction at: 2006/7/21 22:13:56
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = -1
SQL_FullText = 3
SQL_SharedTools = 3
SQL_BC_DEP = 3
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = 3
NS_Engine = 3
NS_Client = 3
SQL_DTS = 3
Client_Components = 3
Connectivity = 3
SQL_Tools90 = 3
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = 3
TOOLS_BC_DEP = 3
SQL_Documentation = 3
SQL_BooksOnline = 3
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = 3
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = 3
Complete: GenerateRequestsAction at: 2006/7/21 22:13:57, returned true
Running: CreateProgressWindowAction at: 2006/7/21 22:13:57
Complete: CreateProgressWindowAction at: 2006/7/21 22:13:57, returned true
Running: ScheduleActionAction at: 2006/7/21 22:13:57
Complete: ScheduleActionAction at: 2006/7/21 22:13:58, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Running: InstallDTSAction.11 at: 2006/7/21 22:13:58
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallDTSAction.11 at: 2006/7/21 22:14:0, returned true
Running: InstallDTSAction.12 at: 2006/7/21 22:14:0
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallDTSAction.12 at: 2006/7/21 22:14:2, returned true
Running: InstallDTSAction.18 at: 2006/7/21 22:14:2
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallDTSAction.18 at: 2006/7/21 22:14:4, returned true
Running: InstallDTSAction.22 at: 2006/7/21 22:14:4
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallDTSAction.22 at: 2006/7/21 22:14:7, returned true
Running: InstallDTSAction.9 at: 2006/7/21 22:14:7
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallDTSAction.9 at: 2006/7/21 22:14:8, returned true
Running: InstallNSAction.11 at: 2006/7/21 22:14:8
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallNSAction.11 at: 2006/7/21 22:14:10, returned true
Running: InstallNSAction.12 at: 2006/7/21 22:14:10
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallNSAction.12 at: 2006/7/21 22:14:12, returned true
Running: InstallNSAction.18 at: 2006/7/21 22:14:12
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallNSAction.18 at: 2006/7/21 22:14:21, returned true
Running: InstallNSAction.22 at: 2006/7/21 22:14:22
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallNSAction.22 at: 2006/7/21 22:14:24, returned true
Running: InstallNSAction.9 at: 2006/7/21 22:14:24
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallNSAction.9 at: 2006/7/21 22:14:25, returned true
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2006/7/21 22:14:26
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallSqlAction.11 at: 2006/7/21 22:14:28, returned true
Running: InstallSqlAction.12 at: 2006/7/21 22:14:28
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallSqlAction.12 at: 2006/7/21 22:14:30, returned true
Running: InstallSqlAction.18 at: 2006/7/21 22:14:30
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallSqlAction.18 at: 2006/7/21 22:14:32, returned true
Running: InstallSqlAction.21 at: 2006/7/21 22:14:32
Installing: sqlwriter on target: LHDQSKUMARR
Complete: InstallSqlAction.21 at: 2006/7/21 22:14:34, returned true
Running: InstallSqlAction.22 at: 2006/7/21 22:14:34
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallSqlAction.22 at: 2006/7/21 22:14:36, returned true
Running: InstallSqlAction.9 at: 2006/7/21 22:14:36
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallSqlAction.9 at: 2006/7/21 22:14:38, returned true
Running: InstallToolsAction.11 at: 2006/7/21 22:14:38
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallToolsAction.11 at: 2006/7/21 22:14:41, returned true
Running: InstallToolsAction.12 at: 2006/7/21 22:14:41
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallToolsAction.12 at: 2006/7/21 22:14:43, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.18 at: 2006/7/21 22:14:43
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallToolsAction.18 at: 2006/7/21 22:14:46, returned true
Running: InstallToolsAction.20 at: 2006/7/21 22:14:46
Installing: BOL on target: LHDQSKUMARR
Complete: InstallToolsAction.20 at: 2006/7/21 22:15:36, returned true
Running: InstallToolsAction.22 at: 2006/7/21 22:15:36
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallToolsAction.22 at: 2006/7/21 22:15:38, returned true
Running: InstallToolsAction.9 at: 2006/7/21 22:15:38
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallToolsAction.9 at: 2006/7/21 22:15:40, returned true
Running: InstallDTSAction at: 2006/7/21 22:15:40
Installing: dts on target: LHDQSKUMARR
Failed to install package
Fatal error during installation.
Setting package return code to: 1603
Complete: InstallDTSAction at: 2006/7/21 22:16:30, returned false
Error: Action "InstallDTSAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Running: InstallNSAction.10 at: 2006/7/21 22:16:30
Installing: sqlxml4 on target: LHDQSKUMARR
Complete: InstallNSAction.10 at: 2006/7/21 22:16:32, returned true
Running: InstallSqlAction at: 2006/7/21 22:16:32
Installing: sql on target: LHDQSKUMARR
******* Got commit request from MSI *******
Complete: InstallSqlAction at: 2006/7/21 22:19:4, returned true
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Running: InstallNSAction at: 2006/7/21 22:19:4
Installing: ns on target: LHDQSKUMARR
Failed to install package
Fatal error during installation.
Setting package return code to: 1603
Complete: InstallNSAction at: 2006/7/21 22:20:17, returned false
Error: Action "InstallNSAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Running: InstallToolsAction at: 2006/7/21 22:20:17
Installing: tools on target: LHDQSKUMARR
Failed to install package
Fatal error during installation.
Setting package return code to: 1603
Complete: InstallToolsAction at: 2006/7/21 22:22:8, returned false
Error: Action "InstallToolsAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
No install request found for package: "bcRedist", install will be skipped as a result.
Skipped: UninstallForMSDE2000Action
Skipped: Action "UninstallForMSDE2000Action" was not run. Information reported during analysis:
No install request found for package: "patchMSDE2000", install will be skipped as a result.
Skipped: UninstallForSQLAction
Skipped: Action "UninstallForSQLAction" was not run. Information reported during analysis:
No install request found for package: "patchLibertySql", install will be skipped as a result.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2006/7/21 22:22:9
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097
I have a pentium PC with 599 MHZ speed and 1.5 GB of RAM with Windowsxp SP2. I already have an instance of SQL 2005 running at my box. Let me know if you need any more logs. When I tried to start the sql server it is working fine.
View 1 Replies
View Related
Nov 15, 2007
Hello,
Just yesterday I implemented SqlCacheDependencies on my ASP.NET 2.0 web site for SQL Server 2005. My SQL Server 2005 database is in mode 90, mirrored with a second database server. Now I am getting Error 17310 while running very simple statements, but only on a specific table.
We have a table called "tblSchools" which, due to negligence and incompetence, has a maximum size of over 8,000. I plan on fixing that eventually, by splitting all the long varchar(2048) fields off into other tables.
I wanted to use SqlCacheDependencies on this table, for every single column. So I created a DateTime column called LastChanged and created a trigger. I am using LastChanged as a DateTime type instead of a TimeStamp/RowVersion type because I thought it would be more useful.
Here are the changes made:
---------------------------
-- Adding the column...
ALTER TABLE tblSchools
ADD
LastChanged DateTime Null
GO
-- The program uses this stored procedure to watch the "LastChanged" column.
CREATE PROCEDURE [apCacheWatchSchool]
@SchoolID int
AS
select LastChanged from dbo.tblSchools where SchoolID = @SchoolID
GO
-- Any updates on the table cause the LastChanged column to be updated with getdate()
CREATE TRIGGER [UpdateLastChanged_TS]
ON [dbo].[tblSchools]
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON;
update [dbo].[tblSchools]
set LastChanged = getdate()
where SchoolID in (select SchoolID from inserted);
END
GO
---------------------------
After adding this column and the trigger and s-proc, any update to any row in tblSchools fails with error 17310. It CANNOT set LastChanged to anything. It has to remain NULL. I was able to perform the following operation (as long as the tblSchools.LastChanged updating trigger [UpdateLastChanged_TS] was disabled): "update tblSchools set SchoolName = 'ZZZZ' + SchoolName where SchoolID = 185" -- so, it's not some kind of row length limit. I think it's a limit on # of columns that can be dealt with. I don't really know.
I don't know where the problem is occurring. I am just telling you why. I got around the problem (temporarily) by simply having the trigger update a DateTime column in another table, and having the SqlCacheDependency watch that column in the other table. No biggie.
As for moving some of the enormous varchar columns off of tblSchools... I don't really care enough. I guess that's why it's been like this for so long.
So, my problem is fixed, I just wanted to submit this bug report so you can at least fail gracefully in the next version of SQL Server.
I have the log/txt/mdmp files available, and can provide them upon request; they're too big for this form, sorry. Please contact me at plushpuffin AT wwddfd.com if you have any questions.
View 1 Replies
View Related
Jun 1, 2007
Using the SqlClient provider I'm trying to write big datachunks of maybe 20 MB each to SQL server to store in BLOBs using blobColumn.Write(...) using .NET 2.0 dbcommand object calling a Stored procedure
CREATE PROCEDURE [dbo].[putBlobByPK]
(
@id dKey
, @value VARBINARY(MAX)
, @offset bigint
, @length bigint
, @ModDttm dModDttm OUT
, @ModUser dModUser OUT
, @ModClient dModClient OUT
, @ModAppl dModAppl OUT
)
....
When doing this I can do this exactly 3 times than the application hangs (for ever).
When looking in the SQL Server log, I find the following to errors:
Error: 4014, Severity: 20, Status: 2.
A fatal error occurred while reading the input stream from the network. The session will be terminated.
I don't get this error on the client! OK, the session died.
What may be the problem?
I write big chunks like this to avoid many writes as the data shall be replicated later using peer to peer replication. And the more writes used for writing the total BLOB the more huge becomes the transaction log of the subscriber database.
TIA
Hannoman
View 1 Replies
View Related
Oct 15, 2007
We've deployed an assembly to a new production sql server 2005 instance, and have been having periodic restarts of sql server. The sql server service appears to be stopping and restarting on it's own since the assembly was deployed.
We've narrowed it down to a decryption method. We haven't been able to produce the issue on a consistant basis. Even if we put a ton of load on the stored procedure calls.
The error is below we receive (I cut out some, so it would fit in the thread), we also have mdmp files, that I've attempted to debug with Visual Studio 2005 and Windbg with no success. I have all the symbols (I'm pretty sure), but I don't have much experience with WinDbg, so it's been slow going.
Here's a little about the environment.
Windows Server 2003 Enterprise x64 SP2
Microsoft SQL Server version 9.00.3042.00 SP2
16 MB physical memory
Quad 3.2 GHz Xeon
3 sets of raid drives.
c: OS
e: sql data
e: sql logs
All Sql and windows patches are up to date.
Only thing I can figure is this is something to do with the .NET libraries. When the assembly was compiled it was set to compile for any CPU. We even tried compiling on the 64 bit OS with no luck still.
If anyone has had a similar issue, it would be most helpful, thanks,
Byron
---------------------------------------------------------------
Memory
MemoryLoad = 9%
Total Physical = 16382 MB
Available Physical = 14760 MB
Total Page File = 32159 MB
Available Page File = 30633 MB
Total Virtual = 8388607 MB
Available Virtual = 8365517 MB
**Dump thread - spid = 56, PSS = 0x0000000092BDFE90, EC = 0x0000000092BDFEA0
***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0067.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/07 15:49:11 spid 56
*
* A fatal error occurred in .NET Framework runtime.
*
* Input Buffer 62 bytes -
* u t i l s . d b 17 00 75 00 74 00 69 00 6c 00 73 00 2e 00 64 00 62 00
* o . d e c r y p t 6f 00 2e 00 64 00 65 00 63 00 72 00 79 00 70 00 74 00
* B a s e 6 4 §@ 42 00 61 00 73 00 65 00 36 00 34 00 00 00 00 01 a7 40
* Ã? 4 1f 09 04 d0 00 34 00 00
*
*
*
* -------------------------------------------------------------------------------
* Short Stack Dump
0000000077D67D8D Module(kernel32+0000000000027D8D)
0000000001D345DE Module(sqlservr+0000000000D345DE)
0000000001D3F3A9 Module(sqlservr+0000000000D3F3A9)
0000000002156D83 Module(sqlservr+0000000001156D83)
00000000021571C2 Module(sqlservr+00000000011571C2)
000006427F8F5FFD Module(mscorwks+00000000005C5FFD)
000006427FA4855B Module(mscorwks+000000000071855B)
000006427F888C4B Module(mscorwks+0000000000558C4B)
000006427F5D51C8 Module(mscorwks+00000000002A51C8)
000006427F5D5113 Module(mscorwks+00000000002A5113)
000006427F453A5A Module(mscorwks+0000000000123A5A)
0000000077F251EC Module(ntdll+00000000000651EC)
0000000077EE5F36 Module(ntdll+0000000000025F36)
0000000077EF31DD Module(ntdll+00000000000331DD)
000006427FA5089B Module(mscorwks+000000000072089B)
000006427806C7F8 Module(mscorlib.ni+000000000006C7F8)
000006427806B564 Module(mscorlib.ni+000000000006B564)
000006428029CBB7 Module(UNKNOWN+0000000000000000)
00000642788A6088 Module(mscorlib.ni+00000000008A6088)
000000000818E8F0 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
000000000818E7D0 Module(UNKNOWN+0000000000000000)
000000000818E090 Module(UNKNOWN+0000000000000000)
00000005010A5F40 Module(UNKNOWN+0000000000000000)
00000005010A5F60 Module(UNKNOWN+0000000000000000)
00000005010A5F90 Module(UNKNOWN+0000000000000000)
00000005010A5FC0 Module(UNKNOWN+0000000000000000)
00000005010A5FD8 Module(UNKNOWN+0000000000000000)
00000005010A6020 Module(UNKNOWN+0000000000000000)
00000005010A63B0 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000019 Module(UNKNOWN+0000000000000000)
00000000841EC050 Module(UNKNOWN+0000000000000000)
00000005010A5F40 Module(UNKNOWN+0000000000000000)
00000005010A5F60 Module(UNKNOWN+0000000000000000)
00000005010A5F90 Module(UNKNOWN+0000000000000000)
00000005010A5FC0 Module(UNKNOWN+0000000000000000)
00000005010A5FD8 Module(UNKNOWN+0000000000000000)
00000005010A6020 Module(UNKNOWN+0000000000000000)
00000005010A6020 Module(UNKNOWN+0000000000000000)
00000005010A6180 Module(UNKNOWN+0000000000000000)
00000005010A63B0 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000001900000409 Module(UNKNOWN+0000000000000000)
0000000000000001 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
000000000818E7D0 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
000000000818E200 Module(UNKNOWN+0000000000000000)
000000000818E200 Module(UNKNOWN+0000000000000000)
0000064280400218 Module(UNKNOWN+0000000000000000)
000000000818E250 Module(UNKNOWN+0000000000000000)
000000000818E230 Module(UNKNOWN+0000000000000000)
FFFFFFFFFFFFFFFE Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000001C52423 Module(sqlservr+0000000000C52423)
0000000000000001 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
00000005010A5F40 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
0000001900000409 Module(UNKNOWN+0000000000000000)
0000000000000001 Module(UNKNOWN+0000000000000000)
0000000000000000 Module(UNKNOWN+0000000000000000)
000000000818E340 Module(UNKNOWN+0000000000000000)
0000000080D262B0 Module(UNKNOWN+0000000000000000)
000006428029C31E Module(UNKNOWN+0000000000000000)
0000000000000004 Module(UNKNOWN+0000000000000000)
000006427F5B3B52 Module(mscorwks+0000000000283B52)
-----------------------
View 1 Replies
View Related
Aug 17, 2006
I have an SSIS package that runs fine through command pormpt although when I try to run it from a SQL Servr Agent Job CmdExec step it bombs out. Please help this has me stumped...the SSIS package uses an XML connection string so certain key settings such as connection strings and email info can be changed easily. Currently this is all on the same machine. I have not moved it beyond where I am developing.
On the command line I am using the following command...
dtexec /F "S:connectionscontacts.dtsConfig" /DE "password"
Below is the output log...
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 6:59:40 PM
Progress: 2006-08-16 18:59:41.29
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.29
Source: Data Flow Task
Validating: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.71
Source: Data Flow Task
Validating: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.73
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.77
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.77
Source: Data Flow Task
Validating: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.77
Source: Data Flow Task
Validating: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.77
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.79
Source: Data Flow Task
Prepare for Execute: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.79
Source: Data Flow Task
Prepare for Execute: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.79
Source: Data Flow Task
Prepare for Execute: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.79
Source: Data Flow Task
Prepare for Execute: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.81
Source: Data Flow Task
Pre-Execute: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.84
Source: Data Flow Task
Pre-Execute: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.90
Source: Data Flow Task
Pre-Execute: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.90
Source: Data Flow Task
Pre-Execute: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.92
Source: Data Flow Task
Post Execute: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.92
Source: Data Flow Task
Post Execute: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.92
Source: Data Flow Task
Post Execute: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.92
Source: Data Flow Task
Post Execute: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.92
Source: Data Flow Task
Cleanup: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.93
Source: Data Flow Task
Cleanup: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.93
Source: Data Flow Task
Cleanup: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.93
Source: Data Flow Task
Cleanup: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.95
Source: Send Mail Task
The SendMail task is initiated.: 0% complete
End Progress
Progress: 2006-08-16 18:59:42.09
Source: Send Mail Task
The SendMail task is completed.: 100% complete
End Progress
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 6:59:40 PM
Finished: 6:59:42 PM
Elapsed: 1.984 seconds
When I try to use the same command within SQL Server Agent Job using a CmdExec step I get the following error...
Description: The package is attempting to configure from the XML file "S:connectionscontacts.dtsConfig". End Info Warning: 2006-08-16 18:40:03.15 Code: 0x80012012 Source: contactsPackage Description: The configuration file name "S:connectionscontacts.dtsConfig" is not valid. Check the configuration file name. End Warning Warning: 2006-08-16 18:40:03.15 Code: 0x80012059 Source: contactsPackage Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed. End Warning Info: 2006-08-16 18:40:03.20 ... Process Exit Code 1. The step failed.
Thanks in advance for any help!!!
View 2 Replies
View Related
Jun 8, 2006
I have been trying to export an sql2000 database to sql2005 with no luck. I continuosly get the error
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I have looked upon all support material and have installed the latest sql2005 service pack, but this has not fixed the problem. a simple query as:
select * from [transaction] ta,transactionentry tr
where tr.transactionnumber=ta.transactionnumber and
glacctid=6 and ta.[time]> '3/01/2006'
would produce this fatal error.
the current version I am using is:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
This problem is happening on some of the most important tables in the database.
the error log contains the following:
2006-06-06 11:43:32.59 spid54 ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0001.txt
2006-06-06 11:43:32.59 spid54 SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2006-06-06 11:43:32.59 spid54 * *******************************************************************************
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 * BEGIN STACK DUMP:
2006-06-06 11:43:32.59 spid54 * 06/06/06 11:43:32 spid 54
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 * Exception Address = 0136B4F0 Module(sqlservr+0036B4F0)
2006-06-06 11:43:32.59 spid54 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2006-06-06 11:43:32.59 spid54 * Access Violation occurred writing address FFFFFFFC
2006-06-06 11:43:32.59 spid54 * Input Buffer 260 bytes -
2006-06-06 11:43:32.59 spid54 * select * from [transaction] tr,transactionentry te where tr.
2006-06-06 11:43:32.59 spid54 * transactionnumber = te.transactionnumber and glacctid = 6
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 *
2006-06-06 11:43:32.59 spid54 * MODULE BASE END SIZE
2006-06-06 11:43:32.59 spid54 * sqlservr 01000000 02BA7FFF 01ba8000
2006-06-06 11:43:32.59 spid54 * ntdll 7C800000 7C8BFFFF 000c0000
2006-06-06 11:43:32.59 spid54 * kernel32 77E40000 77F41FFF 00102000
2006-06-06 11:43:32.59 spid54 * MSVCR80 78130000 781CAFFF 0009b000
2006-06-06 11:43:32.59 spid54 * msvcrt 77BA0000 77BF9FFF 0005a000
I have followed instructions on some support issues posted but none have helped. If anyone has any solution to this problem PLEASE HELP!!!!.
Thanks.
View 7 Replies
View Related
Jan 27, 2006
Have the 2005 Enterprise Evaluation version. Trying to import data from a flat file to DB table. Tried running wizard from designer studio and from creating a data flow in SBIDS
Either way I am able to setup and start excution and then bombs with a fatal error.
"SQL Server Import and Export Wizard has encountered a problem and needs to close. We are sorry for the inconvenience."
Asks to Debug or close.. Tried installing on 2 other machines and having same issue. Tried several different data files and tables same issue.
Does anyone know if this is a bug? Am I missing something with permissions?
Thanks
Bill Bialas
View 1 Replies
View Related
Jan 5, 2006
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
View 12 Replies
View Related
Dec 27, 2007
Here's a really annoying problem. Let's say you have a text file with 2 million rows.Delimiters all look good and rows are previewed well but the file has a missing row at say lin 1234567 - way deep in the file. When SSIS encounters the blank row, an error is raised and processing on the file STOPS! I verified this in by checking the SSIS log and have even developed an error routine to notify me via email when the error occurs (really cool if I do say so myself ). The main problem still remains - how to resume processing from the point of failure in the file? Any help is appreciated. Thanks.
View 13 Replies
View Related
Sep 19, 2006
Hi. I am writing a program in C# to migrate data from a Foxpro database to an SQL Server 2005 Express database. The package is being created programmatically. I am creating a separate data flow for each Foxpro table. It seems to be doing it ok but I am getting the following error message at the package validation stage:
Description: An OLE DB Error has occured. Error code: 0x80040E0C.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object".
.........
Description: "component "OLE DB Destination" (22)" failed validation and returned validation status "VS_ISBROKEN".
This is the first time I am writing such code and I there must be something I am not doing correct but can't seem to figure it out. Any help will be highly appreciated. My code is as below:
private bool BuildPackage()
{
// Create the package object
oPackage = new Package();
// Create connections for the Foxpro and SQL Server data
Connections oPkgConns = oPackage.Connections;
// Foxpro Connection
ConnectionManager oFoxConn = oPkgConns.Add("OLEDB");
oFoxConn.ConnectionString = sSourceConnString; // Created elsewhere
oFoxConn.Name = "SourceConnectionOLEDB";
oFoxConn.Description = "OLEDB Connection For Foxpro Database";
// SQL Server Connection
ConnectionManager oSQLConn = oPkgConns.Add("OLEDB");
oSQLConn.ConnectionString = sTargetConnString; // Created elsewhere
oSQLConn.Name = "DestinationConnectionOLEDB";
oSQLConn.Description = "OLEDB Connection For SQL Server Database";
// Add Prepare SQL Task
Executable exSQLTask = oPackage.Executables.Add("STOCK:SQLTask");
TaskHost thSQLTask = exSQLTask as TaskHost;
thSQLTask.Properties["Connection"].SetValue(thSQLTask, "oSQLConn");
thSQLTask.Properties["DelayValidation"].SetValue(thSQLTask, true);
thSQLTask.Properties["ResultSetType"].SetValue(thSQLTask, ResultSetType.ResultSetType_None);
thSQLTask.Properties["SqlStatementSource"].SetValue(thSQLTask, @"C:LPFMigrateLPF_Script.sql");
thSQLTask.Properties["SqlStatementSourceType"].SetValue(thSQLTask, SqlStatementSourceType.FileConnection);
thSQLTask.FailPackageOnFailure = true;
// Add Data Flow Tasks. Create a separate task for each table.
// Get a list of tables from the source folder
arFiles = Directory.GetFileSystemEntries(sLPFDataFolder, "*.DBF");
for (iCount = 0; iCount <= arFiles.GetUpperBound(0); iCount++)
{
// Get the name of the file from the array
sDataFile = Path.GetFileName(arFiles[iCount].ToString());
sDataFile = sDataFile.Substring(0, sDataFile.Length - 4);
oDataFlow = ((TaskHost)oPackage.Executables.Add("DTS.Pipeline.1")).InnerObject as MainPipe;
oDataFlow.AutoGenerateIDForNewObjects = true;
// Create the source component
IDTSComponentMetaData90 oSource = oDataFlow.ComponentMetaDataCollection.New();
oSource.Name = (sDataFile + "Src");
oSource.ComponentClassID = "DTSAdapter.OLEDBSource.1";
// Get the design time instance of the component and initialize the component
CManagedComponentWrapper srcDesignTime = oSource.Instantiate();
srcDesignTime.ProvideComponentProperties();
// Add the connection manager
if (oSource.RuntimeConnectionCollection.Count > 0)
{
oSource.RuntimeConnectionCollection[0].ConnectionManagerID = oFoxConn.ID;
oSource.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(oFoxConn);
}
// Set Custom Properties
srcDesignTime.SetComponentProperty("AccessMode", 0);
srcDesignTime.SetComponentProperty("AlwaysUseDefaultCodePage", true);
srcDesignTime.SetComponentProperty("OpenRowset", sDataFile);
// Re-initialize metadata
srcDesignTime.AcquireConnections(null);
srcDesignTime.ReinitializeMetaData();
srcDesignTime.ReleaseConnections();
// Create Destination component
IDTSComponentMetaData90 oDestination = oDataFlow.ComponentMetaDataCollection.New();
oDestination.Name = (sDataFile + "Dest");
oDestination.ComponentClassID = "DTSAdapter.OLEDBDestination.1";
// Get the design time instance of the component and initialize the component
CManagedComponentWrapper destDesignTime = oDestination.Instantiate();
destDesignTime.ProvideComponentProperties();
// Add the connection manager
if (oDestination.RuntimeConnectionCollection.Count > 0)
{
oDestination.RuntimeConnectionCollection[0].ConnectionManagerID = oSQLConn.ID;
oDestination.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(oSQLConn);
}
// Set custom properties
destDesignTime.SetComponentProperty("AccessMode", 2);
destDesignTime.SetComponentProperty("AlwaysUseDefaultCodePage", false);
destDesignTime.SetComponentProperty("OpenRowset", "[dbo].[" + sDataFile + "]");
// Create the path to link the source and destination components of the dataflow
IDTSPath90 dfPath = oDataFlow.PathCollection.New();
dfPath.AttachPathAndPropagateNotifications(oSource.OutputCollection[0], oDestination.InputCollection[0]);
// Iterate through the inputs of the component.
foreach (IDTSInput90 input in oDestination.InputCollection)
{
// Get the virtual input column collection
IDTSVirtualInput90 vInput = input.GetVirtualInput();
// Iterate through the column collection
foreach (IDTSVirtualInputColumn90 vColumn in vInput.VirtualInputColumnCollection)
{
// Call the SetUsageType method of the design time instance of the component.
destDesignTime.SetUsageType(input.ID, vInput, vColumn.LineageID, DTSUsageType.UT_READWRITE);
}
//Map external metadata to the inputcolumn
foreach (IDTSInputColumn90 inputColumn in input.InputColumnCollection)
{
IDTSExternalMetadataColumn90 externalColumn = input.ExternalMetadataColumnCollection.New();
externalColumn.Name = inputColumn.Name;
externalColumn.Precision = inputColumn.Precision;
externalColumn.Length = inputColumn.Length;
externalColumn.DataType = inputColumn.DataType;
externalColumn.Scale = inputColumn.Scale;
// Map the external column to the input column.
inputColumn.ExternalMetadataColumnID = externalColumn.ID;
}
}
}
// Add precedence constraints to the package executables
PrecedenceConstraint pcTasks = oPackage.PrecedenceConstraints.Add((Executable)thSQLTask, oPackage.Executables[0]);
pcTasks.Value = DTSExecResult.Success;
for (iCount = 1; iCount <= (oPackage.Executables.Count - 1); iCount++)
{
pcTasks = oPackage.PrecedenceConstraints.Add(oPackage.Executables[iCount - 1], oPackage.Executables[iCount]);
pcTasks.Value = DTSExecResult.Success;
}
// Validate the package
DTSExecResult eResult = oPackage.Validate(oPkgConns, null, null, null);
// Check if the package was successfully executed
if (eResult.Equals(DTSExecResult.Canceled) || eResult.Equals(DTSExecResult.Failure))
{
string sErrorMessage = "";
foreach (DtsError pkgError in oPackage.Errors)
{
sErrorMessage = sErrorMessage + "Description: " + pkgError.Description + "";
sErrorMessage = sErrorMessage + "HelpContext: " + pkgError.HelpContext + "";
sErrorMessage = sErrorMessage + "HelpFile: " + pkgError.HelpFile + "";
sErrorMessage = sErrorMessage + "IDOfInterfaceWithError: " + pkgError.IDOfInterfaceWithError + "";
sErrorMessage = sErrorMessage + "Source: " + pkgError.Source + "";
sErrorMessage = sErrorMessage + "Subcomponent: " + pkgError.SubComponent + "";
sErrorMessage = sErrorMessage + "Timestamp: " + pkgError.TimeStamp + "";
sErrorMessage = sErrorMessage + "ErrorCode: " + pkgError.ErrorCode;
}
MessageBox.Show("The DTS package was not built successfully because of the following error(s):" + sErrorMessage, "Package Builder", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
// return a successful result
return true;
}
View 2 Replies
View Related
Aug 21, 2007
I have 2 variables, one is the column name of the table and the otherone is the table name and I need to write this in the "Execute SQLtask" of a "For each loop" container in a ssis package like this:Truncate table <tableName>Insert into <tableName>Exec (' select [' + ?+ '] from '+ ?)It gives me error message when I try run the ssis. However if I putthe above statements into a stored procedure and wrote look this, itworks:spStroedproc ?, ?Do I need to change any of my settings for my "Exec" to work?Thank you in advance
View 9 Replies
View Related
Feb 1, 2007
I built a system where I am sending batches of messages using a single conversation. I want to pull these messages out of my queue using Service Broker. I may have more than one batch sitting in the queue waiting to be picked up, so....
In my SSIS package i started by getting a unique list of conversation_handles where the message type is my end of batch message ( should only be one per batch). Then I used the foreach loop construct thinking I could pass the conversation_handles around and into the data flow.
In the data flow I want to pull all of the messages at once. It looks like the receive statement is designed to do this with the concept of using a table variable.
So I built this SQL to use in for the SQL Command of my OLE DB Source. It gives me this error "Syntax error, permission violation, or other nonspecific errorr"
declare @messages table ( conversation_handle uniqueidentifier, message_type_name sysname, message_body xml );
receive conversation_handle, message_type_name, message_body
from dm.[consultant queue]
into @messages
where conversation_handle = ?
select conversation_handle, message_type_name, message_body
from @messages
If I change it to this, by removing the passed parameter and looking up what should be the same value that I am passing in then it works.
declare @ch uniqueidentifier;
declare @messages table ( conversation_handle uniqueidentifier, message_type_name sysname, message_body xml );
select top 1 @ch = conversation_handle
from dm.[consultant queue]
where message_type_name = 'BatchEnd'
order by queuing_order;
-- select conversation_handle, message_type_name, message_body
receive conversation_handle, message_type_name, message_body
from dm.[consultant queue]
into @messages
where conversation_handle = @ch
select conversation_handle, message_type_name, message_body
from @messages
I have tried sneaking the parameter into the SQL in other ways, but always get the same I have tried sneaking the parameter into the SQL in other ways, but always get the same error message. It just seems that SSIS, or OLE DB, don't want to pass parameters into a block of SQL that is executing this receive command. Has anyone else done something similar to what I am doing here? Any ideas on how to resolve this?
Obviously by using SSIS I want to work on the whole batch at once and not iterate message by message. Right now I just don't like the idea that I am getting the conversation_handle twice and possibly getting a different batch of messages to process.
Thanks!
View 7 Replies
View Related
Apr 23, 2007
Is it possible to run a windows command on SSIS, like a dos command?
Thanks,
Phil
View 3 Replies
View Related
Mar 27, 2007
I AM working on DW building and i m using SSIS.I haev problem with data transformation OLEDB command.I have written a query to clean data in OLEDB command box ,but it takes whole lot of time because at a time it slects 6000 rows from the source and put in to destination but i have 300000 rows to process.How can i increase the size.
View 4 Replies
View Related
Jun 30, 2006
Dear All:
When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.
Is there a way to configure the solution to run witn WM5 emulator.
The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.
------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------
Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'
Compiling...
Employees.cpp
northwindoledb.cpp
stdafx.cpp
Generating Code...
Compiling resources...
Linking...
coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'
Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"
northwindoledb - 1 error(s), 0 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
View 1 Replies
View Related
Sep 13, 2007
Dear member,
Does any body know how to run SSIS package through the command line?
Thanks
Shamen
View 3 Replies
View Related
Oct 10, 2007
I created a Stored Proc to compute all the data I need to export to a CSV file.
I use the provider MS OLE DB Provider for SQL Server.
It's a very simple package with a single Data Flow Task.
This flow task is using an OLE DB Source to call a simple SQL Command : Exec MyStoredProc.
There are no params.
This Stored Proc is using table variables to compute the data.
It takes about 10 seconds to return anything.
The problem is that the mapping doesn't work with the OLE DB Source.
There are no fields at all shown in the mapping screen.
I tried to replace the Stored Proc by a version which only returns fields and no data.
Then the mapping would work just fine.
The package is then compiling and working fine.
But everytime I put back the real stored proc, even without changing the SQL Command, the SSIS execution breaks at execution.
It keeps saying :
"Error: 0xC0202005 at Data Flow Task, OLE DB Source [477]: Column "RecordType" cannot be found at the datasource."
My guess is that SSIS doesn't wait the 10 secs and thinks the Stored Proc is not returning anything.
What can I do to make this work ?
Thanks,
Vincent
View 3 Replies
View Related
