Greetings. I am new to SSIS, so please excuse me if this is a simple question. I have been setting up an SSIS package that queries a database from a Progress OpenEdge database and does some transformations of the data and then inserts the data into a MS SQL Server database. I am setting this up in Visual Studio on my local machine. Every time I open the SQL Server Destination it gives me the following warning "The selected data source is on a remote computer. The bulk insert operation can be executed only on the computer where this data source is located.".
Once I deploy the SSIS package it will reside on the same SQL Server as the destination is setup to use. Do I need to do something else in order for this to work correctly once deployed, or will it be fine?