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 2008 Forums  SSIS and Import/Export (2008)  User Defined Variables

Author  Topic  sqlrich Starting Member 6 Posts Posted - 2010-04-15 : 02:24:51 Hi All, I got a situation where I have a stored procedure which returns a date value. 1. I need to store that returned value into a user defined variable. (Server:1, DB:A) 2. And i need to pass that variable as parameter to a SQL (Server:2, DB:B) NB: stored procedure is in different db in different server. and SQL is for different db in another server. Thanks in advance.