Viewing 15 posts - 1 through 15 (of 26 total)
It could also be a firewall issue. Check the list below.
http://technet.microsoft.com/en-us/library/ms190181%28v=sql.105%29.aspx
Also check the native client version. Depending on the SSIS version you might need version 10.1 instead of...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 27, 2014 at 12:35 am
Don't use the instance name in the SETSPN command. Just make sure the machine name (NETBIOS and FQDN) and port is correct.
This part was giving me some headaches too in...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 26, 2014 at 2:46 pm
Always use the fixed roles of MSDB[/url] instead of granting permissions directly.
I believe for job controlling from the SQL Agent you need sysadmin permissions.
Oops I see I am in the...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 26, 2014 at 2:37 pm
In addition I found a login trigger example on the forum.
http://qa.sqlservercentral.com/Forums/Topic848826-1550-1.aspx
Make sure you understand the concept of server level triggers first before copy-pasting 😉
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 26, 2014 at 2:32 pm
From where is the package called?
If the SSIS package is called from a SQL Agent job you will need a proxy account to access the SSIS subsystem.
The article below explains...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 26, 2014 at 2:25 pm
What is the error you are getting from your package? When coded properly a File Exists in a Script Task shouldn't result into an error.
Maybe you should post the code...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 26, 2014 at 2:15 pm
I don't know TSM software. Is this some 3rd party backup software? LOG truncation is an essential feature. Without truncation your LOG files would keep on growing even if a...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
January 26, 2014 at 2:09 pm
I know this is an old topic, but I have the proposed solution. I have contacted Microsoft about this issue and we figured out the solution for this problem.
Install the...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
December 25, 2013 at 5:23 am
I run into this problem often. Databasename filter is based on the database name specified in the connection Initial Catalog. Maybe you can use a host name or application name...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
October 27, 2013 at 1:27 am
Just some additional info.
No mails are missing when using CSV as Render method. The message size is about 1 MB per mail when using PDF and seems to be a...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
October 15, 2013 at 8:56 am
Yes you can span your backup into multiple files. Check the backup database syntax in booksonline.
http://msdn.microsoft.com/en-us/library/ms186865(v=sql.100).aspx/css
Check also this page for an example.
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
October 7, 2013 at 5:53 am
Hard to say as it also depends on your indexes. My experience however is that derived tables can cause performance penalties. As soon as you filter on a derived table...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
June 12, 2013 at 4:26 am
Well I am also investigating the pros and cons of placing SSIS on the DB server.
http://qa.sqlservercentral.com/Forums/Topic1459119-391-1.aspx#bm1459772
I think most of the pro's of putting SSIS on the DB server have been...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
June 11, 2013 at 10:05 am
Thanks for your feedback. Well it's good to see that my assumptions were right.
I think we have a license for System Center Orchestrator which can handle the scheduling....
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
June 4, 2013 at 7:41 am
An ALTER needs a TABLE lock so you need to work around this.
I usually do it like this.
- First create a duplicate table based on the table that needs to...
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
June 3, 2013 at 3:18 am
Viewing 15 posts - 1 through 15 (of 26 total)