Data Transformation Services (DTS) Interview Questions 

I have access to a remote database and wish to copy some tables to do work on localhost.

(1) I have no physical access to remote. I only have login credentials and the names of the tables I need. I don't even know the table structures. I think this rules out DTS and exporting stuff but I could be wrong.

(2) I'm running Xampp on local (Apache, MySQL, phpMyAdmin).

-
I thought of:

CREATE TABLE localdb.table LIKE remotedb.table;
INSERT INTO localdb.table SELECT * FROM remotedb.table;

...but this is pure SQL and I think only works if both databases are on the same machine? Plus I'm a newbie at phpMyAdmin, and I haven't figured out how to make it work like that (getting data from remote to local).

Any ideas, other tools I should be using? All I need is to get those tables from remote to local. Once they're here I can work on them.

I use SQL Query analzer and Enterpise manager to run DTS packages but am unsure how to create the connection to the Ingres DB. TIA for any help

Create dts package in sql server 2000
that will execute stored procedure and display output as an xml file.

in short, i need,
steps To create an XML file from a SQL stored procedure in Sql Server 2000.

I'm sending bulk email via MS-SQL server's "DTS Meta Data Service Package" (Visual Basic). I can get the email body text into Korean by using the parameter:
.BodyPart.Charset = "euc-kr"

How do I do the same for the subject line? I'd like to include a line something like:
.Subject = objMessage.EncodeHeader(Subject, "euc-kr")
but I get "Does not support this method"

I have the same problem in Chinese and Japanese. Advice? Or better yet, VB code?

im trying to create a program that read from text file and chop the string to segments so that i can map the chop segments to certain field..it is some sort like the one in DTS (sql server)..1st you have to retrive a text file...do the chopping and then define the table to which you want to map the field...im doing the coding in vb.net (windows form)... Can anyone help me please...

hello:)
I am trying to create a DTS Package and I have encountered a problem regarding the DATETIME. I wanted to get the data from yesterday (GETDATE()-1), it doesn't seem to run in DTS.
My code looks like this:

DECLARE @TRANSACTIONDATE DATETIME
SET @TRANSACTIONDATE = GETDATE()-1
.
.
.
WHERE SPSH.INPUTDATE = @TRANSACTIONDATE

The error says:
[INTERSOLV][ODBC SQL Server driver][SQL Server]Operand type clash: INT is incompatible with DATETIME

thanks:)

I am having problems instantiating a object. I know this is down to permissions but I am not sure what steps to follow in resolving. Basically I have a asp.net application which calls a stored from sql server 2005. In this stored procedure I am using DTSRUN to kick off a DTS package. Within the DTS package I have a execute process task which call a vb appliocation. It is within the dts application that I instantiate an object but when call this from stored procedure it fails, within EM it's successful.

I know this is down to permissions (sql server service, agent service, sql proxy account, etc...) but I am not sure how to determine what account is actually running the exectue process tasks.

if I am executing stored proc from asp.net on sql server 2005, what account is executing my VB - .exe program file file?

I am pretty good at SQL (using 2000) but am having trouble automating an export to excel. I have a tbl and want to export the whole thing to an excel spreadsheet. I set up a dts pkg to do this, but each column is being prefaced with a ' at the beginning. So I have columns called 'SalesRep and 'Month. I need to get the ' out of the name, but I have not been able to. I thought it was not a huge deal b/c I had to open each one to check them each month, and I could do a replace all of ', but excel does not even see it. I did not see anything in a quick search of the internet. Any one see this before, know how to fix???

I'm currently working as IT developer using ASP, SQL SERVER. Now i have got with an offer to be working only with SQL SERVER's DTS Package and with DataWarehousing.

Is it good to be only with database side ? Does it helpful for my career ??

Please suggest me. Thanks in advance.

Create dts package in sql server 2000
that will execute stored procedure and display output as an xml file.

in short, i need,
steps To create an XML file from a SQL stored procedure in Sql Server 2000.

I am exporting data from a table to import into a nother database (MapQuest) In my database I have characters such as ' example Jim's Store the single quote in Jim's (') is causing the import to fail. Just like Unit "C" in the address field, the double quote causes it to fail.

I am exporting the data through a DTS package, the first step is to fire a stored procedure to grab the data and what I want to do is call a user defined function that will strip the data of any unwanted characters that I specify in the function when it grabs the data.

Hello,

I have a datawarehouse where I pull in data from Progress database to SQL Server 2000. I use DTS to copy the new data from a table from progress to SQL server but the problem is that some of the data are not new but updated data. So my question is how do I use the DTS to update if the data is already in there and insert if it is new data?

Another one of my plan was to insert all the previous days transaction into a temp table and use a store procedure to insert and update the datawarehouse table. which solution is better?

I am new to SQL server. Is there any one can tell me how to transfer the Tables, Forms, Querys, reports and Macros to SQL? (Using DTS ?)

I do not have SQL 2000 installed anymore, so I cannot look up the exact table and column names. However, I can point you in the right direction: Look at the following stored procedures in the MSDB database:

sp_add_dtspackage
sp_enum_dtspackages
sp_get_dtspackage

The commands in these sprocs should give you enough info to find out which system tables store the data you are looking for.

I think if you register both of the servers on Enterprise Manager, you can right-click on them, then click "All Tasks" - there's functions for copying tables so there might be some for copying DTS jobs.
Or, maybe, you can right click on the DTS job (like when you right click on a stored proc to "Generate Script"), and you can generate the script to reproduce it.