I have a DTS package that runs on our MS SQL Server 2000 database server, and need a way for users to execute it from their own machines.(The package creates files that are then transferred by my appl
I am currently developing completely on a local machine and have a DTS package that on completion should run a local exe file that compresses the csv files that were just impo开发者_开发知识库rted.
I am using SQL Server 2008 and Visual Studio 2008 I have two databases.I need to run a query in a database and grab those results
So I made a package in SSIS to read data in from a text file and load it into a database table. What\'s the best way to set this up for non technical end users to run this when desired?
The task is to have SQL Server read an Excel spreadsheet, and import only the new entries into a table. The entity is called Provider.
What technical issues am I likely to encounter when migrating a database from SQL Server 2000 to SQL Server 2005? Are there any common problems I should be aware of?
I\'m creating a DTS package.After specifying the source, destination, and tables, I get the Save, schedule, and replicate package step, which has a Save DTS Package checkbox.
I have a VS 2008 project that is using DTS.The project is in source control, and I don\'t want to check out and modify the project references for fear of stubbing the toes of other developers for whom
I have a shared MS Sql 2008 database with my hosting provider and MS SQL Standard 2008 on my local box. They have the SQL Server locked down (rightly enough) but it menas I don\'t have sufficient priv