Viewing 15 posts - 31 through 45 (of 241 total)
Ok,the execution plan of my query & your solution ChrisM@Work
October 19, 2015 at 7:48 am
ChrisM@Work (10/19/2015)
USE [Global_Storage]select distinct -- is the DISTINCT really necessary?
...
yes it's quite necessairy,but also this solution brings the excution from 35 minutes to 22
1 Change
FirstOfNextMonth = CAST(YEAR(Date_) AS VARCHAR(4)) +...
October 19, 2015 at 7:27 am
John Mitchell-245523 (10/19/2015)
Please will you post the execution plan?
I'll see what I can do in the immediate future.
John Mitchell-245523 (10/19/2015)
Do you have any control...
October 19, 2015 at 3:12 am
ok,sorry for not being able to respond earlier
yes I came to the same conclusion,I just find it odd that I was no getting any errors
October 15, 2015 at 8:39 am
Ok I've used the following script to convert excel tabs/sheets into csv files.
Use a for each file loop to loop through the excel files,you can use an ado.net for loop...
October 14, 2015 at 3:40 am
I had the same issue a few weeks ago, the reason is simple,the excel source determines datatypes based on the values in the first 8 rows. IMEX on its own...
October 14, 2015 at 3:23 am
Ok I think I've found the issue,I checked the scd and look at this message
Cannot map columns of different types.
Column 'CREATED' is of type 'System.String' and column 'CREATED' is of...
September 30, 2015 at 11:32 pm
Sorry for my late response & txn Luis Cazares, your suggestion/solution allowed me to create exactly what I wanted, many txn.
September 29, 2015 at 1:39 am
I assume you might want to deal with multiple tabs that have the same makeup but differ from others.
You can generate the ssis with the import export task but you'll...
September 18, 2015 at 5:32 am
When I first saw this I was huh, and my colleague was why,but were still on an environment that's mostly 2008R2 still.
But after reading it,it makes some sense.
September 17, 2015 at 12:42 am
Environment:
*Windows Server Enterprise
*Microsoft SQL Server 2008 r2
*Microsoft Visual Studio 2008 (BiDS)
Scenario
Several application where we either can not directly connect to with SQL server or we won't get permissions for will...
September 2, 2015 at 4:51 am
We resolved this,I used an existing proxy used by some other jobs besides the fact that this proxy uses the same credentials as the default agent proxy used on this...
August 6, 2015 at 8:17 am
In the end I created a new proxy and it runs fine,only problem with the proxy is that it uses a user account that might be dropped in the future.
August 4, 2015 at 6:21 am
OK I kind of solved by doing this
var schemaList = new List<string>();
...
June 17, 2015 at 2:18 am
Phil Parkin (5/29/2015)
Resender (5/29/2015)
I set it to don't savesensitive still seeing the message popup,job itself is not failing
Just to confirm. You changed the package and the project, setting Don't Save...
June 1, 2015 at 7:59 am
Viewing 15 posts - 31 through 45 (of 241 total)