Have a DTS package that is running in Development, SIT开发者_如何学编程, and UAT.All of the SQL Servers in each of the environments has the same linked servers setup and are the tech specs similar.The
I have written a task script using vb.net that have thre开发者_高级运维ad used in the code, the problem is how i can know when will be finished all the threads so i can return the success result.
I need to migrate the DTS (SQL 2000) package into SQL 2008 SSIS. The DTS packa开发者_开发问答ge is using HTML file data source and a Transformation task to import the HTML table
The company I work for has a开发者_如何学Go lot of systems where the source data originates as a flat file or Excel workbook. These files are then imported using DTS into a SQL Server database.
Tell me please what\'s the best way to copy db structure to another server? I\'m trying to generate a script in Management Studio and then run that script on the remote machine. And I hate that thing
Our company currently implementing TSA (Time Stamp Authority) service. And now we are searching CA (Certification Authority), wh开发者_开发知识库ich could issue certificate withintended usage: Timesta
I have scheduled a DTS to run from a scheduled job. The DTS has several steps in it. Now whenever the job is running and I take a look at the jobs section in Enterprise manager, then it always display
I\'m looking for a tool or component that generates flat files given a SQL Server\'s query result (from a stored procedure or a SELECT * over a table or view). This will be a batch process which runs
I\'m currently in the process of cleaning up a sql server 2000 instance. I found 10 L开发者_JS百科ocal Packages that were created 4-5 years ago. In an effort to clean up old processes, I want to delet
I am trying to run several DTS packages from a sql 2000 box. The DTS calls will originate from .net 2.0 - 3.5 code. I have been unable to find a good way to programmatically accomplish this. What I ha