<div>
Open the package in SSDT, go to the dataflow module involved, open the flat file connector. Get it to read the file and show you a correct preview - deliberately change the format to, say, fixed width and then back to the correct format and be sure that the data can be seen correctly. Reset the columns and save the task. Save the package and re-deploy it. It should now be a 64-bit 2012 package and should work. <br />
<br />
hth<br />
<br />
Mike
</div>


<div>
Thanks very much for your response.<br />
<br />
We tried out what you mentioned, bu it didn't work. Actually the problem seems to be with the script component, the InputBuffer Row returns NULL in 64 bit execution, If we execute in 32-bit, it is working.<br />
<br />
Is there any solution to fix the script component issue that are migrated from 2008 to 2012?
</div>


<div>
Could you post more info about the job? &nbsp;For example, a screengrab of the SSIS control and data flows would help with context! Your error very clearly states that it is a Flat File source generating the problem, not a script task, which you didn't mention before. &nbsp;<br />
<br />
Are you building the package on a 32-bit machine and then trying to run it on a 64-bit machine, by any chance (you might get the wrong library code included). <br />
<br />
One other question: is it actually absolutely necessary to run it in 64-bit mode? Some things just don't, like the Excel I/O ! &nbsp;It may be a lot easier for you just to accept this one as a 32-bit package.<br />
<br />
hth<br />
<br />
Mike
</div>


<div>
keep 32 bit execution and move on
</div>


<div>
Excel error 64-bit version of SSIS<br />
<a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/289e29ad-26dc-4f90-bad4-ffb86c76e5f9/excel-error-64bit-version-of-ssis" rel="ugc nofollow">https://social.msdn.microsoft.com/Forums/sqlserver/en-US/289e29ad-26dc-4f90-bad4-ffb86c76e5f9/excel-error-64bit-version-of-ssis</a><br />
<br />
The Excel Connection Manager is not supported in the 64-bit version of SSIS<br />
<a href="https://merlecarr.wordpress.com/2011/02/12/the-excel-connection-manager-is-not-supported-in-the-64-bit-version-of-ssis/" rel="ugc">https://merlecarr.wordpress.com/2011/02/12/the-excel-connection-manager-is-not-supported-in-the-64-bit-version-of-ssis/</a><br />
<br />
How to solve SSIS error code 0xC020801C/0xC004700C/0xC0<wbr />047017<br />
<a href="http://www.codeproject.com/Articles/534651/HowplustoplussolveplusSSISpluserrorpluscodeplus-xC" rel="ugc">http://www.codeproject.com/Articles/534651/HowplustoplussolveplusSSISpluserrorpluscodeplus-xC</a>
</div>


<div>
Eugene7: s vapv is not using Excel for import, but a flat file connector (see text of error message and his original statements). However, if he is having problems with a script task then he may be using some included code that is 32-bit-only ... hence my suggestion that he consider remaining as a 32-bit operation if possible.<br />
<br />
hth, &nbsp; s vapv,<br />
<br />
Mike
</div>


<div>
yes, it is correct<br />
32 bit is still SSIS friend
</div>


<div>
&quot;yes, it is correct<br />
32 bit is still SSIS friend&quot;<br />
<br />
Looks like you were in a hurry there. Could you explain please? <br />
<br />
thx, Mike
</div>


<div>
please, see the posted above links, even some for excel - but they are self explanatory, unless you are asking for some specifics that would need this SISS &nbsp;be reviewed in a SSDT, check what sql server edition was used to develop this SSIS (64 -32 bit), what office tool, what sql service, pack, was it upgraded, etc. &nbsp; Even maybe redesign starting by generation a New SSIS via Export\import.. <br />
as you know, EE has limits to see the requestor &nbsp;screen and read mind.<br />
If it is what you are asking.<br />
<br />
Thx
</div>


<div>
Thanks for all your suggestions.<br />
<br />
Yes, it was developed in 32-bit and we are trying to migrate it to 64-bit. As mentioned, the script component is the one creating the problem. We are using flat file connector and not excel, but the flat file source is csv. I understand that there could be a problem with any of the underlying components that is used in the script, maybe any of it is using 32- bit still. The script component is called for errored out rows in the flat file.<br />
<br />
The script component &nbsp;has the below code<br />
<br />
<i>/* Microsoft SQL Server Integration Services Script Component<br />
* &nbsp;Write scripts using Microsoft Visual C# 2008.<br />
* &nbsp;ScriptMain is the entry point class of the script.*/<br />
<br />
using System;<br />
using System.Text;<br />
<br />
[Microsoft.SqlServer.Dts.P<wbr />ipeline.SS<wbr />ISScriptCo<wbr />mponentEnt<wbr />ryPointAtt<wbr />ribute]<br />
public class ScriptMain : UserComponent<br />
{<br />
&nbsp; &nbsp; #region Constant Varibles<br />
&nbsp; &nbsp; StringBuilder sbExceptionMail= new StringBuilder();<br />
&nbsp; &nbsp; string strErrorDescription = string.Empty;<br />
&nbsp; &nbsp; string strFileName = string.Empty;<br />
&nbsp; &nbsp; #endregion<br />
&nbsp; &nbsp; public override void PreExecute()<br />
&nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; base.PreExecute();<br />
&nbsp; &nbsp; &nbsp; &nbsp; /*<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Add your code here for preprocessing or remove if not needed<br />
&nbsp; &nbsp; &nbsp; &nbsp; */<br />
&nbsp; &nbsp; }<br />
<br />
&nbsp; &nbsp; public override void PostExecute()<br />
&nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; base.PostExecute();<br />
&nbsp; &nbsp; &nbsp; &nbsp; /*<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Add your code here for postprocessing or remove if not needed<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; You can set read/write variables here, for example:<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Variables.MyIntVar = 100<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; */<br />
&nbsp; &nbsp; &nbsp; &nbsp; Variables.vExceptionLogErr<wbr />orMail = sbExceptionMail.ToString()<wbr />;<br />
&nbsp; &nbsp; &nbsp; &nbsp; //MessageBox.Show(sbExcept<wbr />ionMail.To<wbr />String());<wbr /><br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; }<br />
<br />
&nbsp; &nbsp; public override void Input0_ProcessInputRow(Inp<wbr />ut0Buffer Row)<br />
&nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; Row.ErrorDescription = ComponentMetaData.GetError<wbr />Descriptio<wbr />n(Row.Erro<wbr />rCode);<br />
&nbsp; &nbsp; &nbsp; &nbsp;strFileName=Row.FileType.T<wbr />oString()+<wbr />DateTime.N<wbr />ow.ToStrin<wbr />g(&quot;MMddyyy<wbr />y&quot;);<br />
&nbsp; &nbsp; &nbsp; &nbsp;strErrorDescription = &quot;The File &quot;&nbsp;+ strFileName + &quot;Contains Following Error&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; sbExceptionMail.Append(&quot;&lt;t<wbr />r&gt;&lt;td style='border: 1px solid black'&gt;&quot; + Row.FileType.ToString() + &quot;&lt;/td&gt;&lt;td style='border: 1px solid black'&gt;&quot; + DateTime.Now.ToString() + &quot;&lt;/td&gt;&lt;td style='border: 1px solid black'&gt;&quot;+strErrorDescripti<wbr />on+&quot;\n&quot;+ Row.ErrorDescription.ToStr<wbr />ing() + &quot;&lt;/td&gt;&lt;/tr&gt;&quot;);<br />
&nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; }<br />
<br />
}<br />
</i><br />
<br />
<br />
Will try out your suggestions and keep you posted on the updates.<br />
<br />
Thanks once again for your response.
</div>


<div>
btw, is your development machine 64-bit or 32-bit?<br />
<br />
Mike
</div>


<div>
It's a 64-bit.<br />
<br />
Thanks,<br />
Svapv
</div>


<div>
This may seem weird, but destroy the script task, complete the package without it, save it and close. Re-open and add the script task again - with a different name, and add the code again. Make the error message slightly different. Compile, save, and run the package. Then deploy and see if you still have the same problem. If so, consider seriously staying with 32bit for now.<br />
<br />
hth<br />
<br />
Mike
</div>


<div>
worked after changing the machine
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We have created an SSIS package which reads csv files from shared path and processes it to dump data into SQL Server 2012. The package was initially developed in 2008 and upgraded to 2012 using SQL Server Data Tools, as our requirement required the packages to run from SQL Server 2012. <br />
<br />
We scheduled the package as a sql server agent job and try to execute the job using proxy account. The proxy account has access to shared folder from where the csv files are read and has been given permission in the DB as well. &nbsp;we encountered the below error - <br />
<br />
Microsoft (R) SQL Server Execute Package Utility &nbsp;Version 11.0.2100.60 for 64-bit &nbsp;Copyright (C) Microsoft Corporation. All rights reserved. &nbsp; &nbsp;Started: &nbsp;1:56:18 AM &nbsp;Error: 2014-11-13 01:56:20.52 &nbsp; &nbsp; Code: 0xC0202020 &nbsp; &nbsp; Source: Data Flow Task Flat File Source [27] &nbsp; &nbsp; Description: The buffer type is not valid. Make sure the Pipeline layout and all components pass validation. &nbsp;End Error &nbsp;Error: 2014-11-13 01:56:20.52 &nbsp; &nbsp; Code: 0xC004701A &nbsp; &nbsp; Source: Data Flow Task SSIS.Pipeline &nbsp; &nbsp; Description: Flat File Source failed the pre-execute phase and returned error code 0xC0202020. &nbsp;End Error &nbsp;DTExec: The package execution returned DTSER_FAILURE (1). &nbsp;Started: &nbsp;1:56:18 AM &nbsp;Finished: 1:56:20 AM &nbsp;Elapsed: &nbsp;2.23 seconds. &nbsp;The package execution failed. &nbsp;The step failed.,00:00:02,0,0,,,,0<br />
<br />
<br />
<br />
When we tried to run the another package that was developed using SSDT &nbsp;also, it failed to execute. &nbsp;On setting the <br />
package to run in 32 bit mode in the execution options tab of the job step, it works. We need to execute this in 64 bit mode only. <br />
<br />
If anybody has encountered this issue, kindly let us know how to resolve this. Any help is highly appreciated.<br />
<br />
Thanks,<br />
svapv
</div>
</div>


Hi,

We have created an SSIS package which reads csv files from shared path and processes it to dump data into SQL Server 2012. The package was initially developed in 2008 and upgraded to 2012 using SQL Server Data Tools, as our requirement required the packages to run from SQL Server 2012. 

We scheduled the package as a sql server agent job and try to execute the job using proxy account. The proxy account has access to shared folder from where the csv files are read and has been given permission in the DB as well.  we encountered the below error - 

Microsoft (R) SQL Server Execute Package Utility  Version 11.0.2100.60 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  1:56:18 AM  Error: 2014-11-13 01:56:20.52     Code: 0xC0202020     Source: Data Flow Task Flat File Source [27]     Description: The buffer type is not valid. Make sure the Pipeline layout and all components pass validation.  End Error  Error: 2014-11-13 01:56:20.52     Code: 0xC004701A     Source: Data Flow Task SSIS.Pipeline     Description: Flat File Source failed the pre-execute phase and returned error code 0xC0202020.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:56:18 AM  Finished: 1:56:20 AM  Elapsed:  2.23 seconds.  The package execution failed.  The step failed.,00:00:02,0,0,,,,0



When we tried to run the another package that was developed using SSDT  also, it failed to execute.  On setting the 
package to run in 32 bit mode in the execution options tab of the job step, it works. We need to execute this in 64 bit mode only. 

If anybody has encountered this issue, kindly let us know how to resolve this. Any help is highly appreciated.

Thanks,
svapv

SSIS 2012 package not working from SQL Server Agent job

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.