Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

(Page 1 of 3) 76 Result(s) found 

 

How can I transfer table from one database to other database with all other schema of that table (i.e. defaults, constraints, indexes ...)
Total Hit (1891) If you want to transfer both data and schema (table schema and indexes), you can use SQL 7.0/2000 DTS tool to export data from one server to another, just need to choose the option «b»"transfer objects"«/b» instead of the default "transfer tables", so that indexes will be transfered as well. ....Read More
Rating
This is a link to a different site How do I enumerate tables in an Access Database
Total Hit (981) If you need to enumerate the tables in an Access database, the easiest method is through the ActiveX Data Objects Extensions for Data Definition Language and Security. The ADOX library, as it is better known, can be used just like other COM objects from within ActiveX script, such as a task or workf ....Read More
Rating
This is a link to a different site Working with files and the FileSystemObject
Total Hit (922) The ability to work with files gives us great flexibility in how we use DTS. It allows us to add some intelligence into a package, and cope with unexpected situations automatically. The key to working with files is the Scripting Run Time as this gives us the FileSystemObject, which can be fully expl ....Read More
Rating
This is a link to a different site How do I open a file package or template
Total Hit (766) In the save package dialog screen there are several Locations available. The Structured Storage File option is useful if you wish to keep the package as a file, perhaps so that it can be added into a source control repository, or for manually copying to another server or transfer media. Whilst it is ....Read More
Rating
This is a link to a different site Create an Access Database
Total Hit (790) When exporting data to a text file, if the file does not exist it will be created, or if it does exist it will be overwritten. In contrast, when exporting to an Access database the file and table must exist already. This article will show you how to create an empty Access database ready to receive y ....Read More
Rating
This is a link to a different site Open File Dialog Custom Task
Total Hit (952) If you run packages manually and want the ability to select a file through a GUI, this is for you. This is a simple custom task that pops up a standard windows open file dialog box when executed. It assigns the chosen filename to a global variable for use within the package. ....Read More
Rating
This is a link to a different site Coping with text files and abnormal column or row delimiters
Total Hit (1027) Sometimes you may receive a text file to import that has a row or column delimiter not available in the standard drop-down boxes of the Text File Properties dialog. The first thing to try in these cases is to type directly into the Row Delimiter or Column Delimiter box. This will work fine if th ....Read More
Rating
This is a link to a different site Import all files in a directory using DTS (Multi Pkg)
Total Hit (1838) This example shows how you can use two DTS packages to control the import of all files in a given directory. For this, it is assumed that all files have the same format, and that all files are imported into the same table.
Rating
This is a link to a different site Where can I find more DTS information and samples?
Total Hit (1692)
Rating
This is a link to a different site How can I ensure that my scheduled DTS Packages will execute correctly?
Total Hit (1488) When your DTS packages get scheduled, a thing to keep in mind is that the SQL Server Agent executes them and they may not work as you intended due to the fact that the Agent is most likely running under a different security context.
Rating
This is a link to a different site "File Watcher" for SQL Server
Total Hit (1059) SQL Server Database administrators often come across situations where the scheduled DTS jobs failed because the Source File didn't arrive on time. It is a tedious process to cleanup if there are dependent jobs that have run before the first DTS job completed successfully. The intent of this article ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 10 - DTS Designer Tasks - The Data Driven Query Task
Total Hit (1659) In the arsenal of DTS Designer Tasks, the one that leads in terms of versatility (and complexity) is the Data Driven Query Task. Its most distinctive feature, distancing it from other tasks, is its ability to not only handle inserts of rows during transformation, but also process any other T-SQL sta ....Read More
Rating
This is a link to a different site DTS Servers and Schedulers for MS SQL
Total Hit (1717) Learn the basics of creating a DTS server, including how to change the DTS package according to batch schedulers used and the steps required to create and schedule jobs in Autosys and Smartbatch.
Rating
This is a link to a different site SQL Server 2000 DTS Part 9 - DTS Designer Tasks
Total Hit (1515) The last installment of this series discussed the basic principles and applications of the Transform Data task. This article continues, focusing on its more advanced features.
Rating
This is a link to a different site SQL Server 2000 DTS Part 8 - DTS Designer Tasks - Transform Data Task
Total Hit (1704) A few more DTS Designer tasks are left to cover out of a total of 17 existing in SQL Server 2000 Data Transformation Services implementation. Arguably, the one that has undergone the most significant changes since the SQL 7.0 release is the Transform Data Task. In this article, we will look at its d ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 7 - DTS Designer Tasks: the ActiveX Script task
Total Hit (1773) If you have been following our series of articles discussing SQL Server DTS technology, you probably have noticed frequent references to ActiveX-based scripting. While scripting is not very popular among database administrators, its potentials are worth exploring, especially since familiarity with i ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
Total Hit (1699) As we indicated in our previous article, we are going to continue discussing various ways of utilizing global variables in DTS Designer tasks. In particular, we will look into their role in exchanging data between packages, using features built into the Execute Package task. As part of this discussi ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables
Total Hit (1584) In the previous article of this series, we covered types of DTS Designer tasks that are more straightforward. We will continue this discussion here, focusing on ones that are more complex. However, before we proceed, we will look into the concept of DTS Global Variables, which will help us understan ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 4 - DTS Designer Tasks
Total Hit (1536) In the previous article of our series dedicated to SQL Server 2000 Data Transformation Services, we covered the first of the essential elements of a package - connection. Now it is time to look into another critical component - task - that is responsible for the processing of data retrieved through ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 3 - DTS Designer Connections
Total Hit (1578) In our previous article of this series, we presented a way of creating DTS packages with wizards. Despite its simplicity, this approach has some limitations, which you can overcome in two ways - by using DTS Designer or by manipulating DTS object model with programming languages, such as Visual Basi ....Read More
Rating
This is a link to a different site SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards
Total Hit (1653) As we explained in the first article of this series, there are three methods of creating DTS packages - with DTS Designer graphical interface, with programming by directly using the DTS object model, or with wizards available from the SQL Server Enterprise Manager interface. We will focus here on th ....Read More
Rating
This is a link to a different site MDX Essentials: Basic Set Functions: The Order() Function
Total Hit (735) This is the twelfth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs. ....Read More
Rating
This is a link to a different site Updating SQL Server Connection Properties from the DTS Package INI File
Total Hit (1682) In a typical development, QA or production environment, it can be very hectic to change all of the connection parameters, such as source file path, destination server name, table name, userID, password etc. in the DTS package when we move the packages from one environment to another environment. Thi ....Read More
Rating
This is a link to a different site Export a Table to a Date Stamped File Name in SQL Server
Total Hit (920) Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date stamped file. ....Read More
Rating
This is a link to a different site Import Files with Date-stamped Filenames or Paths
Total Hit (952) DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations. File-nam ....Read More
Rating
This is a link to a different site Using DTS to Detect and Process a File
Total Hit (894) There is nothing better than when a new technology lends itself to solving an old problem; well, there may be some things better, but this will have to do for now. One of the classic problems in computing -- classic being defined as a problem I have seen before -- is processing files that were uploa ....Read More
Rating
This is a link to a different site DTS How to...Skip Rows during Import
Total Hit (670) Firstly you can skip header rows by using the First Row property of the DataPump Task, see Advanced properties sheet. The Text File Connection also has a Skip Rows property, see file Properties of the Connection.
Rating
This is a link to a different site DTS How to...use and return global variables from the Execute SQL or DataPump Task
Total Hit (843) For those fortunate enough to have SQL 2000, using and returning global variables with an Execute SQL Task, or using them as part of source statement in the DataPump task is now a standard feature. For those still using SQL Server 7.0 this tedious process, but here are some examples of how it can be ....Read More
Rating
This is a link to a different site DTS How to...Transfer Packages between Servers
Total Hit (861) There are two ways to transfer packages between servers. The simple method is to save packages as COM Structured Storage Files, copy them to the new location, then open and save them to the new server. Whilst this works, it is very tedious when you have a lot of packages. You can automate much of th ....Read More
Rating
This is a link to a different site DTS Errors
Total Hit (853) «LI»"Could not create component categories manager" Or "Could not create an instance of the DTS package" «LI»"DTS WIZARD ERROR: CoCreateInstance - Class not Registered" «LI»"The parameter is incorrect" Or "Invalid class string" Or "The system cannot find the file specified" «LI»"The license fo ....Read More
Rating


(Page 1 of 3) 76 Result(s) found  1 2 3

Recommanded Links

 

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.