Viewing 15 posts - 646 through 660 (of 2,051 total)
source data is on another server ?
More like a linked server setup (run package on server A to access data from server B)?
September 9, 2015 at 3:29 am
I have something like this
/****** Object: ProxyAccount [proxySSIS] Script Date: 8/09/2015 16:12:43 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.sysproxies WHERE name = N'proxySSIS')EXEC msdb.dbo.sp_add_proxy @proxy_name=N'proxySSIS',@credential_name=N'SSISProxyCredentials',
@enabled=1,...
September 8, 2015 at 8:16 am
localhost\instancename
localhost\port
(see ms sql server configuration manager)
is ms sql server browser service running?
September 7, 2015 at 4:59 am
Check on runtime settins like dateformat for datetime string conversions?
What is the output format of the report? html vs excel ...
August 27, 2015 at 9:19 am
CPU's disabled in BIOS?
August 25, 2015 at 6:44 am
August 24, 2015 at 8:22 am
sp_whoisactive
sp_who2
sp_lock
August 24, 2015 at 5:55 am
Hello,
You don't have to copy the snap-in line, only the code between
public void Main()
{
....
Dts.TaskResult = (int)ScriptResults.Success;
...
August 18, 2015 at 7:41 am
Did you try a reboot after installing the oracle clients?
Is the oracle client the latest from oracle support?
August 17, 2015 at 8:21 am
What happens if you place the package in a subfolder like c:\packages\ram.dtsx?
August 10, 2015 at 4:34 pm
Got away with changing the connection from native oledb Microsoft Ace... to .NET Provider/Microsoft Ace...
Seems to work in the script component and sufficient for the small excelfiles.
August 5, 2015 at 9:21 am
There is likely a more detailed error description if you click it open.
Example
Executed as user: X\Y.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.5592.0 for 64-bit Copyright...
August 5, 2015 at 5:13 am
Does the sql agent job account have rights on C:\Ram.dtsx? (on the sql server)
August 5, 2015 at 4:41 am
I was misinformed, SA not needed for downgrade ( volume licensing? )
May 22, 2015 at 5:10 am
Viewing 15 posts - 646 through 660 (of 2,051 total)