June 20, 2008 at 3:12 am
iam using sql server 2005 express. we have two branches for our company.we have lotus notes is the only connectivity...i also have sql server in other branch...
can i get the sql data from other branch to my server when they saving...???
if so pls explain me in detail...
June 20, 2008 at 5:08 am
Didnt know that you have Integration Services with SQL Server Express
June 20, 2008 at 6:33 am
i dont know it...
June 20, 2008 at 4:19 pm
seenu_61281 (6/20/2008)
iam using sql server 2005 express. we have two branches for our company.we have lotus notes is the only connectivity...i also have sql server in other branch...can i get the sql data from other branch to my server when they saving...???
if so pls explain me in detail...
Hey, This is very simple. You can do it with SSIS packages. Even I am transfering the data from lotus notes db to SQL Server db. If you need any thing I can help you.
Thank You
June 22, 2008 at 10:34 pm
i tried for ssis....i dont know what it is??? from where i can download the setup ?
is it compatible with sql 2005 express? if so pls help me step by step
June 22, 2008 at 11:34 pm
Hey,
SSIS does not come with your particular version of SQL (Express)
June 24, 2008 at 12:13 am
can i download the setup ?
is it compatible with sql 2005 express?
June 24, 2008 at 12:23 am
No you cant.
SSIS only ships with Standard and Enterprise Editions
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Upgrade...
~PD
June 24, 2008 at 7:59 am
ok..thank u...
July 23, 2008 at 4:47 am
Hi Venki,
If you could explain me how you extract data from Lotus Notes with an SSIS package that would be great.
Thanks,
Ansj
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply