Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [dts]

17 questions
5
votes
1 answer

How to figure out what a DTSRun command is doing

I have taken over a SQL 2000 database. I am trying to figure out what a job is doing. Its command is: DTSRun /~....a big hex string.... I have tried to run: DTSRun /~....a big hex string.... /!Y to see what it is doing, but it just repeats the…
rhughes
  • 325
  • 3
  • 5
  • 14
3
votes
1 answer

Creating an SSIS package that uses a stored procedure

We're trying to make an SSIS package where it'll launch a stored procedure and capture the contents in a flat file. This will have to run every night, and the new file should overwrite the existing file. This wouldn't normally be a problem, as we…
Victor
  • 31
  • 1
  • 2
3
votes
2 answers

Optimize SSIS package for fewer queries

I need to associate customers' order with their "level" (Silver, Gold, etc.) when they placed the order: CRM server::CRM db::CRM table ---------- CustomerID PreviousLevel NewLevel NewLevelGrantedOn Order server::Order db::Order…
Ryan
  • 313
  • 5
  • 15
2
votes
0 answers

How do I pass a parameter in a stored procedure to call a DTS package

I have created a DTS package which fetches data from a text file into a database table. I want to pass the file name dynamically from which it fetches data. Can I pass the filename dynamically?
yogesh
  • 21
  • 1
2
votes
2 answers

Does a SQL Server job run on the server or the local machine?

Does a SQL Server job always run on the server, or will it run in the context of the local machine, similar to a DTS package run from Enterprise Manager on the user's machine? The job in question calls a DTS package. The package succeeds when run…
JerryOL
  • 335
  • 1
  • 3
  • 7
2
votes
1 answer

SQL Server 2000 export database to csv

I need to move an SQL Server 2000 database to MySQL. I'm running into several complications. I'm no expert on SQL Server. To get going I'd like to have a csv-dump of structure and data. First issue, 3 tables which are clearly in use by the…
Abel
  • 119
  • 3
2
votes
0 answers

DTS error when a parameter is added to an Execute SQL Task

I have an Execute SQL Task that is (hopefully) going to receive a global variable called startDate, which is set to a Date type. A shortened version of the code looks like this: DECLARE @startDate DATETIME, @endDate DATETIME SET @startDate…
Davenport
  • 327
  • 1
  • 3
  • 9
1
vote
1 answer

How to sync a table between oracle and sybase

I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source) I cannot truncate and populate the table in Sybase because it is used by an application, I can only add new records and update changes,…
AmmarR
  • 2,826
  • 3
  • 28
  • 33
1
vote
2 answers

Linked Server works on SSMS and isn't found on SSDT

My Microsoft SQL Server has a linked server to another SQL Server. I have a simple query that runs on mine, deleting a remote table (truncate doesn't work) and inserting data to it. This query works fine if it's run in SSMS. But I need it to be run…
Hikari
  • 1,603
  • 12
  • 28
  • 42
1
vote
0 answers

Repeated login issue SQL Server 2008 R2 (SSIS)

I'm trying to figure out an issue I'm currently having with an SQL Server connection - there has been a few issues with timeouts on a SSIS package, where it has failed a login attempt - however as far as I am aware, the job should only connect once…
SeanR
  • 257
  • 1
  • 2
  • 9
1
vote
1 answer

dtsinstall.exe does not deploy packages

I created SSIS project solution in VS2008. I created 5 packages and deployed them to SSIS Storage succesfully. I executed 4 packages successfully. I leave SQL server few days alone (holiday!). I open SSIS solution and made little change in 5th…
Muflix
  • 1,099
  • 5
  • 15
  • 27
1
vote
1 answer

DTS Type Mismatch at Join

I am new to ETL and VB in general and need some help resolving this issue. I have looked online and found some interesting answers but none seem to be working for me. varamt = Lookup ( "Lookup_tbl1", [Lookup_tbl1].[Amount], …
Drj
  • 163
  • 1
  • 6
0
votes
0 answers

Looking to find a working download to view or change DTS

I am new to working with databases and have inherited some legacy internal applications. These applications rely on a job that run daily to import data from excel into a database to get new data into the application. This job is executes a DTS that…
J.L.
  • 1
  • 1
0
votes
1 answer

How can I downgrade an SSIS project for use with VS 2017 standalone?

I inherited a project that was being built in VS 2019. After I finished building it and asked the requestor for clarification on how to handle a few scenarios I get a warning that the license for VS 2019 is about to expire. Turns out the project was…
RemonsterGrrr
  • 1
0
votes
2 answers

Why VIEWS are showing in Data Transfer Service SQL

Im trying to run DTS from one Db to another in Same server instance. But at the select objects to copy stage, its showing the VIEWs also. But VIEWS are only some customised queries. But why its been shows in DTS
Sandeep Thomas
  • 141
  • 6
1
2