Saving DTS Package To Sql Server
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
ADVERTISEMENT
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
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
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
Jul 23, 2005
Hi MS NewsgroupI am using SQL 2000 SP3 + latest hot fixes and I am editing a DTSpackage. When I save the package I get a SQL Server Access Violationand cannot save the package. This does not crash SQL nor EnterpriseManager but no matter what I do I cannot save the package. This occursfor only 1 package on the server (others are ok) and for all users ofany privilaged access level. I have tried to save to file, VB, etc butall fail similarly.I have read MS KB and have tried all options they suggest but to noavail! I'd like not to have to rewrite the DTS again from scratch.Ideas anyone?Thanks
View 1 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
Dec 13, 2007
Hi Guys,
I am trying to automate a basic task using SQL Server 2005 Express.
Currently I have a query script that I run and then save the results as a CSV file. I need to do this on a daily basis and so I am looking to find out how best to go about this. There are a multitude of third party tools that claim to be able to do this - can anyone recommend this or enlighten me of the best way to set up this automation.
All ideas gratefully received!
View 1 Replies
View Related
Jan 2, 2008
How can I save UTF-8 strings in SQL Server 2005? I don't want to use nvarchar as it would take a lot of space and most of my text will be in latin characters (and it doesn't fully support all unicode code points anyway as it uses UCS2, I'm talking about the supplementary plane here which I know is very rarely used and most unicode fonts don't support it but it's still possible to be used at least in the future). I read in this KB article (http://support.microsoft.com/kb/232580) that my only option is to use varbinary, I'm worried though whether this could affect performance as I never used varbinary before .. I read in the same article that I cannot use varchar to store UTF-8 which I can't really understand, doesn't varchar use the whole 256 values to save character data according to the code page used? what makes UTF-8 characters not valid for being stored as varchar strings? (what I mean here is that I can do the conversion manually from varchar to UTF-8 but I only want to save the data in the varchar columns) Any suggestions are highly appreciated..
View 8 Replies
View Related
Jun 27, 2004
Hello there,
I was thinking about saving some files in a SQL Server DB and then reading those back to the client for download. Any warnings that I should know about before doing so? The files will generally be at most 2mb in probably .pdf format. I've heard bad things about doing this in Access...but then again, SQL Server isn't access.
View 3 Replies
View Related
Mar 2, 2007
Hi,
I have 2 operating System win NT server, window 2000 server
In Win NT Server
Sql server 7 with sql service pack 2
In Win 2000 Server
Sql server 7 with sql service pack 3
As the Day light saving time is changeing. Please let me know do i need to apply any Time Zone patching in sql server.
Thanks in Advace
Adil
View 3 Replies
View Related
Jun 4, 2007
Hi
I have only read ( select access) in a sql server database(2000). I am able to scripts the database.
Can any ony have any idea how to extract the data from database?
not the backup of db, i don't have the access.
No DTS to extract data into text file.
some thing like save the table with data?
I have more than 300 tables.
Thanks
sandipan
View 1 Replies
View Related
Sep 25, 2006
I have created and run a query in Management Studio Express. How do I save it so that I can run it again later?
In fact, does MSE have this capability?
Many thnaks
View 7 Replies
View Related
Nov 6, 2007
Hi,
I have a problem. The thing is that when I enter the values in a text boxes like evendate.text = "02/11/07" and desc.text="hello how r u" then I click on Save Button and its save in the SQL DATABASE but after this if I click on Refresh Button every time from the internet Explorer its automatically again save the data in the database although I have empty the textboxes.
The code is below:
<script runat="server"> sub SaveEvent(sender as object, e as EventArgs) dim con as new SQLConnection("server=london-home; Database=tony; uid=rashid2; pwd=test; ")
dim cmd as new SQLCommand("insert into events values('" & desc.text & "','" & DateTime.Parse(eventdate.text) & "')",con) con.open() cmd.executenonquery() con.close() clearform() display() end sub sub display() dim con as new SQLConnection("server=london-home; Database=tony; uid=rashid2; pwd=test; ") dim cmd as new SQLCommand("select * from events",con) con.open() dim SDR as SQLDataReader SDR = cmd.ExecuteReader() if SDR.HasRows = true then ViewEvents.DataSource = SDR ViewEvents.DataBind() end if con.close() end sub sub clearform() eventdate.text="" desc.text="" end sub sub Reset(sender as object, e as EventArgs) clearform() end sub</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title>
<style type="text/css">
#display_prod{float:left;}
#prod{margin-top:0;}
</style>
</head><body>
<table border="1" align="center" cellpadding="5" cellspacing="0"><tr><td valign="top">
<form id="prod" runat="server" enctype="multipart/form-data"><table id="display_prod" width="554" border="1" cellspacing="0" cellpadding="0" align="left" height="400"> <tr valign="top" height="20"> <td> </td> <td> <table border="1" align="center" cellpadding="10" cellspacing="0"> <tr> <td>PRODUCTS DESCRIPTION <asp:Label runat="server" ID="lbl"></asp:Label></td> </tr> </table> </td> </tr> <tr valign="top"> <td> <table align="left" id="menu" width="150" border="1" cellpadding="0" cellspacing="0"> <tr align="center"> <td><a href="home.aspx">Main</a></td> </tr> <tr align="center"> <td><a href="Events.aspx">Change Password</a></td> </tr> <tr align="center"> <td><a href="events.aspx">Events</a></td> </tr> </table> </td> <td align="left"> <table width="390" border="1" cellpadding="0" cellspacing="0"> <tr> <td width="100" >Enter Date :</td> <td width="243" ><asp:TextBox runat="server" ID="eventdate" BackColor="#FFFFFF" Width="100"></asp:TextBox> mm/dd/yy</td> </tr> <tr> <td>Description :</td> <td><asp:TextBox runat="server" ID="desc" TextMode="MultiLine" Columns="20" Rows="3" BackColor="#FFFFFF" MaxLength="200"></asp:TextBox> max 200</td> </tr> <tr> <td> </td> <td> <asp:Button runat="server" ID="btnsubmit" Text="Save" OnClick="SaveEvent"></asp:Button> <asp:Button runat="server" ID="btnreset" Text="Reset"></asp:Button> </td> </tr> </table> <table width="390" border="1" align="left" cellpadding="0" cellspacing="0"> <tr> <td> <asp:DataGrid runat="server" ID="ViewEvents" AutoGenerateColumns="false"> <columns> <asp:TemplateColumn> <itemtemplate> <table id="tt" border="1" cellpadding="5" cellspacing="0"> <tr> <td><asp:Label runat="server" ID="eventname" Text='<%#container.DataItem("event_name")%>' ></asp:Label></td> <td><asp:Label runat="server" ID="pdesc" Text='<%# trim(DataBinder.Eval(Container.DataItem,"event_date","{0:MM/dd/yyyy}")) %>' ></asp:Label></td> </tr> </table> </itemtemplate> </asp:TemplateColumn> </columns> </asp:DataGrid> </td> </tr></table> </td> </tr> </table>
</form>
</td></tr></table></body></html>
View 2 Replies
View Related
May 21, 2008
I have 3 dropdownlist server controls on my webform for the dateofbirth field. One for the day("1", "2" format), one for the month ("Jan", "Feb" format) and one for the year("1994", "1995" format). When the submit button server control is clicked i need to concatenate the day, month and year in the format 01-jan-1994 since i have the dateofbirth field datatype as datetime in my sql server table. I have declared the date variable stored procedure as "@dateofbirth datetime". Provide me the full coding.
Thanx in advance
View 1 Replies
View Related
Sep 24, 2003
I am trying to store about millions of pictures in Web server with lots of traffic. some poeple told me. SQL server cannot handle it and may freeze quickly. can anybody tell me which way is better and more efficent? store image in SQL server image field or store in server's harddrive?
View 13 Replies
View Related
Feb 27, 2004
Someone:
I have the need to upload a file via a webpage and then save that file into the database. I would also like to retrieve it and show it to the user.
Can someone show me an example of how this should be done. Also I am concerned of the pros and cons of saving files in the database. Is there a performance hit on the server? Will it make the database unstable? Has anyone had problems doing this?
Any suggestions, samples, and/or help are welcome.
View 3 Replies
View Related
Aug 7, 2007
Hi
Would anyone be able to tell me how to save a database and all its objects e.g. Procedures and views etc. onto a CD and then open it on another SQL Server? For SQL Server 7.0 and 2000.
Thanks
View 2 Replies
View Related
Apr 8, 2008
Hi all,
I have a replicated table with a column which is used to store sound files - it is of type varbinary(MAX).
What is the best way to store a file from the filesystem inside this column on the PDA side (i.e. inside SQL Server CE) without loading the whole file into the PDA's memory, i.e. using some sort of buffering?
On full SQL Server 2005 I make use of UPDATE.WRITE() to save buffers inside the column - is there an alternative to this on SQL Server CE? Can anyone provide sample code / point me to samples that deal with SQL Server CE & BLOBs.
Thanks for your help!
View 11 Replies
View Related
Jan 2, 2007
hi
I have binary files inside my database. and user should have the opportunity to download them from database to his computer. I don't want to retrive and save the file into the server first and then let him to download. is it posible???
thank you in advance
regards
View 3 Replies
View Related
Apr 29, 2007
hello,I am building a web page in asp.net 2.0 and i'm looking for a way to save various files uploaded by users (such as doc, pdf, cs, txt .... whatever). Obviously the normal way would be to store it on the filesystem of the web server (or any other middleware server).But I am asking if there is a way to store these files in the database, and not affect too much of the performance of the web page?I know a picture can be stored easily, but what about all the other file types? I would appreciate if someone can spead light of the subject.Thanks,Tranquil.
View 1 Replies
View Related
Feb 20, 2008
Hi all, I have an requirement that, I want to save data getting from text boxes etc..,on button click the data should be saved in database and also the data must be saved as word document with a file name with in the same database table which i am saving the data..i hope it's clear... I reached upto saving the data under button click..but I stuck up in converting the data to word and saving the same data in server ..??how to convert page data into word and at the same time i want that doc file to save in a table in serverThanks & Regards,Vamsee.
View 1 Replies
View Related
Feb 16, 2005
Hi !!
If i want to save, images, video clips or movies ......(multimedia stuff) in the SQL Server. Any idea how can i save them and call them. I also, want to know if that the effecient way to the task or there are other ways to di it???
Thanks!!!!
View 1 Replies
View Related