Viewing 15 posts - 1 through 15 (of 44 total)
Found the issue. It is indeed a bug with SQL Server. I found this KB article (https://support.microsoft.com/en-us/kb/3008000) that described my exact error message even though the KB article only talks...
April 30, 2015 at 12:26 pm
Found something interesting. I imported the package into the msdb and created an agent job for it. It runs successfully! I wonder if there is a bug using the SSIS...
April 29, 2015 at 2:55 pm
Nevyn (4/29/2015)
Are you executing as 32 bit or 64 bit?
32bit. Thinking it might be something weird with the drivers on my system I installed SSDT right on the test server...
April 29, 2015 at 1:35 pm
Nevyn (4/29/2015)
Are you executing right from the catalog or from an agent task or from a query?
Agent Task. Right now I am leaning towards a dll issue on the server.
April 29, 2015 at 1:00 pm
Koen Verbeeck (4/29/2015)
tfendt (4/28/2015)
I am using the new 2012 Integration Services Catalog with Project deployment. I can run...
April 29, 2015 at 7:52 am
Jeff Moden (4/29/2015)
tfendt (4/28/2015)
I am using the new 2012 Integration Services Catalog with Project deployment. I can run...
April 29, 2015 at 7:51 am
dwain.c (3/26/2015)
If the FEES are dynamic, I presume you'd like to see a separate column in the results set for each?
You would then need to build the query up using...
March 30, 2015 at 8:14 am
This works :). One thing I forgot to mention however is the fees are dynamic and not just limited to BFee and Holding, is it possible to modify it to...
March 26, 2015 at 9:07 am
I assume no response means theses are still the only options.
March 19, 2015 at 9:06 am
We have our SSRS DBs in an A/A configuration and they work well. The only gripe I have about it is the nasty SQL Agent jobs that SSRS report subscriptions...
March 18, 2015 at 2:57 pm
We do the same thing as JeremyE. With SQL 2012 you need the engine if you plan on using the SSIS Catalog as you now do all your managing of...
March 18, 2015 at 2:30 pm
Great article, I will give this a try! I am currently using Data Loader to export to csv once an hour then I have a SSIS package to take the...
October 1, 2014 at 10:43 am
Since you are new to SQL I would recommend using the SQL Maintenance Plan Wizard to set up your backups. It is easy to use and setup for doing basic...
August 5, 2014 at 2:50 pm
I am monitoring the servers and DBs with SQLSentry, the numbers I am reporting are actual not averages. I also ran queries against dmv's and perf-mon counters assuming what SQLSentry...
August 5, 2014 at 8:22 am
You are only looking at a portion of total memory usage. I would bet that the 9GB is for plan cache or just free memory.
This site has a great script...
August 4, 2014 at 2:38 pm
Viewing 15 posts - 1 through 15 (of 44 total)