Viewing 15 posts - 286 through 300 (of 9,641 total)
Grant Fritchey (8/31/2015)
August 31, 2015 at 7:24 am
Brandie Tarvin (8/26/2015)
August 26, 2015 at 8:25 am
Sean Lange (8/20/2015)
August 20, 2015 at 7:42 am
Ed Wagner (8/20/2015)
Now that part is kinda funny. Not that you spent an hour on it, but that it'll do an implicit cast sometimes but not all the time.
Granted,...
August 20, 2015 at 7:36 am
Sean Lange (8/19/2015)
Luis Cazares (8/19/2015)
Sean Lange (8/19/2015)
August 19, 2015 at 9:13 am
Not a licensing guru at all, but according to this, https://support.microsoft.com/en-us/lifecycle#gp/gp_lifecycle_servicepacksupport:
When support for a product ends, support of all the service packs for that product will also end. The product’s...
August 17, 2015 at 11:39 am
cory.bullard76 (8/17/2015)
,max(case when patins.rank = 1.0 then CLAIMS.[TOTALPAID] else '' end)
TotalPaid is a field that contains, for example, 445.45
The...
August 17, 2015 at 11:21 am
Kummu (8/15/2015)
SQL job owner is sa and running with SQL server service account
Sounds like the service account SQL Server Agent is running under doesn't have permissions to access service control...
August 17, 2015 at 6:59 am
Don't think so as Bulk Load is a SQL Server function.
August 14, 2015 at 1:36 pm
Sounds like a permissions issue to me. What is the security context that you are running job step under?
August 14, 2015 at 1:32 pm
vipin_jha123 (8/13/2015)
Hi Below is me expression@[$Package::V_FilePath] +"MD_GEOGRAPHYLEVELXREF_"+ @[$Package::V_Zone] +".txt"
H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELXREF_US.txt
I am looking to have path like
H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Outbound\MD_GEOGRAPHYLEVELXREF_US.txt
I want fit outbound in my expression.
regards,
Vipin Jha
Well, you have 2 options:
1. Add that...
August 14, 2015 at 1:28 pm
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.😎
But you didn't do it MY way on MY setup, so...
August 14, 2015 at 12:11 pm
Lynn Pettis (8/13/2015)
Jack Corbett (8/13/2015)
Lynn Pettis (8/13/2015)
August 13, 2015 at 2:49 pm
Lynn Pettis (8/13/2015)
August 13, 2015 at 2:26 pm
I would do a separate database because:
1. Separation of processes
2. Faster recovery time of the Data Warehouse because the stage data is not in the Data Warehouse.
3. You typically will...
August 13, 2015 at 2:12 pm
Viewing 15 posts - 286 through 300 (of 9,641 total)