dts
Linked Server and Cached Indexes
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[详细]
2023-01-08 11:24 分类:问答DTS SSIS- Task Script and Threading?
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.[详细]
2023-01-07 12:32 分类:问答DTS :How to migrate HTML data source into SSIS?
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[详细]
2023-01-05 22:24 分类:问答How to remove control characters from DTS/SSIS imports?
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.[详细]
2023-01-05 03:27 分类:问答How to transfer SQL Server DB structure to another server
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[详细]
2023-01-04 10:14 分类:问答Which CA issues Timestamping certificate
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[详细]
2023-01-01 09:04 分类:问答How to get details about the DTS Step in a running job?
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[详细]
2022-12-31 02:45 分类:问答Are there any tools to dynamically generate flat files from SQL objects?
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[详细]
2022-12-30 09:51 分类:问答DTS packages, SQL Server 2000
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[详细]
2022-12-28 14:24 分类:问答Executing a DTS package from Sql Server 2005
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[详细]
2022-12-27 05:46 分类:问答
加载中,请稍侯......