No announcements
Found 1962268 threads
-
0 Votes
Pull data from WADWindowsEventLogsTable
have a look at the Azure Data Factory or use the Table Storage API directlyAnswered | 3 Replies | 1318 Views | Created by Manoj Deshpande - Sunday, January 25, 2015 11:14 AM | Last reply by JuneT - Tuesday, January 27, 2015 1:56 PM -
0 Votes
Data pull from SAP ECC to Sql Server
SAP R/4 and Microsoft SQL Server 2014 (X64) Enterprise Edition (64-bit) (Build 7601: Service Pack ...Answered | 3 Replies | 1095 Views | Created by GiuseppeSerra - Tuesday, March 7, 2017 5:00 PM | Last reply by ArthurZ - Thursday, March 9, 2017 8:26 PM -
0 Votes
How to pull sql data from non-sharepoint database?
you can pull by using SSRS or BDC.Answered | 5 Replies | 5038 Views | Created by Avian123 - Wednesday, September 8, 2010 10:05 AM | Last reply by Dave Hunter - Wednesday, September 8, 2010 2:39 PM -
0 Votes
SSIS 2014 - Best way to use parameters to extract data from sources
So the best method to achieve your requirement is still using SQL COMMAND FROM VARIABLE option as Data access mode.Answered | 4 Replies | 1020 Views | Created by Pedro Samuel - Friday, March 27, 2015 4:52 PM | Last reply by Pedro Samuel - Tuesday, March 31, 2015 9:42 AM -
0 Votes
SQL Source question
You can create a linked server from S1 to S2 and return the data in the below way SELECT <columns> FROM S2.dbname.dbo.tblname ...Answered | 1 Replies | 2337 Views | Created by duffy202 - Wednesday, August 3, 2011 11:53 AM | Last reply by Uri Dimant - Wednesday, August 3, 2011 11:56 AM -
1 Votes
Pulling source code using TortoiseHg is aborting
Weird, because I have just pulled out all the source codes on a fresh Win7 test box without any issues.Answered | 15 Replies | 19278 Views | Created by Rob van der Ent - Sunday, July 17, 2011 6:40 AM | Last reply by Rob van der Ent - Tuesday, August 2, 2011 3:40 AM -
1 Votes
Attunity Oracle Source - select with a parameter
Everybody is suggesting this way if you want to use parameters in Oracle query but nobody mention about the Oracle source and output columns.Answered | 6 Replies | 10879 Views | Created by AntonioCH - Thursday, September 3, 2009 9:52 AM | Last reply by joffrey22 - Friday, May 11, 2018 1:01 AM -
0 Votes
Pulling Data from two tables
If you are asking how to do a Transact-SQL query to pull data from multiple tables, do a SELECT with a join, for example: SELECT PM20000.SomeColumn, ...Answered | 2 Replies | 14030 Views | Created by Siele - Tuesday, September 14, 2010 11:20 AM | Last reply by Compiler001 - Thursday, October 28, 2010 1:20 PM -
0 Votes
datetime parameter against Oracle data source
Which data type have you used for the parameters?Answered | 3 Replies | 1308 Views | Created by thotwielder - Friday, February 28, 2014 12:01 PM | Last reply by Olaf Helper - Saturday, March 1, 2014 8:41 AM -
0 Votes
Need Information on pulling data from Oracle Source to SQL Server
Hi, I was told that we will be extracting data from Oracle database and loading into SQL Server Database.Answered | 1 Replies | 4742 Views | Created by sami09 - Wednesday, September 8, 2010 3:09 PM | Last reply by Manish Sharma - ETL - Wednesday, September 8, 2010 3:27 PM -
0 Votes
Pulling Excel Data into SQL Server
You can go through below link for implementation http://amittomars.blogspot.sg/2015/11/how-to-export-data-from-sql-server.html For automation ...Answered | 6 Replies | 1007 Views | Created by ChapWolff - Tuesday, December 15, 2015 12:03 AM | Last reply by ryguy72 - Tuesday, December 22, 2015 5:27 AM -
2 Votes
XML Source to SQL data flow
The ID field isn't pulling through though to the other tables before copying over the data.Answered | 15 Replies | 4042 Views | Created by VinnyClegg - Tuesday, August 8, 2017 3:00 PM | Last reply by Russ Loski - Thursday, August 10, 2017 1:41 PM -
0 Votes
Multiple data sources in data flow source?
I want to access more than one connection manager from the same query same data flow task same data flow source.Answered | 6 Replies | 934 Views | Created by rpfinn - Monday, April 7, 2014 1:57 PM | Last reply by Mike Yin - Monday, April 14, 2014 3:28 PM -
3 Votes
Visual Studio - SQL data source
Hello Ronen, Here Is my query im using to pull the data for the datasource.Answered | 6 Replies | 1269 Views | Created by AndrewCasinoMan - Friday, February 13, 2015 4:20 PM | Last reply by pituach - Friday, February 13, 2015 7:37 PM -
4 Votes
Pull data from SQL Table and display it in mail
Here in the Code, import the Data from table and loop through data to form a specific format and send the Mail with HTML Format as true.Answered | 8 Replies | 4059 Views | Created by Neilcse - Wednesday, September 17, 2014 5:48 PM | Last reply by Aamir Shahzad Warraich - Friday, September 19, 2014 3:17 PM -
0 Votes
Location of Data Source & Data Source View in MS SQL Server 2008
Actually sql server stores the "Data Connections" Info any where.Answered | 11 Replies | 4975 Views | Created by Brijendra Pandey - Wednesday, June 22, 2011 2:17 PM | Last reply by Vinuthan - Wednesday, June 29, 2011 12:24 PM -
0 Votes
pull the data from Azure sql and load into the on premises data base
I want to create one ETL jobs, it use to handle the Incremental data in Azure Sql portal..Answered | 3 Replies | 851 Views | Created by Priya.N - Tuesday, May 5, 2015 12:45 PM | Last reply by Priya.N - Wednesday, May 6, 2015 9:38 AM -
0 Votes
Visual Studio 2013 SSIS data flow OLE source not mapping parameters
The following blog is for your ...Answered | 8 Replies | 1472 Views | Created by MayBoy - Monday, November 30, 2015 3:53 AM | Last reply by Katherine Xiong - Thursday, December 10, 2015 2:10 AM -
0 Votes
How to pull query that contains input parameters?
Hello SQL experts, I have a quick question; is there a way to pull up information that contains certain input parameters?Answered | 2 Replies | 3414 Views | Created by kurobenko - Friday, August 28, 2009 8:19 PM | Last reply by kurobenko - Friday, September 4, 2009 6:32 PM -
0 Votes
Pulling data from Oracle with SSIS
Can you set the Delayed Verification to True for the connection manager tagged to Oracle Source and post back with the results here again ?Answered | 2 Replies | 928 Views | Created by lilutchay - Tuesday, July 7, 2015 7:55 AM | Last reply by Milan Das - Tuesday, July 7, 2015 8:49 AM
No announcements