Please find attached script files to create tables and data.

dbo.Cust_Encounters.Table.sql is the data to start with. dbo.Cust_Encounters_Sets.Table.sql shows what it will look like after creating sets.

Thank you for you help.

Sharing the folder solved the problem.

I am using a UNC path, not a mapped drive.

When I run the package in debug mode using Visual studio, it works fine, no errors.

When I run it in a scheduled job in SQL Agent using a service account...

I am loosing hope, please respond. I am sure many people are using this in their ETL.

Thanks.

I did the following:

Opened Component Services,Expand Component Service->My Computer->DCOM Config, Locate “Microsoft SQL Server Integration Services 11.0” Rt click and select “Properties” Select the “Security” tab, In Launch and Activate...

Yes, my folder and files have every one full control.

I checked the event viewer. It is showing the following error: The application-specific permission settings do not grant Local Activation permission...

yes, my file and folder has everyone full control.

I checked the event viewer. It is showing the following error:

The application-specific permission settings do not grant Local Activation permission for...

The file and folder has everyone full control set.

The account is MyDomain\MyProxy

It this problem because the proxy account does not have access to system.IO (dll) ?

The file and folder is set to have everyone full control.

The only difference I see is that script you directed me to uses @subsystem=N'DTS'

while my job script uses @subsystem=N'SSIS'

I changed it to use DTS, but it didn't work....

The proxy account is associated with SSIS Package Execution

In the SSMS, I expand SQL Server...

Phil Parkin (11/14/2013)

---

Are there any other errors? The one you posted doesn't really help that much, unfortunately.

Are you saying that all packages containing scripts fail when run under SQL Agent,...

Here are the contents of MsDtsSrvr.ini

I found it under E:\Program Files\Microsoft SQL Server\110\DTS\Binn

<?xml version="1.0" encoding="utf-8"?>

<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>

<TopLevelFolders>

<Folder xsi:type="SqlServerFolder">

...

How do I check it?

One more thing I just found out is that, If I remote into the machine where Sql...