|
Home > Archive > MS SQL Server DTS > September 2005 > problem executing a data pump task
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problem executing a data pump task
|
|
|
| I'm executing a store procedure in the source tab of a data pump task, the
real problem is that the source server is a Sybase ADS 12.5.3, I was using a
sybase 11.9 and when I select the transformation tab the source columns
apears, but now they don't. So the Task returns error.
Can Anybody help me?
| |
| Allan Mitchell 2005-09-22, 8:24 pm |
| Whilst I do not use this type of source, is the query the exact same?
Do you have named columns defined in the query? Are you using an old
driver per chance?
Allan
"Flor" <Flor@discussions.microsoft.com> wrote in message
news:90CB7B3D-E718-4604-812F- C06845FD6544@microso
ft.com:
> I'm executing a store procedure in the source tab of a data pump task,
> the
> real problem is that the source server is a Sybase ADS 12.5.3, I was
> using a
> sybase 11.9 and when I select the transformation tab the source columns
> apears, but now they don't. So the Task returns error.
> Can Anybody help me?
| |
|
| Allan thanks for reading my discussion.
Well the store procedure returs a select, I have used it before, but I
think that the real problem is the ODBC, I'm not sure. Maybe you can email me
a ODBC patch for sybase ADS 12.5.3.
"Allan Mitchell" wrote:
> Whilst I do not use this type of source, is the query the exact same?
> Do you have named columns defined in the query? Are you using an old
> driver per chance?
>
>
> Allan
>
>
>
> "Flor" <Flor@discussions.microsoft.com> wrote in message
> news:90CB7B3D-E718-4604-812F- C06845FD6544@microso
ft.com:
>
>
>
| |
| Allan Mitchell 2005-09-22, 8:24 pm |
| Maybe DataDirect.com will have one. Have a Google
"Flor" <Flor@discussions.microsoft.com> wrote in message
news:3F8169D3-B935-4782-B4B4- 9126A210F78B@microso
ft.com:
[color=darkred]
> Allan thanks for reading my discussion.
> Well the store procedure returs a select, I have used it before, but I
> think that the real problem is the ODBC, I'm not sure. Maybe you can
> email me
> a ODBC patch for sybase ADS 12.5.3.
>
> "Allan Mitchell" wrote:
>
>
>
> task,
> columns
>
|
|
|
|
|