Dynamic object in DTS ExecuteSqlTask

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Dynamic object in DTS ExecuteSqlTask

Author

Topic

krsk
Starting Member

21 Posts

Posted - 2003-03-11 : 06:56:25

Hi :-)

I'am selecting the first row of a DB2 table through a ExecuteSQlTask, so I can check that the period (date) is correct before I load the table via the data pump statement.

How can I make the table dynamic?

SELECT PERIODE
FROM A64473.BALI_AFS_MD_200301
Fetch first 1 rows only

It will ofcause not accept ? and @ since it is a object...stored procedure??? will it work when the table i locate in AIX/DB2

SysDB: MS SQL 2000 sp3

/Kristian :-)

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-03-11 : 07:17:04

Hello Kristian.

I think you should take a look at the dynamic properties task in DTS. That will enable you to dynamically create the query if you want to. The table name could be fetched from another table, or generated with an ActiveX script.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources