Access Violation On Saving A DTS Package
Jul 23, 2005
Hi MS Newsgroup
I am using SQL 2000 SP3 + latest hot fixes and I am editing a DTS
package. When I save the package I get a SQL Server Access Violation
and cannot save the package. This does not crash SQL nor Enterprise
Manager but no matter what I do I cannot save the package. This occurs
for only 1 package on the server (others are ok) and for all users of
any privilaged access level. I have tried to save to file, VB, etc but
all fail similarly.
I have read MS KB and have tried all options they suggest but to no
avail! I'd like not to have to rewrite the DTS again from scratch.
Ideas anyone?
Thanks
View 1 Replies
ADVERTISEMENT
Aug 22, 2001
How execption access violation error msg with severity 19 handled in sql7 ?
Thanks for info.
View 1 Replies
View Related
Oct 15, 2003
System Spec: OS = Windows 2000, SQL Server 7 SP4.
I'm getting the following error when I run a stored procedure which truncates a table then inserts data into it. There are no complex joins, order, group by or union clauses in the insert statement:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 17 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I've read that this is fixed in SQL 7 SP2 but we're on SP4?? I have re-installed SQL SP4.
View 1 Replies
View Related
Sep 22, 2000
Hi,
I received this event in my eventlog
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
What could be the cause of this??
Thanks in advance
Mikael
View 3 Replies
View Related
Jun 18, 2007
I have a task i.e. to make the following query work.
But it shows me syntax error. I dont know what this query is doing and I have no concerns about it. so if any body could help me out that will be a big help :)
SHAPE {
SELECT * FROM Leads
WHERE 1=1
AND ( ([Lead Quality] NOT IN (1,5,6,7) )
AND ( idVendors = '{ADF4406A-ACB7-4610-A03F-702D86CC259F}' )
AND ( idLeads IN (select idleads from [vendors history] where status = 3) )
AND ( [received datetime] between '6/18/2007' AND '6/19/2007' )
AND ( [Lead Type] NOT IN (7,8) )
)
ORDER BY idVendors, [Customer ID]
}
AS [Leads Detail]
APPEND
( { SELECT * FROM [Leads Borrower Information] WHERE [CoBorrower Indicator] = 0 } As [Borrower Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Borrower Information] WHERE [CoBorrower Indicator] = 1 } AS [CoBorrower Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Property Information] WHERE [Mailing Address Indicator] = 0 } As [Property Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Property Information] WHERE [Mailing Address Indicator] = 1 } AS [Mailing Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Mortgage Information] WHERE [Mortgage Indicator] IN (0,1) } AS [First Mortgage Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Mortgage Information] WHERE [Mortgage Indicator] = 2 } AS [Second Mortgage Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Vendors] } As [Vendor Information] RELATE 'idVendors' to 'idVendors'),
( { SELECT * FROM [Lead Quality Reason Values] } As [Return Reason] RELATE 'Lead Quality Reason' to 'Value'),
( { SELECT [Batch ID], idLeads, idVendorsOrders FROM [Vendors History] WHERE STATUS IN (1,2) } As [Vendor History] RELATE 'idLeads' to 'idLeads'),
( { SELECT TOP 1 idLeads, DateTime from [Clients History] WHERE Status IN (3) ORDER BY DateTime ASC } As [Clients History] RELATE 'idLeads' to 'idLeads')
View 3 Replies
View Related
Dec 6, 2005
Hi,
I have suddenly developed a problem when trying to select from a table. Even a standard select * from generates a SQL Dump exception handler. The table is below:
CREATE TABLE [Stagetb_GIDeptGroup] (
[f_GIImportID] [int] IDENTITY (1, 1) NOT NULL ,
[f_GIAction] [int] NOT NULL CONSTRAINT [DF_stagetb_GIDeptGroup_f_GIAction] DEFAULT (0),
[f_ImportBatchID] [int] NULL ,
[f_VisualDeptGroupID] [int] NULL ,
[f_DeptGroupName] [varchar] (40) COLLATE Latin1_General_CI_AS NULL ,
[f_DeptGroupTarget] [d_Percentage] NULL ,
[f_ExternalDeptGroupID] [int] NULL ,
[f_StatusID] [int] NOT NULL CONSTRAINT [DF_stagetb_GIDeptGroup_f_StatusID] DEFAULT (0),
[f_StatusDetailID] [int] NOT NULL CONSTRAINT [DF_stagetb_GIDeptGroup_f_StatusDetailID] DEFAULT (0),
CONSTRAINT [PK_stagetb_GIDeptGroup] PRIMARY KEY CLUSTERED
(
[f_GIImportID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
When i run a dbcc checkdb it finds nothing, if i try and connect from a remote connection i get a general network error and when connecting from the local machine i get this Dump exception error:
2005-12-06 08:40:55.28 spid53 Error: 0, Severity: 19, State: 0
2005-12-06 08:40:55.28 spid53 language_exec: Process 53 generated an access violation. SQL Server is terminating this process..
2005-12-06 08:40:57.76 spid53 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQL00010.dmp
2005-12-06 08:40:57.76 spid53 Error: 0, Severity: 19, State: 0
2005-12-06 08:40:57.76 spid53 SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 12/06/05 08:40:57 spid 53
*
* Exception Address = 00425E61
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 70 bytes -
* select * from stagetb_GIDeptGroup
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 77F50000 77FF6FFF 000a7000
* kernel32 77E60000 77F45FFF 000e6000
* ADVAPI32 77DD0000 77E5CFFF 0008d000
* RPCRT4 78000000 78085FFF 00086000
* USER32 77D40000 77DC5FFF 00086000
* GDI32 7E090000 7E0D0FFF 00041000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 77C10000 77C62FFF 00053000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 002A0000 002AFFFF 00010000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 71C20000 71C6DFFF 0004e000
* wmi 76D30000 76D33FFF 00004000
* SSNETLIB 42CF0000 42D05FFF 00016000
* WSOCK32 71AD0000 71AD7FFF 00008000
* WS2_32 71AB0000 71AC4FFF 00015000
* WS2HELP 71AA0000 71AA7FFF 00008000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 71F80000 71F83FFF 00004000
* SECUR32 76F90000 76F9FFFF 00010000
* crypt32 762C0000 76347FFF 00088000
* MSASN1 762A0000 762AFFFF 00010000
* VERSION 77C00000 77C06FFF 00007000
* userenv 75A70000 75B14FFF 000a5000
* mswsock 71A50000 71A8AFFF 0003b000
* DNSAPI 76F20000 76F44FFF 00025000
* winrnr 76FB0000 76FB6FFF 00007000
* WLDAP32 76F60000 76F8BFFF 0002c000
* rasadhlp 76FC0000 76FC4FFF 00005000
* wshtcpip 71A90000 71A97FFF 00008000
* SSmsLPCn 42CD0000 42CD6FFF 00007000
* ntdsapi 767A0000 767B2FFF 00013000
* msv1_0 76D10000 76D2CFFF 0001d000
* OLE32 771B0000 772D0FFF 00121000
* CLBCATQ 76FD0000 77047FFF 00078000
* OLEAUT32 77120000 771AAFFF 0008b000
* COMRes 77050000 77114FFF 000c5000
* sqloledb 01D80000 01DF2FFF 00073000
* MSDART 74C50000 74C6EFFF 0001f000
* COMCTL32 77340000 773CAFFF 0008b000
* comdlg32 763B0000 763F4FFF 00045000
* SHLWAPI 70A70000 70AD4FFF 00065000
* SHELL32 773D0000 77BC1FFF 007f2000
* MSDATL3 60E30000 60E44FFF 00015000
* comctl32 71950000 71A33FFF 000e4000
* oledb32 02020000 02084FFF 00065000
* OLEDB32R 01E00000 01E0FFFF 00010000
* xpsqlbot 42F00000 42F05FFF 00006000
* xpstar 410F0000 41133FFF 00044000
* SQLUNIRL 5C1B0000 5C1DCFFF 0002d000
* WINSPOOL 73000000 73022FFF 00023000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 42C40000 42C56FFF 00017000
* ODBC32 02150000 02181FFF 00032000
* odbcbcp 02190000 02195FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* NDDEAPI 75940000 75946FFF 00007000
* odbcint 022B0000 022C5FFF 00016000
* clusapi 55560000 55570FFF 00011000
* resutils 750B0000 750C0FFF 00011000
* SQLSVC 43970000 43975FFF 00006000
* xpstar 439E0000 439EBFFF 0000c000
* DBGHELP 02420000 02432FFF 00013000
* msdbi 6BE90000 6BEABFFF 0001c000
* sqlimage 4A400000 4A40CFFF 0000d000
*
* Edi: 1ADA13F4: 00000000 1ADA1758 00000000 1ADA1400 00000001 00000000
* Esi: 00000000:
* Eax: 1ADA13E0: 009802E4 00000032 00000000 00000000 00000000 00000000
* Ebx: 1ADA13E0: 009802E4 00000032 00000000 00000000 00000000 00000000
* Ecx: 00000000:
* Edx: 1ADA1410: 00000000 6E006100 00000000 00000000 00000000 1ADA0030
* Eip: 00425E61: 7589018B 8B10FFFC F44D8BF0 A5A5A5A5 5EC38B5F 0D89645B
* Ebp: 0213DFE8: 0213E01C 004C4EB7 1ADA0020 00000000 1ADA1168 1ADC84D0
* SegCs: 0000001B:
* EFlags: 00010282: 0050004F 00300048 00300033 00560030 004F0042 004E0000
* Esp: 0213DFCC: 1ADA07F0 1ADA0020 00A0A4A0 1ADA13E0 0213E010 0092D7B0
* SegSs: 00000023:
************************************************** *****************************
-------------------------------------------------------------------------------
Short Stack Dump
00425E61 Module(sqlservr+00025E61)
004C4EB7 Module(sqlservr+000C4EB7)
0049DCD9 Module(sqlservr+0009DCD9)
0049DAF9 Module(sqlservr+0009DAF9)
00447078 Module(sqlservr+00047078)
004510FE Module(sqlservr+000510FE)
00415080 Module(sqlservr+00015080)
004592CE Module(sqlservr+000592CE)
005A7208 Module(sqlservr+001A7208) (SQLExit(unsigned long)+000523F6)
005A7099 Module(sqlservr+001A7099) (SQLExit(unsigned long)+00052287)
00446A83 Module(sqlservr+00046A83)
004510FE Module(sqlservr+000510FE)
00415080 Module(sqlservr+00015080)
004592CE Module(sqlservr+000592CE)
0041534F Module(sqlservr+0001534F)
00459A54 Module(sqlservr+00059A54)
004175D8 Module(sqlservr+000175D8)
410735D0 Module(UMS+000035D0) (UmsSystemUserContext::UmsSystemUserContext(class UmsScheduler *,struct UMS_SYSPARAMS *)+00000434)
4107382C Module(UMS+0000382C) (UmsScheduler::FiberEnabled(void)+000001D2)
77C37E53 Module(MSVCRT+00027E53) (_endthread+000000AA)
77E7D33B Module(kernel32+0001D33B) (RegisterWaitForInputIdle+00000043)
I am running Windows XP Professional & MSDE Service Pack 3. Any ideas anyone?
View 1 Replies
View Related
Dec 19, 2005
Hi all,Since yesterday I'm unable to lauch the enterprise manager, it givesthe following error :Unhandled exception at 0x0101f07e in mmc.exe: 0xC0000005: Accessviolation reading location 0x00000064.The weird thing is that except installing the office xp PIA's I can'timage what else could be changed on my system.I tried reinstalling, but still the same error.I tried SP3a, still nothing changed.Searched in some groups and it seems that not much can be found aboutit, so my inspiration is running dry.Anyone had this problem ? Anyone any suggestions how to solve it ?Regards,Koen
View 2 Replies
View Related
Sep 22, 2005
Hello,I have some code that uses ODBC to retreive column informationfrom a SQL Server database. The call to ::SQLColumns succeeds.I then bind my C variables to the HSTMT handle. I then call::SQLFetch to get the next row. ::SQLFetch crashes with anaccess violation. I am unable to debugThe same code works without issue against a MySQL database.Has anyone ever encountered this crash?Is there a work-around anyone knows of?Thank you very much for your help.
View 1 Replies
View Related
Apr 7, 2006
I recently set up transactional replication from one server database to another server database. I keep getting a Log Reader Agent error: An access violation occurred.
The SQL Server agent starts under one Windows account but the Server is registered under the system account. The log reader agent is using the system account.
I'm not sure what else to check or what database permissions or roles should be set. Can somebody help? Thanks.
View 5 Replies
View Related
Feb 15, 2007
After an error trying to connect to a database, I am trying to query the number of status records using SQLGetDiagField() and am getting an access violation? I am trying to open a connection to data in an Excel file using the Excel ODBC driver. Any hints?
View 1 Replies
View Related
Oct 30, 2006
There must be a difference, but I don't know what it is.
Can someone please explain the advantages and disadvantages of each method?
Thanks in advance.
View 17 Replies
View Related
Oct 26, 2000
Hi, Folks!
I'm receiving Access Violation Error when I'm trying to create a clustered index on a datetime field on a table that have around 4 million records, if I create the index nonclustered, no problem, but clustered the system raise this error!
Any help will be appreciate a lot!
Thanks in advance!
Armando Marrero
Cti. Miami
View 1 Replies
View Related
Jul 15, 2015
Our log reader process is throwing an access violation error every 10 minutes or so. It runs fine for a bit then fails. Below is, I think, the important info from a stack dump analysis. We are running SQL 2012 SP1 64 bit. I think we can either install SP2 or open a case with Microsoft.
0:000> kC 1000
Call Site
sqlmin!ReplArticleCmd::updated_column
sqlmin!ReplArticleCmd::AddSupdateParams
sqlmin!ReplArticleCmd::GenerateSUpdateProcedure
sqlmin!ResolveUpdateCommand
sqlmin!ReplTranInfo::ProcessInsert
[Code] ....
I can see that the sp_replcmds SP is running when this happens.
* BEGIN STACK DUMP:
* 07/15/15 12:37:39 spid 81
*
*
* Exception Address = 000007F988FCA480 Module(sqlmin+0000000000C4A480)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0000000000000000
[Code] ....
View 0 Replies
View Related
Jul 23, 2005
Aaaaaarrgghh ! (that's better)I am trying to convert a field within my Oracle 9i Database that is oftype BLOB (but this BLOB may contain a combination of clobs/varchars orimages such as gif images, jpg images) to Microsoft SQL Server 2000using Microsoft DTS.On trying to perform this simple conversion I recieved the error "Needto run the object to perform the operation - Exception AccessViolation" from Microsoft DTS and my table that contains this BLOBfield is not converted across.After further investigation I implemented the fixes suggested by theMicrosoft Knowledge Base and "sqldts.com" but still no joy the errorkept occuring.I discovered my modifying the step in the DTS package that handled thistable conversion that contained the BLOB column that when I changed thedata type on my SQL Server target table to VARBINARY and modified thequery so that only the BLOBs that contained clobs/varchars were broughtacross that the error went away.I then proceeded to create another DTS package step that had a querythat only brought across the BLOB column that contained images such asgif images/jpeg images etc. and the error went away and the target typefor the SQL Server target table was set to IMAGE.As the data for this BLOB contains a combination of VARCHARS/CLOBS(concatanted) and also GIF IMAGES/JPEGS in the same source column withOracle 9i I require the same in my target table within SQL server asone column (and I should be able to do that with type IMAGE especiallyas it can store larger objects than VARBINARY but any source BLOBS thatcontain VARCHAR/CLOBs don't seem to want to be loaded as IMAGE theywill only load in to VARBINARY).However judging by my experiences above this doesn't seem to bepossible ?Can anyone help me out with this ?I am on Microsoft SQL Server 2000 Service Pack 4 with latest MDAC(2.8.1).Cheers,Gary
View 1 Replies
View Related
Apr 25, 2003
Where i try to create stored procedure in sql server 2000 using query analyzer i'm getting an error
'[Microsoft][ODBC SQL Server Driver]Syntax error or access violation'
and the same stored procedure if i try after some time without any changes it gets created..
how is wrong?
View 2 Replies
View Related
Apr 17, 2008
Hi guys! I am using SQL 2005 and I wonder why I am encountering the error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation" everytime I am trying to create stored procedure with temp table and table variable.
See my code below with temp table.
Any thoughts will be appreciated!
CREATE PROCEDURE DBO.SAMPLESP
(@DETAILS AS VARCHAR(8000),
@ID AS VARCHAR(15))
AS
BEGIN TRANSACTION
CREATE TABLE DBO.#TEMPTABLE
{
ASSET VARCHAR(50)
}
DECLARE @INSTINSERT AS NVARCHAR(4000)
SET @INSTINSERT= 'INSERT INTO #TEMPTABLE(ASSET)'
SET @INSTINSERT= @INSTINSERT+ @DETAILS
EXEC sp_ExecuteSQL @INSTINSERT
INSERT INTO InstDetail
(TrackNum, ASSETID)
SELECT @ID, A.ASSE
FROM #TEMPTABLE A
DROP TABLE #TEMPTABLE
IF @@ERROR != 0
BEGIN
ROLLBACK TRANSACTION
RAISERROR('There was an error in here', 11, 1)
RETURN
END
ELSE
COMMIT TRANSACTION
View 5 Replies
View Related
Feb 19, 1999
dear friends/collegs:
for the past couple of weeks, we've been seeing:
SQL Server Error:
"kernel RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 generated access violation; SQL Server is terminating this process"
we're running SQL Server 6.5 sp4. on NT 4. sp3
View 2 Replies
View Related
Jun 24, 2007
Hi,
Background:
This could be a simple C++ issue as I am not that familiar with the language. I am trying to prototype a small program to test the performance of inserting data using the BCP interface. I want to BCP data that my program generates and passes via program variables.
I have narrowed the issue down to a sprintf call. Following are two variations of the code - one that works and one that does not. The error happens when I try to execute the bcp_sendrow() call.
What is the appropriate way to create / send string data to the BCP interface. Any good examples available? I have created the following from the BulkCopyFromVariables example on the Microsoft SQL Server downloads site.
Thanks in advance, Kerry
---- Works ----
Code Snippet
for(idx=1; idx<=5; idx++){
//sprintf(k1, "%d", idx); //does not work...
sprintf(k1, "oo"); //works....
if ( (SendRet = bcp_sendrow(hdbc1) ) != SUCCEED ) {
printf("bcp_sendrow(hdbc1) Failed");
Cleanup();
return(9);
}
}
--- Causes Access Violation ----
Code Snippet
for(idx=1; idx<=5; idx++){
sprintf(k1, "%d", idx); //does not work...
//sprintf(k1, "oo"); //works....
if ( (SendRet = bcp_sendrow(hdbc1) ) != SUCCEED ) {
printf("bcp_sendrow(hdbc1) Failed");
Cleanup();
return(9);
}
}
--- Additional information ---
---------------------------
Target Table Definition
---------------------------
Code SnippetCREATE TABLE PtTest(
[ID] [int] IDENTITY(1,1) NOT NULL,
[PtID] [int] NOT NULL,
[ParamID] [nchar](10) NULL DEFAULT ((200)), --Above example trying to insert data here via k1 variable...
[ParamValue] [nchar](10) NULL DEFAULT ((200)),
[InsDate] [datetime] NULL DEFAULT (getdate()),
)
----------------------------
-----------------
Bind statements
-----------------
Code Snippet
int idx;
char k1[5];
char *terminator = " ";
retcode = bcp_bind(hdbc1, (BYTE *)&idx, 0, sizeof(DBINT), NULL, 0, SQLINT4, 2);
if ( (retcode != SUCCEED) ) {
printf("bcp_bind(hdbc1) Failed");
Cleanup();
return(9);
}
retcode = bcp_bind(hdbc1, (BYTE *)&k1, 0, SQL_VARLEN_DATA, (UCHAR*)terminator, 1, SQLCHARACTER, 3);
if ( (retcode != SUCCEED) ) {
printf("bcp_bind(hdbc1) Failed");
Cleanup();
return(9);
}
Note: there are other bind statements...
-----------------
View 3 Replies
View Related
May 13, 2002
I'm getting errors from time to time saving DTS changes as local package. I'm using SQL 2000. I've got sysadmin role.
I know there were DTS package ownership bugs in SQL 7 - but I thought these had been cleaned up with the latest SP.
Any suggestions would be appreciated.
View 2 Replies
View Related
Apr 12, 2004
Hi,
When saving a DTS package, we get 4 options (listed below). Can someone please guide me which options should I used and what's the difference/advantage/disadvantage amongst these options:
[list=1] SQL Server
SQL Server Meta Data Services (this appears dimmed/disabled - i don't know why :confused:
Structured Storage File
Visual Basic File[/list=1]
Thanks.
View 5 Replies
View Related
Aug 15, 2007
My team is getting this message when altering a DTS Package, using SQL 2000 DTS Designer. We have downloaded all the SQL updates (Backward Compatibility, and the one specifically for DTS Save problems. Have tried this in SQL2005 as well. Have uninstalled both of these programs, and reinstalled on local machines. No avail. Here is what happens:
1) Editing an existing DTS Package, such as a Text Change, or simple connection change
2) Saving the file creates the exact message below:
Package Error
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION
3) Then you have to choose OK in the windows Popup Box.
4) The DTS is brought back to the original screen, or completely exited out of Designer.
5) From that point, the Package can no longer be opened for editing, unless you open a previous version (which means changes aren't saved.
We have also tried to SAVE AS another filename. This doesn't work either.
Our team has close to 75 DTS Packages, some simple, some more complex. We are corrupting these left and right. This problem happens no matter what is created in the DTS Package.
This is running into our business operations, and we are unable to find out a resolution...HELP
Any insight in this would be greatly appreciated.
Thanks,
Jason
View 2 Replies
View Related
Jun 13, 2006
Hello All,
I have a package in the SQL 2000 environment that works fine. I have migrated this DTS Package to a SSIS Package using the Visual Studio 2005.
After that, i made some changes in this package and now I'm trying to save it but I am facing with this error message below:
TITLE: Microsoft Visual Studio
------------------------------
Failure saving package.
------------------------------
ADDITIONAL INFORMATION:
Invalid at the top level of the document.
(Microsoft OLEDB Persistence Provider)
------------------------------
Invalid at the top level of the document.
(Microsoft OLEDB Persistence Provider)
------------------------------
BUTTONS:
OK
------------------------------
Could someone please help me with this ?
Thanks in advance.
Thiago
View 12 Replies
View Related
Apr 5, 2006
hi,
I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another.
The task works fine and the project is saved on my c: drive.
I was trying to save the project on the SQL server and don't know if i am doing somehting wrong?
I have the following selections made:
Package Location: SQL server
Server: ServerName
Authentication Type: Windows
Package path: /TransferTables
Protection Level: Encrypt sensitive data with user key
Now when i hit ok i get the "No description found" error with the following details:
No description found (Microsoft Visual Studio)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)
Does anyone have a solution to this?
Thanks for any help.
View 16 Replies
View Related
Nov 23, 2005
Hi all, I know that you can save a DTS package to SQL Server (localpackage under Data Transformation Services in the EM).I wonder can I limit which login has the right to save DTS package? Imean, I would like logins with sa right to have this right but not forother ordinary logins.Can this be done in SQL Server?
View 2 Replies
View Related
Mar 9, 2007
Hi
I am trying to load a ssis package into a folder (lets say SSIS packages) that I created in MSDB but its geeting saved in the root (MSDB) not into the SSIS packages folder...I am doing this thru C#...
View 3 Replies
View Related
Jan 29, 2007
Hi everyone,
Primary platform is Framework 2.0 and Sql25k 64-bit
When I try to save my DTSX package from my client to the production server I get this error:
"No Description found"
Either Windows or Sql authentication.
Does anyone have ever faced this drawback?
Thanks in advance,
View 1 Replies
View Related
Jul 11, 2001
I have several DTS packages saved 'locally' to the SQL server. I want to duplicate a package, so that I can make some changes then replace the original. I certainly don't want to rebuild the entire package from scratch. So, I open up the original package, go to the 'Package' menu and choose 'Save As', then give it a new name and press OK. No errors, all appears well, the title bar even shows the new name of the package. But, when I close the package and go the the 'local' package list, it (the new package name) doesn't appear in the list. Refresh, exit SEM, reboot - doesn't show up. I even looked in the MSDB table where packages are supposed to be stored (at least the name / package id / etc), and it doesn't show there as well. Tried from several client machines.
OS: Windows 2000 Server (advanced) SP2
SQL: SQL 2000 Server (no SP's)
Any help would be great.
Bryan Parke
View 2 Replies
View Related
May 14, 2007
Greetings,
I am using the IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider to import data via query (in a tranformation task) to a SQL2000 server within a DTS package.
Works great! However, the provider does not save my (iSeries) password although I choose this option. I really need the password to be saved so that I can schedule the DTS package... I don't want to have to login and run the package each time (even IT guys take vacations). Or at least I don't want to have to login everytime the server is restarted...
Has anyone run accross this and found a solution?
Many thanks in advance.
Billy
View 5 Replies
View Related
Jul 24, 2006
I am getting this when I try to save my package. Any Ideas?
Failed to apply package protection with error 0xC0014061 "The protection level, ServerStorage, cannot be used when saving to this destination. The system could not verify that the destination supports secure storage capability.". This error occurs when saving to Xml.
View 3 Replies
View Related
Oct 10, 2007
I am using SQL 2000 (SP4) and trying to save a DTS Package. When I do that it gives me an error:
Error Source : SQL OLE DB Provider
Error Description : Unspecified error
The package runs fine and I can change global variables, etc. But I just can't save it. Any help would be appreciated.
Thanks,
Amir
View 1 Replies
View Related
May 15, 2007
Greetings,
I am using the IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider to import data via query (in a tranformation task) to a SQL 2000 server within a DTS package.
Works great! However, the DTS package(?) does not save my (iSeries) password although I choose this option. I really need the password to be saved so that I can schedule the DTS package... I don't want to have to login and run the package each time (even IT guys take vacations). Or at least I don't want to have to login everytime the server is restarted...
Perhaps I am ignorant, but, I can not find any configuration setting within DTS that will allow me to save the password for the IBMDASQL OLE DB provider. Nor have I been able to find a suitable solution to this by using the keywords search string of "package configuration" within the MSDN forums.
As a workaround, I can use the an ODBC connection along with a DSN file to save the username and password. However, I do not want this information sitting out there in plain text. I would like to use the OLE DB provider and store the username and password on the SQL server as the properties dialog says that I should be able to. Or I can define a UDL (still text file).[Or I can use an ODBC connection set up as a system DSN - I want to use the OLE DB provider]
I've read about adding a connection string to .Net's machine.config file - but, I do not want to use the .NET OLE DB provider and, again, I do not wish to store username and password information in plain text.
Is this a bug in as much as how SQL Server 2000 uses the IBMDASQL OLE DB provider?
I've called and spoke to an IBM tech in regard to this and was informed that the dialog box and error regarding the password are not IBM generated, but rather MS generated.
I hope that there is a solution to my problem.
Has anyone run accross this and found a solution?
Many thanks in advance.
Billy
View 5 Replies
View Related
Jul 11, 2007
Hello All,
I'm new to SQL 2005. I am setting up some SSIS packages which will connect to an Oracle database and copy some tables from it. These packages will then be scheduled to run on a daily basis. Because they will run automatically, it is required that passwords be saved along with the connection string. However, even though the password is saved (and encrypted, I checked the .dtsx in notepad), when I run the package, the connection to Oracle fails. Only if I respecify the password does it run correctly. How can I correctly save this password so that I can schedule automatic execution? Thanks for any info.
View 5 Replies
View Related
Apr 27, 2004
I am running SQL Server 2000 SP3 and I am trying to save a DTS package into Meta Data Services and I am receiving the following "Package Error"
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: General Error -2147217355 (80041035).
I have searched for this error and I cannot find anything related to it. Also, I saw some of the comments about right clicking "Data Transformation Services" and checking the box for allow save to Meta Data Services, however, I do not see that checkbox to allow for this. Has anyone else had this problem and resolved it? I'm beginning to get very frustrated with it.
View 1 Replies
View Related
