Data Warehousing :: How To Use Temporary Table In SSIS
Jul 23, 2015How to use temporary table in SSIS ?
View 2 Replies
ADVERTISEMENT
Data Warehousing :: Run Stored Procedures On PDW Via SSIS
Aug 4, 2015How do you run a stored procedure on PDW via SSIS? I've tried Execute SQL Task and Execute T-SQL Task but in both cases the task will run and complete almost immediately. Task shows success, no errors, but nothing happens in PDW. PDW admin console does not even register the query. Procedures run fine manually from SQL Server Object Explorer connection.
View 3 Replies View RelatedData Warehousing :: How To Use Stored Procedures In SSIS
Jul 23, 2015How to use Stored Procedures in SSIS?
View 2 Replies View RelatedData Warehousing :: Running SSIS Package As Server Agent
Nov 23, 2010My package is connecting to an external data provider using an OLEDB driver . The package runs fine in debug mode.When i tried to run the same from SQL server agent it failed to aquire the connection. The OLEDB provider does not contain too much of information , ( connection string, initial catalog, blank user name and password).The same package executes successfully if i run using dtexec in BAT file.But if i use the dtexec in sql server job step as operating system command and try to run, the job will fail reporting " can not aquire the connection".
View 2 Replies View RelatedData Warehousing :: Variables In SSIS For Setting Any Connection String
Mar 19, 2014"variables in SSIS for setting any connection string". I tried to Google it but cannot find any specific link.
View 4 Replies View RelatedData Warehousing :: Use New Table With Reduced Structure?
Aug 24, 2015I have a large fact table spread across tens of partitions (appx. 1TB each). I found that the business does not need much of the columns in the table. So, as an optimization action, I decided to get rid of these un-needed columns.What is the efficient way to achieve this? Can I simply drop these columns from the table, or use a new table with the reduced structure?
View 2 Replies View RelatedData Warehousing :: Querying In Fact Table
May 2, 2015I have a Fact Table with a ID column as Primary key and clustered index is created. And also I have 4 dimensions FK's of data type INTEGER. And finally, I have one aggregation measure in the Fact Table.
Now, my situation is How can I improve the speed of querying the fact table by creating any of the below indexes?
1. XML
2. Spatial
3. Clustered
4. Non-Clustered
Data Warehousing :: Adding A New Column From Table To View
Nov 2, 2015I have a SQL VIEW with col1, col2, col3. I need to add a new column to the view col4 coming from a TABLE in SQL Server.
View 4 Replies View RelatedData Warehousing :: Hiding Text Box Based On Table Property
Oct 16, 2015I am putting together an invoice for my company. I have a text box describing each section of the invoice, followed by a table to list out the charges. I am using multiple tables based on what type of charge the client is receiving.
I would like to hide each section if there are no items purchased of that type. I can do this with the table using the expression "=CountRows() < 1", but I do not know how to refer to that table (call it Tablix1 for the sake of discussion) for the text box. I've tried using a ReportItems function as my basis, without success.
Data Warehousing :: Creating A Table With Column Store Index?
Sep 26, 2015I am trying to create a sample table in the Azure SQL Data warehouse but its giving me a syntax error Incorrect syntax near the keyword 'CLUSTERED'.
CREATE TABLE [dbo].[FactInternetSales]
( [ProductKey] int NOT NULL
, [OrderDateKey] int NOT NULL
, [CustomerKey] int NOT NULL
, [PromotionKey] int NOT NULL
[Code] ....
what's the correct syntax
Data Warehousing :: Populating Fact Tables With Surrogate Key From Dimension Table?
Sep 11, 2015How do I correctly populate a fact table with the surrogate key from the dimension table?
View 4 Replies View RelatedData Warehousing :: Will Creating Partitions On Table Increase Insert Speed
Oct 8, 2015I have table having around 100 million rows.Everyday we have an ETL process in which table will be trucnated and relaoded. Will creating a partition on the table increase the inserting speed?
View 4 Replies View RelatedIs It Possible To Insert Data Into A Table From A Temporary Table That Is Inner Join?
Mar 10, 2008Is it possible to insert data into a table from a temporary table that is inner join?
Can anyone share an example of a stored procedure that can do this?
Thanks,
xyz789
Denormalize Data In A Temporary Table
Jul 20, 2005hello group,i want to denormalize data in a temporary table for a secondbusiness-system which cant read related dataswhat i have:table Partner: (Id_Partner, NamePartner, ...)table PartnerProduct: (Id_PartnerProduct, NamePartnerProduct, ...)table Partner2PartnerProduct: (Id, Id_Partner, Id_PartnerProduct)Partner to PartnerProduct ist n:m relation (thats why i needPartner2PartnerProduct)and the temporary tableTempPartner: (Id_Partner, NamePartnerProducts)whereas NamePartnerProducts should contains a comma separated list ofthe PartnerProduct-Nameswhat i need:a trigger or combination of trigger and SP whichoperate like the following:if on Partner2PartnerProduct is a Insert or Update made, then Deletethe row in TempPartner which has the Id of the Partner, and thencreate a new row which contains all n:m joined PartnerProduct-Names init.i hope the intention and problem are clear.thanx for answers,hans
View 1 Replies View RelatedInserting Data Into A Sybase Temporary Table
Aug 2, 2007I'd like to select data out of an oracle table, and UPDATE a sybase table. So far I've got as far as the following:
1. create a package
2. add 2 connection managers, set retainsameconnection=true on both just to be sure.
3. add an executesql command which creates a temporary table
create table #temp_wm ( instru_id int)
4. add a dataflow task with:
i) an oledb source with a select statement: "select instru_id from mytable"
ii) an oledb destination with open rowset: #temp_wm
added an external column called instru_id in the inputs and outputs tab
when i run, the create temp table task work, the select works, but the insert into fails. If I change the select statement to:
"select instru_id from mytable where 1=0" it all executes fine.
So everythings copacetic as long as i don't need to actually insert any real records = brilliant!
1. HAS ANYONE OUTTHERE SUCCESSULLY USED SSIS TO INSERT DATA INTO A SYBASE TEMPORARY TALBE - MAYBE ITS JUST NOT POSSIBLE??
2. Any idea how I can fix my setup?
I'm usign Sybase ASE OLE DB Drivers
Note: i also tried ## temp tables, no difference.
This is the error output.
[OLE DB Destination [255]] Error: An OLE DB error has occurred. Error code: 0x80004005.
[OLE DB Destination [255]] Error: The "input "OLE DB Destination Input" (268)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (268)" specifies failure on error. An error occurred on the specified object of the specified component.
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (255) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Reseeding Temporary Tables Or Table Data Types With Identity Column
Feb 17, 2006Hi,
I have a indexing problem. I have a sequence that needs to has a index number. I want to use a table data type and have a working sample BUT I cannot reseed the table when needed. How do I do this.
This works only for the first ExitCoilID then I need to RESEED.
Here is my code:
DECLARE
@EntryCoilCnt AS INT,
@ExitCoilID AS INT,
@SubtractedFromEntyCoilCnt AS INT
DECLARE
@ExitCoilID_NotProcessed TABLE
(ExitCoilID int)
INSERT INTO @ExitCoilID_NotProcessed
SELECT DISTINCT ExitCoilID
FROM
dbo.TrendEXIT
where
ExitCoilID is not null and
ExitCnt is null
order by
ExitCoilID
DECLARE
@ExitCoilID_Cnt_Index TABLE
(ExitCoilID int, ExitCnt int IDENTITY (1,1))
IF @@ROWCOUNT > 0
BEGIN
DECLARE ExitCoilID_cursor CURSOR FOR
SELECT ExitCoilID FROM @ExitCoilID_NotProcessed
ORDER BY ExitCoilID
OPEN ExitCoilID_cursor
FETCH NEXT FROM ExitCoilID_cursor
INTO @ExitCoilID
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO @ExitCoilID_Cnt_Index
SELECT ExitCoilID
FROM dbo.TrendEXIT
WHERE
ExitCoilID = @ExitCoilID
ORDER BY
EntryCoilID, Cnt
select * from @ExitCoilID_Cnt_Index
--truncate @ExitCoilID_Cnt_Index
--DBCC CHECKIDENT ('@ExitCoilID_Cnt_Index', RESEED, 1)
FETCH NEXT FROM ExitCoilID_cursor
INTO @ExitCoilID
END
CLOSE ExitCoilID_cursor
DEALLOCATE ExitCoilID_cursor
select * from @ExitCoilID_Cnt_Index
END --IF @@ROWCOUNT <> 0
Data Warehousing :: Query That Extracts Email Data From A Column
Jun 8, 2015I have a column in which Email data is available like
clicuanan@aspenms.com(M)
jteply@mac.com(M)
How to extract in the below format
clicuanan@aspenms.com
jteply@mac.com
tjones@jpmc.com
Data Warehousing
Aug 15, 2000I am preparing for the exam anybody know of any braindump sites that have data
warehousing braindumps?
DATA WAREHOUSING
Jun 17, 2000Hello,
I am new to SQL Server. I want to know about DATA WAREHOUSING AND OLAP. Please help me.
Data Warehousing
Mar 30, 2001Can anyone suggest a good resource that outlines data warehouse solutions using SQL 7.0 or higher?
View 1 Replies View RelatedData Warehousing Dev. Help
Apr 5, 2007Hi,
I need to implement/set up the Data warehouse/Data mart in one of the department in my company by using SQL server 2005. Do any body knows the steps what I need to follow?
It will be more appreciate that, if any body gives some of the links which will help me to do the implementation/development of the same.
I do have the basic idea however I may face some of the difficulties when I start such as, does the SQL server reporting service allow the end user to customize the report based on their needs etc.?, so any of them having experience in this field please reply me.
Thanks
Ajith Nair
Data Warehousing :: How To Represent Metadata In A Data Warehouse
Sep 24, 2015I am working on to create a data warehouse. I have made a database which will be the data warehouse and will consist of dimension and fact tables. I know that other than dimension and fact table a data warehouse should also consist of a meta data, now my question is what should be the structure of metadata and all the information it should have?
View 2 Replies View RelatedData Warehousing Resources
Sep 20, 2002Hi:
I am planning to give the microsoft 70-019 data warehousing exam. I am not able to find any good resources to prepare for the exam. Please help!
Thanks in advance
Data Warehousing Design
Jan 9, 2006Hi
We are starting with designing a datawarehouse for my company. I have done some reading on the concepts and steps involved, but what I am seriously lacking is some examples. I'd like to read through some real examples of data warehouses that worked including the full design diagrams.
Can anyone direct me to some good sites for this?
Thanks,
TeaaZA
Need Tech Information About DTS On Data Warehousing
May 12, 2004Hello, everone:
Anybody can offer technical information about DTS appied in data warehousing? Website, tutorial, forum and books will be great. Thanks.
ZYT
Data Warehousing :: Generating STATISTICS (Automation)
Jul 21, 2015Is it possible to write a SP (Automate) to generate STATISTICS on any database and then use the output to create the stats on that database.
I ran the tuning adviser and it suggested indexes with lot of STATISTICS on the dev environment. This dev environment is replicated in several other environment with data size in these environment varying. I would like to know if I can create a SP which generates STATISTICS information pertaining to specific database environment for the query in question for tuning.
Data Warehousing :: Add Parameter To Cube From Report
Aug 11, 2015SSRS : I want to add parameter to my Cube from report is generating ...
View 5 Replies View RelatedData Warehousing :: Dimension With Over 330M Records / Need Of Updates
Jun 22, 2015I have a table that is increasing quite largely each day. By now, I have average 300 million of records over 2.5 years. Before we received our new interface, the data we received was aggregated and thus not that big.The problem is that the table is so huge that I cannot use the Slowly Changing Component. I was thinking about making a temp table where I load the incremental data before I load it into the final data mart table.Based on this temporary table I use a script to compare the temp data with the already existing data in the data mart. However, this requires a compare of each records (300 mil records).
View 3 Replies View RelatedData Warehousing :: Can Use Dimensional Model For OLTP System?
Jul 9, 2015Question: Is it feasible to use a star schema dimensional model for an OLTP system that incurs few (750 per day)Sales Orders transactions?
Background: My customer wants to replace an existing OLTP system database because it runs on Oracle and their in-house expertise is in SQL Server. The original database developers that designed the Oracle DB have apparently retired. The Oracle database has been over-normalized, to say the least. The number of sales orders being entered daily is small: about 500-750 per day. These entries are done at the five clerks' convenience, from a paper form, and are very unlikely to ever be entered in quick succession. Nothing else gets regularly entered into this database except for the occasional change to a customer, but new customers are very few and far between.
I've designed a star schema for the replacement database with the Sales Order Header and Sales Order detail table combined into a single 'fact' table, and I've introduced some duplication into dimension tables (like customer) in order to eliminate some of the joins (and confusion) that were built into the original database.
I've never tried this before. Is there any reason this would not or should not work?
Data Warehousing :: Find CDC Enabled Time In Database
Aug 11, 2015How to find the CDC enabled date and time in database.
View 3 Replies View RelatedData Warehousing :: ETL Package Execution Error In Processing
Sep 25, 2015ETL Packages are getting failed sometimes(Package Execution Error). Eventhough executing ETL Package again from start, getting the same Error. But after Restarting Sql Service in BI Server, it is working fine. Whether it is the issue from Developer Code side or from server side.
View 7 Replies View RelatedData Warehousing :: Bulk Update With Server And SAP BODS
Oct 16, 2015I'm having issues with bulk update in SQL Server.I'm using SAP BODS as ETL tool and have some 20000 updates.target table has approx 0.5 million records and it has clustered index on id column.I have selected upsert option in BODS.Same setup is also done for Sybase IQ , IQ has bulk update option which is giving very ood performance.
In IQ same update load is finishing in some 9 minutes where SQL is taking more than 2 hours for same, this doesn't seem right.When I look at update is causing whole package to go slow.Sybase is creating query where is ID is present then do update else insert.Is there any way to make bulk update work faster in SQL environment?
Data Warehousing :: How To See Text Of Query Involved In Deadlock
Sep 6, 2015How to see text of the query involved in deadlock ?
View 2 Replies View Related