Все вопросы: [dts]

72 вопросов

похожие теги:
1
голосов
1ответов
126 просмотров

Резервное копирование SQL Server 2008 от заблокированного хостинг-провайдера

У меня есть общая база данных MS Sql 2008 с моим хостинг-провайдером и MS SQL Standard 2008 на моем локальном компьютере. У них заблокирован SQL Server (что вполне справедливо), но это означает, что у меня нет достаточных прав для использования мастера резервного копирования базы данных или для ...

1
голосов
1ответов
3209 просмотров

Adding SSIS Connections Programmatically - Oracle Provider for OLE DB

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 cod...

0
голосов
3ответов
4239 просмотров

How to export tables from sql server to ms access on the fly?

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....

0
голосов
1ответов
1767 просмотров

SQL server- DTS package: minimum rights

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...

0
голосов
2ответов
2957 просмотров

SQL Server 2000 DTS - Cannot resolve collation conflict for equal to operation

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 = ...

2
голосов
1ответов
1826 просмотров

List columns in a SSIS Flat File Connection

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 prop...

0
голосов
1ответов
884 просмотров

String search in DTS

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.

0
голосов
1ответов
53 просмотров

How to combine two types of dynamic property in SQL Server 2000 DTS?

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 environme...

0
голосов
1ответов
726 просмотров

DTS Send Email Task sends email twice

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

3
голосов
1ответов
1700 просмотров

Automate Importing Multiple Excel Worksheets into SQL

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.

0
голосов
3ответов
981 просмотров

Can an ActiveX Script (DTS) return complete instead of success or failure?

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, a...

2
голосов
4ответов
3708 просмотров

How to return a failure if a table is empty

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 ...

1
голосов
2ответов
451 просмотров

DTS - Manual step excution gives different results than just hitting "Run"

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 ...

1
голосов
1ответов
3108 просмотров

Pass parameter to SQL DTS package

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 ...

0
голосов
1ответов
4340 просмотров

Remove DTS packages from SQL Server?

What is the easiest way to remove multiple DTS packages from SQL Server 2008? Thanks.

3
голосов
3ответов
1807 просмотров

Insert from MS SQL to Lotus Notes using NotesSQL drive

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...

0
голосов
1ответов
887 просмотров

DTS exchange tool

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, m...

0
голосов
3ответов
1725 просмотров

Convert a MySql database to MS SQL Server 2005 with data?

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...

1
голосов
4ответов
6391 просмотров

What tools are available for DTS to SSIS package conversion

What are the tools available for DTS to SSIS package conversion as a part of the SQL Server upgrade and which ones do you recommend?

7
голосов
4ответов
1579 просмотров

Unit Testing for VBScript, ASP Code and SQL Server 2000

I have a very old project implemented in (classic) ASP and SQL Server 2000. Because of quality concerns, I've been considering the possibility of implementing some form of automated quality testing. Though, the web pages are ASP the project is really 85% SQL Server stored procedure, functions, v...

1
голосов
1ответов
2120 просмотров

Upgrading DTS packages to SSIS Packages

My question is similar to Upgrading SQL Server 2000 to 2005 or 2008 - DTS to SSIS but I have a few restrictions that I'd like the community to consider. We have two databases that currently run on SQL Server 2000 and we are being pushed to move off of this in favor of SQL server 2005 (We do not...

2
голосов
2ответов
3682 просмотров

Find a reference to a table in DTS packages

I need to find a DTS package that contains a specific table name. There are 200+ DTS packages each with multiple objects in them. My_Prod is the table name. Is there a T-SQL command to find all the DTS packages that reference this table name?

0
голосов
1ответов
511 просмотров

Importing Text File to Database Causes Out of Space Error

When I try to import Text File into SQL Server 2000 using DTS, it gives me the following error Not enough storage available to complete this operation Any suggestions?

0
голосов
3ответов
4363 просмотров

DTS for SQL Server 2005 Express Edition

What did Microsoft rename DTS to for SQL Server 2005 Express Edition? Where is the download link to the SQL Server 2005 Express Edition DTS utility? i've been searching for half an hour, and i can't find a definitive answer. i need to import data from a data source into an SQL Server 2005 Ex...

0
голосов
3ответов
5375 просмотров

What are the security risks using cmdexec?

We are in the process of migrating from SQL 2000 to SQL 2005. We have hundreds of DTS pacakges, that the development team is reluctant to redevelop using SSIS. When migrating these packages to SSIS, I am faced with a problem - many of these packages read from Excel files. Given that my product...

1
голосов
2ответов
334 просмотров

Execute SQL Server 7 DTS on SQL Server 2008

I believe its possible to run SQL 2000 DTS packages on 2008 with a compatability layer. But is it possible to do the same with DTS packages created on SQL 7? Is there any MS KB or note that points out if this is even a possibility.

1
голосов
1ответов
383 просмотров

Извлеките данные из текстового файла перед добавлением их в таблицу в SQL-Server 2005 DTS

Я должен работать в среде DTS в 2005 году (слишком сложно объяснять), и у меня есть текстовый файл с разделителями-запятыми, который нужно добавить в основную таблицу. Я хотел бы вытащить последний столбец в текстовом файле для первой записи и использовать его в качестве критерия выбора для кома...

1
голосов
1ответов
313 просмотров

Использование DTS для передачи схемы базы данных, в которой таблицы имеют несколько владельцев

У меня есть схема базы данных в SQL 2005, которую я хочу скопировать на сервер SQL 2000. Он содержит таблицы, у которых есть несколько владельцев. Когда я пытаюсь создать пакет DTS для передачи схемы, я получаю конфликты, потому что некоторые таблицы имеют одно и то же имя (но разные владельцы)....

0
голосов
1ответов
89 просмотров

Как сравнить DTS в SQL Server 2005

После преобразования ваших баз данных из SQL Server 2000 в SQL Server 2005, есть ли способ сравнить DTS на двух серверах, чтобы убедиться, что они по-прежнему одинаковы? Мне нужно увидеть, совпадают ли мои разработчик и продукт, и сравнение их вручную действительно занимает много времени. Есл...

0
голосов
1ответов
593 просмотров

Ошибка подключений DTS

Я получаю эту ошибку при попытке выполнить пакет: «Соединение в настоящее время используется задачей. Соединение не может быть закрыто или повторно использовано.» Есть идеи?