|
|
-
|
|
how to write expression for fdofmon and lastdate using sourcefiledate in ssis
sourcefilename
mothfirstdate
monthenddate
example norm
date jan2010
1/1/2010
1/31/2010
example norm
date feb 2011
2/1/2011
2/28/2011
...
|
|
-
3 Replies
| 1 Answers
| 1 Suggested
|
|
Can we set transaction log file growth upto 2 GB ? if file size 2 GB then it will automatically add new transaction log file? and can remove the primary log file?can we schedule transaction log file( .ldf)automatically add when primary log file size ful...
|
|
-
4 Replies
| 1 Answers
| 1 Suggested
|
|
Write a update or insert query in .net code with BEGIN TRANSACTION.due to some problem query execute fails and without COMMIT or ROLLBACK exception occur then this table will be lock.now, in how much time duration this table will be release without kill...
|
|
-
|
|
Hi,
I request to provide a sample one each example on ForEach Loop enumerators.
The enumerator Types are:
SQL Server Integration Services provides the following enumerator types:
Foreach File Enumerator: It enumerates files in a folder. The plus point ...
|
|
-
|
|
Can any one suggest me best hardware requirement(server machine requirement) for using sql server 2008 r2.I am going to use 3 database and reporting services on save server and will be having more than 100 user.Apart from it i want to access database fr...
|
|
-
|
|
Once I created a SSRS report, how can I go back and edit options. Like if I have selected tabular mode for display of report then how can I make it matrix....
|
|
-
|
|
Hello Experts,I need your suggestion / feedback regarding automation of database rebuild / reorganize indexes. For the frequently updated database, should i have to manually rebuild / reorganize the indexes as per the Total fragmentation or i have to ma...
|
|
-
|
|
Hello All, I have a silverlight application in which i want to bind a data table with data grid view .I am using wcf services and here is my code of service.cs page:DataTable dt = new DataTable();con.Open();SqlDataAdapter sqlDa = new SqlDat...
|
|
-
|
|
I am fairly new to the world of cursors and I have a bit of a brain teaser on my hands at the moment. I have a table which contains start times and durations of appointments. (durations vary 15 minutes to 60 minutes). What I need to do is build a tab...
|
|
-
|
|
Hello All,
Pleaes help me understand what needs to be changed in the below MDX for it to work in SSAS 2012.
We have migrated our SSRS reports from 2008r2 to 2012 and the reports using SSAS CUBE as datasource having dynamic dataset are returning empty da...
|
|