Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 15628

SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

2 votes
1 answer
11k views

sql agent job hangs without any errors or warnings [closed]

This job is executing a SSIS package which loads data from oracle (source) to SQL SERVER 2008R2 (destination) Steps Taken to Resolve issue 1) I thought the ssis package is losing connection in the middle …
oOo Testing1 oOo's user avatar
3 votes
2 answers
10k views

Average Time to Load 1.2 million records from Oracle INTO SQL SERVER 2008R2

I have an ssis package which loads 1.2 million records of data from oracle into SQL SERVER 2008R2(with 32 GB RAM) dataware house table once every week. … I am new to ssis. Please advice me. Is 5 hours an optimum time ?? Note: the destination table is de-normalized and no indexes are there on it because it is in the dataware house. …
oOo Testing1 oOo's user avatar