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
I have a variable called Valint that i need to read/write to in a script task, but it doesn\'t seem to work:
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
I have a sql query that looks like this: SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)
I am converting a DTS update lookup to an SSIS lookup with an update query. So far it doesn\'t seem to work.
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
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
I want to copy all my database to remote database server. I have access to server using SQL server management studio.
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
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.