Questions tagged [dts]
The dts tag has no usage guidance.
17
questions
0
votes
0
answers
29
views
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 ...
0
votes
1
answer
447
views
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 ...
0
votes
2
answers
51
views
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 ...
- 141
0
votes
2
answers
673
views
how to edit and migrate DTS package on SQL server 2000
I currently have an old SQL server 2000, with some DTS packages in system database msdb, table msdbsysdtspackages.
I need to migrate those packages to sql server 2016, is there a tool I can do that?
...
- 65
3
votes
2
answers
179
views
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 ...
- 313
1
vote
2
answers
445
views
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 ...
- 1,523
1
vote
0
answers
55
views
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 ...
- 247
1
vote
1
answer
489
views
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 ...
- 1,079
1
vote
1
answer
134
views
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 (
"...
- 165
0
votes
1
answer
244
views
Permissions To Update Legacy DTS Packages
I am trying to grant access to allow users to view and update existing legacy DTS packages. The problem is that they cannot see the needed nodes under Management to begin working on them. I've tried ...
- 828
2
votes
0
answers
356
views
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?
- 21
3
votes
1
answer
7k
views
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 ...
- 31
5
votes
1
answer
10k
views
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
...
- 325
1
vote
2
answers
2k
views
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 ...
- 325
2
votes
1
answer
2k
views
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, ...
- 119
2
votes
0
answers
674
views
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 ...
- 327
1
vote
1
answer
1k
views
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 ...
- 2,776