Hi, Thanks for sharing my post, I have also explained another possible approach. Please go through it and let me know your comments.

[/url]

Thanks

Please go through the below link, you could get something.

http://msdn.microsoft.com/en-us/library/bb408520(v=exchg.140).aspx

Regards

Sunil Reddy Enugala

Please go through my blog posts on executing java class file from SSIS.

[/url]

[/url]

Let me know your queries further.

To call SSRS reports from SSIS package, refer one of my blog post.

[/url]

Let me know if you face any issues while developing.

To call SSRS reports from SSIS package, refer one of my blog post.

[/url]

Let me know if you face any issues while developing.

Thanks

Sunil Reddy

You can setup a job to execute the package and start the job by using System procedure.

or

you can create a bactch file and trigger the batch file in your...

I am not clear about what you are asking but for rendering reports from SSIS package refer one of my blog post.

Let me know your issues while developing the code

...

yeah, if you disable the property for that child package, it stops tracking in Master log file and you'll get log details of child package as enabled it in child...

In the Master package, set 'Disable EventHandlers' property to 'True'. so it stops tracking the logs in Master Package.Now you'll get only the logs of child packages as you set...

you can set 'ntext' data type for flat file connection manager in the 'Advance' tab.

'XP_cmdshell' is unable to find the path of your package, can you let me know the type of deployment you have used.

In the Solution Explorer, click on <package solution> -> select Properties

set Deployment utility's properties:

1. AllowConfigurationChanges=True

2. CreateDeploymentUtility=True

3.DeploymentOutputPath= <bin/deployment> //replace your...

try to change the datatype from varchar(max) to nvarchar(max) and change the source datatype to ntext

I got the same problem...

The better way is to reinstall again and change the collation during the installation itself....