Hi

You can use LastIndexOf() method to find the position of last "_" character in string,

try in such way:

//char to find

String UndSc = "_";

// (3 + 2) month & year...

Nice but Imho answer should be "The TOP 3 highest orders for all customers who have made a purchase."

Regards

Mike

Hi

Service account on B needs Read & List Folder or Read & Execute permission to do that.

Regarding the file exists validation, you can check it by Script Task before looping.

Br.

Mike

Hi

Imho you can add a Script Task between and check your object variable,

public void Main()

{

OleDbDataAdapter oda = new...

Prety easy question, a part of set theory (t1 n t2 n t3).

Thanks

Hi again

I'm afraid you are unable to create a link with Server Native Client "SQLNCLI11", try another one,

eg. ODBC Data Source and specify MSDASQL as provider name.

Br.

Mike

Here is simple tutorial how to:

https://msdn.microsoft.com/en-us/library/ff772782.aspx

and another one:

http://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm

Imho it should help you.

Have a nice day

Mike

Hi

Please set up a linked server first to access data from FS1 instance on DSQL. Or already created with different name, so check

SELECT * FROM sys.servers;

Br.

Mike

Hi

Please check if there a SQL Server Browser Service is running.

Br.

Mike

Hi

I've got some projects where files are uploaded on sftp(ftp) servers, In most cases I prefer

send file by Execute Process Task and wget software.

Additionally I set logging to trace...

Hi

If a destination table already exists, you can do it via Bulk Insert Task.

Br.

Mike

Hi

Set Long data type when you creating table in Excel Destination Editor.

Br.

Mike

What's wrong with the world today? If you say "I'm a Data Scientist", you will probably be kidnapped from the street.

Hi again

I only wanted to be sure that problem is not related to the limitations set on the network devices (rate-limit, traffic shaping, etc.).

We also can exclude the firewall issue...

Hi

Let me clarify something, both source and destnation servers are on the same or different network?

Br.

Mike