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 |
|
Raghav1981
Starting Member
2 Posts |
 Posted - 2009-04-07 : 02:02:59
|
| IN SQL 2000 DTS , i created linked server using following SQL as Execute SQL Task :************IF (SELECT COUNT(*) FROM MASTER.DBO.SYSSERVERS WHERE SRVNAME = 'TEST') > 0EXEC sp_dropserver 'TEST', 'droplogins'DECLARE@SERVER VARCHAR(8000),@USER VARCHAR(8000),@PASSWORD VARCHAR(8000),@DATABASE VARCHAR(8000)SET @SERVER = ?SET @USER = ?SET @PASSWORD = ?SET @DATABASE = ?EXEC sp_addlinkedserver@server = 'TEST',@srvproduct = '',@provider = 'SQLOLEDB',@datasrc = @SERVER,@catalog = @DATABASEEXEC sp_addlinkedsrvlogin 'TEST', 'false', NULL,@USER,@PASSWORD*****************Same thing i need to create in SQL 2005 SSIS , how i can do it? can any one help me regarding this? as when i try to create Execute SQL task with EXEC statements , its showing "not supported".Raghav |
|
|
|
|
|
|
|
SSIS package how to create Linked Server SQL task?