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 running on the 30 trial license. The server is on a network that is isolated in such a way I can't use an MSDN account to sign in. We were able to get VS 2017 Standalone shell installed with data tools using the off line method. Now the problem is I have a 2019 project and dts package with 2017 tools. Is there a way to downgrade the project to 2017?

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 imports this data into the database. I am looking for a way to view this DTS and potentially bring it into something a bit more modern (SSIS from my limited knowledge but I am open to other options). Any help would be appreciated. This is all using SQL-Server Enterprise Edition, version 15.0.4138.2.

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? if not, is there a way I can know what are those packages doing, so I can at least rewrite them? Because now they all stored as hex data, and I don't even know what are they doing... Thank you and any advice would be welcome.

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

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 table ---------- OrderID CustomerID OrderPlacedOn In an SSIS package I did this: 1. Execute SQL against Order db to extract the orders and put them in an object variable; 1. Loop through each order using "foreach container", in which I put a data flow task select top 1 * where CustomerID = ? and LevelGrantedOn < ? order by LevelGrantedOn desc that extract data from CRM db (both parameters come from step one), derive some columns and write the output to another table. There are more then twenty thousand records in the order db, which means the data flow task will be executed for more than twenty thousand times. The CRM db will be queried for more than twenty thousand times, too. It takes more than an hour to do these. Can I utilize some built-in features to speed up these (or do it in a "smart" way)? And, is an hour a long time, in the context of ETL and / or SSIS?

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 on a schedule, so I add it in a dtsx as an EST. The problem is that when I run this dtsx, be it manually on SSDT or automatically scheduled on SQL Server Agent, it fails with the message: >could not find server '-----' in sys.servers`. This is very odd. Of course the server is in sys.servers and the linked server is working. As I said, the exact same query works when run on SSMS. I can't even start to imagine what may be causing this inconsistency. Other linked servers work fine. Can somebody guess what may be causing it and what I could look for a clue? Googling this error only points me to explaining how to config linked server, but it's already there!

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 (Fwiw: The SSIS task is a simple datamart query - it returns results from a complex query into a single table on another server - the whole task runs in 40 seconds when executed by clicking on the DTSX package). The SQL Server agent is running on the destination server, and the connection is through a local network - I am remote from this network, but both machines can see each other on 192.168.1.##. I'm trying to understand what would cause the login to happen more than one time for this single task - I have set up Full login auditing on the destination server, and the logs look like this (I have truncated the screenshot to hide names, however in all of these logins it was the same username): It also shows multiple logins for the NetworkService account when I remotely connect to the SQL Server - so not just limited to this DTS task, just more pronounced here - and there is no specific issue with timeouts elsewhere!

1. I created SSIS project solution in VS2008. 2. I created 5 packages and deployed them to SSIS Storage succesfully. 3. I executed 4 packages successfully. 4. I leave SQL server few days alone (holiday!). 5. I open SSIS solution and made little change in 5th package. Save and Build solution. 6. I execute an deploy (same way as before, using dtsinstall.exe ..) **Change does not apply**. 7. I deleted package from SSIS storage. 8. I Execute deploy again.. but.. **package is missing**.. *Deploying is allways successfull **why packages are not loaded to server ?** What am i missing ? Thank you

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], Array(DTSSource("DEPT_ID"), DTSSource("ACCT_ID"))) IF NOT isEmpty(varamt) or NOT isNULL(varamt) or NOT varamt="" THEN DTSDestination("AMOUNT") = varamt ELSE DTSDestination("AMOUNT") = DTSSource("AMOUNT") END IF Lookup_tbl1 has ACCT_ID and DEPT_ID as the primary keys. My destination table does not have these as primary key and ACCT_ID has NULL values in the table. Dept_ID and Acct_ID are varchar. When I tried this transformation where ACCT_ID was not NULL, it worked, but not in the table where I want it to work. Here is the error message that I get: Inserting into [AMOUNT] ... Error details: The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80020101): Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Type mismatch: 'Join' Error on Line 36) Execution Failed.` There is no line 36 in my code. Please suggest solutions / pointers.

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 granting every possible permission, including making them db_owners of the MSDB but nothing so far has worked. If I grant CONTROL at the server level the nodes become visible but this is certainly not a sustainable set of permissions. Attached are 2 images. One of the nodes as I see them as one as they seem them. I've prowled around the web trying to identify the minimum rights needed but have so far not come up with the right formula. Does anyone know what the minimum rights for this process are or am I stuck making them temporary super-users? This is what I see This is what they see Thanks!

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 just plug in the query and it runs, but this time everything was complicated enough that we chose to approach it with a stored procedure employing temporary tables. How can I go about using this in a DTS package? I tried going the normal route with the Wizard and then plugging in EXEC BlahBlah.dbo... It did not care for that: > The Statement could not be parsed. Additional information: Invalid > object name '#DestinyDistHS'. (Microsoft SQL Server Native Client > 10.0) Can anyone guide me in the right direction here? Thanks.

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?

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 command. Is there a way I can see what this string represents?

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 locally; the job fails whether run manually or scheduled.

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 application are not listed in the Tables view. When generating a diagram, a popup appears stating that those tables couldn't be loaded. The weird thing is that data from those tables is actually returned in the application (not cache). The second issue is the use of DTS. I'm using the wizard to export the DB to text. I'm selecting "Copy table(s) and view(s) from the source database". Then, I get to choose the file type, delimiters etc. There's a drop-down which has the first table selected. My problem is, I can only select 1 table but I need to export the entire DB. When continuing, the server will only export the first table. How do I get it to export the entire DB? Doing it table by table will take far too much time.

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, changes only happen to one column. In my environment I have Sybase, Oracle, SQL Server & .net development Whats the best, simplest & reliable way to get this task done, should I develop a DTS, a .net app, use linked server of SQL Server or is there a better way?

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 = ? SET @endDate = DATEADD(DAY, 6, @startDate) INSERT INTO destinationTable SELECT * FROM sourceTable WHERE startDate = @startDate AND endDate = @endDate When I replace the parameter with a date (e.g. '08-01-2012'), the statement parses correctly; however, as soon as the parameter is added back in, the statement errs. I use DTS *very* rarely, so I'm basing this code entirely on Microsoft's Using Parameterized Queries . Can anyone enlighten me on how to correctly use a parameter in this situation? ---------- **Edit**: The error detail reads "Syntax error or access violation" which, considering the circumstances, I assume to read as a syntax error due to the addition of the "?".