dts
Reading Data Pump Task in DTS without having source and destination environment
I am working开发者_如何学运维 on migrating a DTS package which contains a oledb source (but we dont have access to the source), a olebd destination (but we have access to the dest.) and a DATA Pump Ta[详细]
2023-04-12 21:31 分类:问答SSIS read/write to variable in script task
I have a variable called Valint that i need to read/write to in a script task, but it doesn\'t seem to work:[详细]
2023-04-12 01:40 分类:问答Using a script task in SSIS with C# language, how to convert a DTS ActiveX script that creates files and then appends the full file names
I\'m trying to convert a DTS process to SSIS and I want to convert a DTS script task that creates 3 files (only creates the file if there’s data to write to it) and then appends the full file names t[详细]
2023-04-11 15:22 分类:问答ssis lookup with sum - can't map parameters
I have a sql query that looks like this: SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)[详细]
2023-04-06 17:48 分类:问答SSIS lookup with Update possible?
I am converting a DTS update lookup to an SSIS lookup with an update query. So far it doesn\'t seem to work.[详细]
2023-04-05 15:44 分类:问答Scheduling DTS in SQL Server 2008
We are moving from SQL Server 2000 to 2008 and currently just migrating our DTS packages without converting them to SSIS. I can\'t find a way to create schedule开发者_如何转开发d jobs for those DTS pa[详细]
2023-03-25 19:35 分类:问答Differential Update With SQL Server
I have several huge (2GB each) database in Firebird format. Every few weeks, this data has 开发者_Python百科to be synchronized with an MS SQL Server. Currently this is a long winded process which just[详细]
2023-03-13 21:47 分类:问答How can I move data from one SQL Server to other?
I want to copy all my database to remote database server. I have access to server using SQL server management studio.[详细]
2023-03-11 06:31 分类:问答Convert Access Database to SQL Microsoft DTS - Data Type '130' not in mapping file
I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the data type of a particular type of field in[详细]
2023-03-07 06:09 分类:问答SSIS XML DTSConfig update (VS 2005)
I have a DTS package with a XML configuration (.dtsconfig) file where i have some information that开发者_StackOverflow needs to be updated every time the package runs.[详细]
2023-03-05 15:51 分类:问答