Hi

Imho it might help you resolve it

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2013/08/20/system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client-while-deploying-ssis-project.aspx

Best regards

Mike

Hi

I prefer ReadLine method until is null returned instead of Peek, please try:

String FileLine

while ((FileLine = sr.ReadLine()) != null)

{

...

}

Br.

Mike

Hi

Use SET NOCOUNT ON before variable table declaration.

Br.

Mike

Nice warm-up question at the beginning of Week. Thanks.

Hi

Did you set "OnError" and in Advanced "MessageText"?

You should see something like that:

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

PackageStart,WSSERV01,CRP\db-operator,serial_items,{161366A8-72F3-42DE-B1C5-A58246F0B2DE},{573C819F-BD07-4393-9C1F-575DB96E7C8D},2015-08-21 16:35:29,2015-08-21 16:35:29,0,0x,Beginning of package execution.

OnError,WSSERV01,CRP\db-operator,Data Flow Task 1,{4D705608-04F3-48E2-B283-C3E4507665B5},{573C819F-BD07-4393-9C1F-575DB96E7C8D},2015-08-21 16:35:29,2015-08-21 16:35:29,-1071636319,0x,Data conversion failed. The data conversion for...

Don't worry, no one of us was born with the knowledge.

Please open your dtsx file in VS, click "SISS" from main menu and then "Logging".

Choose the provider type (eg. text...

Hi

Very tricky question ;-), my first thought: OMG all of them are Excel add-ins.

Hi

Have you got any logging implemented on this package?

Br.

Mike

Hi

It looks you have permissions to write, but read & execute are denied.

Br.

Mike

Hi

As s_osborne2 mentioned above, TRUNCATE TABLE removes all rows from a table, if the table contains an identity column, the counter for that column is reset to the seed...

Hi

My package uploads documents (pdf) into repository, sometimes files are empty, so I check the size of

file thru the Script Task to exclude them from import . Please refer FileInfo...

Hi

Good question, but a bit easy to make mistake.

Br.

Mike

Hi

Is it tablix or matrix report?

Thanks

Mike

Hi

Imho, you can do it via ODBC, please take a look here https://www.tallysolutions.com/website/CHM/TallyERP9/tallyerp9_help.htm#Data_Management/Tally_ODBC.htm

Best regards

Mike

Hi Chris

Your second post helped to clarify the problem, let me know you rebuilt again the Script Component after upgrade?

Regards

Mike