Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-07 : 21:38:10
|
Stacy writes "I have a DTS package that I'm trying to do a tranformation on using a select statement and having problems. I'm using SQL 7.0. I have a microsoft ole db provider connection set up which connects to the sql server and then I have an other connection set up as our as/400. I'm trying to do a tranformation between the 400 to the server basically pulling in data from the 400 based on a condition from a sql server table. I can't seem to get it to work. Is this possible to do. I wanted to create a local variable and used that to help with my selections but the data transformation doesn't like the declare statement.
This is basically what I'd like to do.
Select * from AS400.iptsfil.ipwkhst where
year - 2000 = (Select fiscalyear from PRFDSS.PBDSS.dbo.Calendar where priorweek = '1')
I've tried both qualifying the names and not. With this statment I get an error stating relational database PRFDSS is not same as current server *N.
Any idea would be greatly appreciated." |
|
|
|
|
|
dts transformation