ETL Simulation
Jul 10, 2007
Hi Everyone,
I am developing a small data warehouse using SQL Server 2005 Express. I need to export data from other databases one a day. I understand Integration Services is not included in Express, but is there another way to simulate an ETL? All I basically have to do is query 3 different databases and copy that data to the data warehouse but first truncate the tables. Any ideas how I can accomplish this? SQL script? Stored Procedure?
Thank You
-Sam
View 4 Replies
Nov 8, 2007
Hi! I hope this is not a stupid question ...
I'd like to "simulate" multivalue report parameters in t-sql. Background is, that I'm developing statements for report datasets with management studio for convinience. The statements need to apply a filter based on a report parameter like this:
select a, b, c
from datasource
where a in (@listofitems)
Which works great in reporting services, since @listofitems is converted to 'item1', 'item2', ... by reporting services. I tried to simulate the parameter by using:
declare @listofitems as varchar(100);
set @listofitems = '''Item1'', ''Item2''';
Unfortunatley it doesn't work as I expected. Has anybody had the same issue?
Cheers,
Martin.
View 8 Replies
View Related
Mar 11, 2007
Hi
I need Help
I use batch code like below model:
Project1 in vb.net
call spA1
call spA2
....
Project2 in vb.net
call spB1
call spB2
....
spA1 & spA2 & spB1 & spB2 are stored procedures in SQL Server 2005
I need a solution like semaphore:
when project1 is run and process in spA1 & spA2, then project2 can't access resource of spB1 & spB2.
when project 1 is done then project 2 is run
these projects should work like semaphore method.
I want to use semaphore method in this case.
using SPs: 1. sp_getapplock & 2. sp_releaseapplock
please give me another solution for safely processing.
thanks alot
View 1 Replies
View Related
