I'm trying to create a completely new database from an existing MySQL database, bringing over both data and schema, but so far the only way I've been able to do this is to first import the MySQL database into MS Access, and then into SQL Server 2005? Crazy right? Surely, there is a way that doesn't involve a tedious, custom time-consumin...
Is there any way to export all the DTS packages on a server to .dts files in bulk instead of saving one by one using save as command ...
We have a large collection of DTS packages that need to be converted to SSIS as part of SQL upgrade?. How effective is this tool compared to the wizard?. Some of the functionality that is available in DTS Import/Export SQL operations Copying/Renaming/moving files Activex scripts (Not complex, most of the business functionality is in St...
I haven't done any audio coding before so bare with me. basically, I've noticed that some media players can directly stream AC3 and dts streams to the spdif out (like media player classic playing a dvd) because of the way it does it, it bypasses all of the system sound integration and re sampling and stuff (so none of the software volume...
I am trying to sync up a SQL Server table with a Lotus Notes database. I have set up the NotesSQL ODBC driver and have been able to insert, update and select from the notes database form using the ActiveX Script Task in DTS. Everything works well until I try to insert Chinese characters into Text field in the notes database. After insert...
Hello, What is the easiest way to remove multiple DTS packages from SQL Server 2008? Thanks. ...
Hi, I have one source database, which I want to copy (table structures) to new database. I need to execute this package at least 50 times. Each time my source database is same, but destination database varies. So I decided to create a DTS package that will receive a destination database name as a parameter. Que: Is is possible to pa...
I have a DTS (not SSIS) package that hasn't been touched in years that I had to update a query with. When I run the package by manually executing each step in the editor, everything works out fine and generates a file of a couple thousand records as expected. When I hit the "Execute" button at the top of the editor to run the whole pac...
Using SQL Server 2005, but still using DTS. I need to add a step to check if a table is empty, and somehow fail the step if it is. It's easy checking if the table is empty: Select count(*) from source_table But returning 0 is a success, too. If it is 0, I want a failure (so that I can fork to a different option, email us, skip some...
An ActiveX Script in a DTS package can return DTSTaskExecResult_Success or DTSTaskExecResult_Failure. Is there a way to indicate that it is not a success without failing the entire package? We'd like it to keep going, but in a different direction. The options for a path are Success, Failure, and Completion, but it appears the only ret...
Hello, I would like to change the existing DTS schedule date for a job using activex. The activex is going to be run from another DTS. Is this doable? Any suggestions/hints are appreciated. Thanks, ...
In VB6: I need to allow a user to select an Excel file, and then upload All Worksheets to a SQL table. I'm not sure how to do this. The format of each sheet is exactly the same. And the worksheet format matches the SQL table format. I'm really banging my head against the wall over here. If anybody could offer a suggestion, or a cod...
I have a Send Email Task in my DTS Package OnPostExecute event. It sends email to the developers after this package gets executed. It works but the problem is it sends the same email twice. Am I missing something? Thanks! Ryan ...
Basically, I can't find a way to combine two types. For example, supposing I want a connection to refer to a text file that is held in a path identified by one of the environment variables, and whose filename is a string form of the current day. I can use SQL to set the filename, and an environment variable to set the path, but I can't ...
Does anyone know of a way to search DTS packages for specific strings?. I saw this http://www.dtspowersearch.com in google search. Any feed back on this tool or anyother tool or pointers on how to accompolish this. ...
I'm trying to produce a column 'start/length' spec document from a SSIS package that exports a DB table to a flat file. I have hit something of a brick wall in getting the Columns property from the ConnectionManager object that handles the flat file connection. I am able to get the Columns property, but I cannot do anything with it, as...
I have a SQL Server 2000 DTS package. One of the steps of this package has the following SQL: SELECT * FROM [Crocus_Limited$OrderRequestDetail] WHERE (rep_updated > GETDATE() -2) AND NOT EXISTS (SELECT OrderID FROM NavisionUpgrade.navision4.dbo.[WEBOrderDetails] rd WHERE rd.OrderID = [Crocus_Limited$OrderRequestDetail].OrderID ...
I created a DTS package. Someone else wants to be able to save it after modifications but he is getting error: only sysadmin and DTS creator can save versions of DTS. I have given him dtsadmin rights in msdb and he has db_owner rights in all the Databases which link to this DTS package. I dont want to give him sysadmin rights. What i...
I would like to publish some data of a sql server 2k to msaccess databases. I'd like to do that given a table supplying datatransformation info, for example : tablenameOnServer | pathToPub ------------------------------------------------------ Clients | D:\Data\Pub1\ClientData1.mdb Orders | D:\OtherData\Pub...
I'm writing a C# application to generate an SSIS package. Part of this involves adding database connection managers - using the library Microsoft.SqlServer.Dts.Runtime. The following line of code shows how this can be done: ConnectionManager cm = pkg.Connections.Add("OLEDB"); In the above code, I am adding an OLEDB connection, which ...