No announcements
Found 1805176 threads
-
0 VotesHow to extract data from ctree database into sql server database?
Hi, I am facing the same issue....I have CDF files generated from Ctree DB.Now i need to read them to SQL Server 2008.Can you help me ...Answered | 2 Replies | 14601 Views | Created by PCSQL66 - Sunday, April 3, 2011 10:10 PM | Last reply by known2none - Thursday, November 24, 2011 12:00 PM
-
1 Votes
automate the pdf password generation from database extract
It is OK to extract StaffID and Month Info from a database.Answered | 1 Replies | 4970 Views | Created by melodycyy - Thursday, May 17, 2012 8:16 AM | Last reply by Dummy yoyo - Monday, May 21, 2012 6:38 AM -
0 Votes
Extracting data from an encrypted SQL database
Hi WillKyle85, We can just query the data from the encrypted data from the remote server, decrypted the data, and insert the result into ...Answered | 1 Replies | 2223 Views | Created by WillKyle85 - Thursday, April 25, 2013 11:47 AM | Last reply by Allen Li - MSFT - Friday, April 26, 2013 8:01 AM -
0 Votes
extract full database from ms sql
Hi, May i know how to extract full database from microsoft sql server 2008.?Answered | 4 Replies | 1026 Views | Created by wwx12 - Monday, December 7, 2015 7:32 AM | Last reply by Charlie Liao - Tuesday, January 12, 2016 5:00 AM -
0 Votes
Automate query extract
Hi Reken, We are creating the data extract directly from the relational datawarehouse using SQL.Answered | 3 Replies | 883 Views | Created by Indrashish Saha - Friday, May 22, 2015 5:38 AM | Last reply by Reken Liu - MSFT - Monday, July 6, 2015 8:28 AM -
0 Votes
Automation with SQL
Although you can use SSRS to produce reports and export them to Excel, it is much easier to use Data options in Excel to PULL the data from the database instead.Answered | 4 Replies | 763 Views | Created by Akash Salunke - Wednesday, November 11, 2015 6:59 AM | Last reply by Tom Phillips - Wednesday, November 11, 2015 1:33 PM -
2 Votes
Extracting data from SQL Server Dataset into a class
SqlDataAdapter dataAdapter = new SqlDataAdapter( "SELECT" + " SalesPersonID, SUM(TotalDue) AS CommissionableSales" + ...Answered | 3 Replies | 1696 Views | Created by Marius Tarnat - Tuesday, June 25, 2013 9:23 AM | Last reply by Dan Guzman - Tuesday, June 25, 2013 11:36 AM -
0 Votes
Extract Data From Excel To Database Table
there are some ways in SSMS such as linked server or distributed queries,which you can use without using other tools such as ssis, biztalk, c# code + sql job etc etc.Answered | 2 Replies | 2690 Views | Created by runnerpaul - Thursday, November 15, 2012 3:09 PM | Last reply by Joon84 - Friday, November 16, 2012 12:34 PM -
0 Votes
Automating Data Sync to SQL Azure
there is no SQL Azure Data Sync API available as of the current release but it's being planned...Answered | 1 Replies | 5504 Views | Created by AlpeeJain - Friday, March 30, 2012 3:36 AM | Last reply by JuneT - Friday, March 30, 2012 4:09 AM -
1 Votes
Automate moving sql data between Azure SQL Databases
The data is coming from OTHER database.Answered | 4 Replies | 1318 Views | Created by Gaelmart2 - Thursday, March 31, 2016 11:11 AM | Last reply by Gaelmart2 - Friday, April 8, 2016 10:09 AM -
1 Votes
Extract the data from Pi to sql server
Without oledb driver you will be not able to extract any data.Answered | 2 Replies | 1803 Views | Created by Mandavas7 - Thursday, March 7, 2013 10:49 AM | Last reply by Saikat_1983 - Thursday, March 7, 2013 11:03 AM -
2 Votes
Extract data from internet
Hello, Just as other post above, you can configure the remote server as linked server on the local SQL Server instance, and then use Linked server four part ...Answered | 5 Replies | 1331 Views | Created by MalikJaved - Thursday, May 15, 2014 11:32 AM | Last reply by johnqflorida - Friday, May 16, 2014 11:56 AM -
0 Votes
Extract data trough from EPM
I wanted to add that Reporting services can extract the data and format into many common formats that other applications can use just as XML and that could be dropped into ...Answered | 3 Replies | 5704 Views | Created by Soulfly73 - Monday, January 23, 2012 9:02 AM | Last reply by Kashif Nizam - Monday, January 23, 2012 6:56 PM -
1 Votes
Extract Data from Microsoft Dynamics CRM 2011 to SQL Server 2008 using SSIS and SQL
* So in CRM 2011/4/3, the data stored in core databases i.e. centralized SQL Server.Answered | 4 Replies | 11635 Views | Created by fullmetalboy - Monday, February 27, 2012 8:38 AM | Last reply by Israel Gujjarlapudi - Thursday, March 1, 2012 2:20 PM -
0 Votes
SQL extract
Hi, we can do speedup this ...Answered | 2 Replies | 772 Views | Created by John Eberhard - Friday, July 24, 2015 8:54 PM | Last reply by manishcal16PPS - Monday, July 27, 2015 9:25 AM -
0 Votes
how to extract data from cube to data mart
But you can use a OPENQUERY to run the MDX query in SQL Query Analyzer and use the output to insert into your database table.Answered | 4 Replies | 5728 Views | Created by Farrukh Lala - Wednesday, April 13, 2011 4:10 PM | Last reply by HrvojePiasevoli - Thursday, April 14, 2011 8:01 AM -
0 Votes
Automating SQL Table data transfer
v=EfDv9dwh0I8 If you want Excel to automatically send the data to SQL Server, see the options below.Answered | 2 Replies | 809 Views | Created by PraveenKumar_1999 - Sunday, June 5, 2016 8:52 AM | Last reply by ryguy72 - Friday, June 10, 2016 1:25 PM -
0 Votes
Extracting and loading data from Zipped CSV files to a SQL database
Hi Extracting and loading data from Zipped CSV files to a SQL database As I discussed in the ...Answered | 5 Replies | 6573 Views | Created by farhad koohbor - Wednesday, October 24, 2012 1:52 PM | Last reply by ArthurZ - Monday, October 29, 2012 2:44 PM -
0 Votes
Extracting Data from SSIS
Hi I am trying to extract data from the source table and I need only a partial data in a column( similar to substring(colA,1,3) )..Answered | 3 Replies | 4544 Views | Created by AmbikaSowmyan - Wednesday, October 21, 2009 4:12 PM | Last reply by AmbikaSowmyan - Wednesday, October 21, 2009 9:01 PM -
0 Votes
SQL Query that extracts Email Data from a column
The RegexClean Transformation is available for SQL Server 2005, SQL Server 2008 (includes R2) and SQL Server 2012.Answered | 3 Replies | 1256 Views | Created by Mahesh MSBI - Monday, June 8, 2015 1:34 PM | Last reply by AV111 - Monday, June 8, 2015 2:06 PM - Items 1 to 20 of 1805176 Next ›
No announcements
