May 29, 2012 at 1:52 am
I have a working package in sql2005, i want import to sql2012.
I add this package in project of BI.
In a project package is worked.
I added this package to sql server agent job and get error.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:43:42 Error: 2012-05-29 11:43:46.30 Code: 0x00000001 Source: Script Task Description: Exception has been thrown by the target of an invocation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:43:42 Finished: 11:43:46 Elapsed: 3.494 seconds. The package execution failed. The step failed.
The user has access to the file. In package have script task who generate beautiful header on excel file. Likely error caused by Workbooks.Open().
How to solve the problem?
May 30, 2012 at 5:16 am
Did you convert the script task first?
There are some changes between 2005/2008/2012 regarding the scripting of .NET code in SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 14, 2012 at 3:30 am
I found solution this problem.
Create directory
C:\Windows\SysWOW64\config\systemprofile\Desktop or C:\Windows\System32\config\systemprofile\Desktop depending on x64 or x86
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply