Hi

What ProtectionLevel is set for this Package?

Regards

Mike

Hi Chris

Please update manually Rows per batch and Maximum insert commit size properties in OLE DB Destination after package conversion.

Best regards

Mike

Hi

The THROW is a new feature in SQL Server 2012 and thus it's not available in 2008 R2 yet.

Regards

Mike

HI

You have to save the password in configuration file.

Regards

Mike

Hi

Pretty cool QotD, I had to think twice before mark correct answers. 😎

Regards

Mike

Hi

PLease try to set DelayValidation=true on both child (data connections) and parent (execute package task) packages. Is there any configuration values for the child package?

Regrads

Mike

Hi Vipin

Imho it's enough to add Row Count between Conditional Split and OLE DB Command,

or you set has another condition in Update statement (OLE DB Command)w which limits

number of...

Hi

Imho you can create a new SP which calls udp_TableUpdateALL first and

select statement after that.

Regards

Mike

Hi

You have to check a few of issues:

Network:

- try to ping SQL server

- check nslookup (DNS name resolving)

Firewall:

- anywhere between client and server could block SQL connection request

Odbc...

Hi

You should see warning on Flat File Destination after change in Connection Managers, simply edit the Flat File Destination and

click on Mappings Page and then OK, it will refresh the...

Hi Uncle

You have to change in Flat File connection first, then in Flat File destination.

Regards

Mike

Hi

Please take a look for that example http://sqlmag.com/sql-server-integration-services/ssis-package-pings-servers, it doesn't require Task Script control to check servers.

Thanks

Mike

Hi

It looks like the problem exists in incorrect width, please check InputColumnWidth property of FF, it should be

equal or greater then the source column length.

Regards

Mike

Hi

I checked a few of my projects and I usually combined different sources into single data set (stored procedure, query level), please just try out in this way.

Br.

Mike

Hi

Imho you can create SSIS package and set it as a job in SQL Agent.

Br.

Mike