I am trying to replace a DTS access exporter package with a exe we can call from our stored procedures (using xp_cmdshell). We are in the middle of a transition between SQL 2000 and SQL 2005, and for the moment if we can not use DTS OR SSIS that would be the best options. I believe I have the following options: Using a SQL data reade...
Hey, I was wondering if there's a way to export package information from Cognos 8 from a regular user level or from the framework level. For instance, I want the field names that cognos is pointing to on the database, i want the datatype, the description cognos uses when you right click a data element, etc.. Any suggestions? ...
HI all Can you tell how to import data from oracle 10g to Oracle 9i. Is it ok i can export the data from Oracle 10g and import it to 9i directly, it should work??? or i need to follow some other procedure??? Kindly help me Thanks in advance Joseph ...
Does anyone know of a plugin for Gedit that will export the highlighted syntax text to html? I want to use it to type in some code (say in Ruby) and easily export the text as HTML so that it displays in a web page exactly the same way as in Gedit. I have already tried Markus Jonsson's "HTML Export plugin for GEdit" but it does not seem ...
Hi, I was creating external dependecies in one of my repos. I made a mistake and I want to delete one of these dependecies. I can't delete the folder because that deletes the folder from the parent project. I'm using tortoise svn-client and I can't find a command to achieve this, I removed the external property from the properties list...
Hi there In my database I have some tables and views. How can I export all the tables( and not the views ) from my database from command line? ...
I would like to programmatically export my Procedures / Functions and Packages into individual files (as a backup) and using Oracle 9.2. The closest solution i found was using DBMS_METADATA.GET_DDL , but how do i output the CLOB to a text file, without losing any parts (due to length or indentation) ? Or maybe do you have other solut...
I know NetBeans has this feature, but I can't find it in Eclipse. A quick search for plugins was not successful. ...
Hi all, I have an Excel Spreadsheet that contains all my data that I need to put into an SQL Server database. I am fairly new o ASP.NET and have never had to export from Excel to SQL Server before. My Excel spreadsheets looks like this Trade Heading -> ArtID -> BusinessName -> AdStyleCode -> Address -> Suburb In SQL Server I have cre...
I'm writing a web application that needs to export data out of it. The problem is that every client requires a different format. Some want tab delimited, some comma seperated and even fixed width. Different data may also be needed by each export. What approaches should i consider to make it so that each client can have their own forma...
I would like to expose all subs into my namespace without having to list them one at a time: @EXPORT = qw( firstsub secondsub third sub etc ); Using fully qualified names would require bunch of change to existing code so I'd rather not do that. Is there @EXPORT_ALL? I think documentation says it's a bad idea, but I'd like to do it a...
Recently I got a habit of saving my preferences in Visual Studio 2008 for future use, so that whenever I may need to recover the system I won't have to remember what have I forgotten to customize. Tools - Options - Text Editor: Here are several groups distincted by the language. Among others you can see T-SQL, T-SQL7, T-SQL80 and T-SQL...
This question is long winded because I have been updating the question over a very long time trying to get SSIS to properly export Excel data. I managed to solve this issue, although not correctly. Aside from someone providing a correct answer, the solution listed in this question is not terrible. The only answer I found was to create...
A consultant employed by my client has asked for an export of the the first n rows (approx 30 or 40) of all the tables in one of our SQL Server 2000 databases in csv format, including column names on the first row. The database has about 100 tables so I don't want to do this manually. Can anyone recommend a script, tool or other appr...
Hi, I have a flash file that contains actionscript3 in it. I am trying to export my file as a .mov to play in quicktime. Sometimes it will work, then if I make a change to my file (moving a few frames around, but not changing the script at all), it will then export an empty file. Does any one have any tips on what I can do? Maybe how to...
How can I export the content of a stored procedure using a SQL Statement? ...
Hi there, i have another piece for more advanced guys than me ;) I am developing a simple flash application to create your own coat of arms. When finished creating, it would be nice to save it as an image to a client's computer or to a database, i am not sure yet. The problem is making the image from swf content - i mean not the whole c...
I am trying to export the HTML page contents to Word. My Html display page is: What is your favourite color? NA List the top three school ? one National two Devs three PS And a button for click event. The button click event will open MS word and paste the page contents in word. The word page contains the table property ...
Hi all, in my workpsace i do have SVN checkout classes and SVN export classes. I seperate the classes into two working sets. The exported classes are members of another feature based project and i am not allowed to change this classes inside my workspace. When i want to fix a bug or implement new features i want to be sure, that the ex...
I have a list in SharePoint that has versioning turned on. This list contains a multiline text column that stores notes about the list item. The "Export to Excel" function works and produces a spreadsheet of all the list items however, each list item only contains the most recent entry in the notes column. I'd like this export to contain...