Hi Phil

Please check max server memory settings in Server Configuration Options first,

it looks that the SQL Server consumes all available RAM, leaving no room for SSIS.

Buffer Sizing - it needs...

Hi again

It looks you pass parameter to ADO NET Source in incorrect way?

Please take a look for an example:http://jamessummerlin.com/2015/05/04/ssis-using-expressions-to-build-sql-statements-for-ado-net-connections/, but I prefer the Transfer SQL Server Objects Task for such...

Hi

Could you please tell me what the error is returned in the first issue?

Regarding the second issue, you can play with SET IDENTITY_INSERT [ database_name . [schema_name ] . ]...

Hi Chris

Did you try to change the chunk size in FTP Connection property?

Br.

Mike

Hi

Well, actually, you could do it the other way, please try my example:

FINDSTRING([Column 3],"-",1) == 0 ? NULL(DT_DATE) : ((DT_DATE)([Column 3]))

Br.

Mike

Hi

Imho join both servers to the domain is the best solution in this case.

Of course you can leave it as is, but it requires significant administrative effort involved in keeping...

Question likeTGIF, thanks.

Hi

If you store results in XML document, you can use it as a source in the Data Flow Task.

So, it is not necessary to declare the variable in any...

Hi

Let's clarify something. Do you need Windows authentication to authenticate users in a Web application or/and on SQL server?

Best Regards

Mike

Hi

Have you got different SQL editions on Dev and Prod environments?

Br.

Mike

Hi

Job usually runs under SQL Server Agent Service account, it does not have access to network folder, of course you can set up a proxy with domain credentials to reach...

Nice one, but this star is a bit tricky 😎

Thanks

Thanks Sasidhar

You can load it one by one with Foreach Loop Container.

Regarding total time of execution, Imho it is a bit slow, how do you manage

this process? (I mean -...

Hi Sasidhar

I wonder how many rows are in those 5 files?

Best regards

Mike

Regarding scheduling: Please deploy your package in File System or save to the MSDB database on an instance of SQL Server.

Create the new job in Sql Agent service, you can...