Hello Colin...We have clients running our app via Citrix against Sql Server and Oracle databases. There are so many variables to consider here. In our case, the client app is...

Santhosh,

If I understand, all you need to do is enclose the owner and table name in single quotes.

DBCC SHOWCONTIG('bill.tablename')

Vishal,

A very simple way, as Phill mentioned, is to 'Save As' and select structured storage file.

On the 2nd server, right-click DTS and select 'Open Package' and select the saved file....

DnD,

Was faced with something similar a while back. I downloaded IBM Informix Connect. You should also be able to get the Informix ODBC drivers from IBM's site. From there you're...

Ryk,

Let's look at this from a weasel's perspective. Someone is going to have to do some work here. Why should it be you? Why not push back to the folks...

Lara,

I have seen similar behavior when the package has been created on one machine, but gives you the error when opening properties on another.

Example...

You create a package with a specific...

Rick,

Can you provide the table structure of the data that you're bringing over?

As for dateTime values, I usually will get an overflow error if it's an invalid date along...

Nilardi,

This should be fairly simple with DTS.

-create a new Local Package

-Create a connection to The Oracle DB (Icons on top left)

-Create a connection to the Sql Server

-Click transform stat...