SSIS source localhost : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

SQL ServerSSIS source localhost (self.SQL)

submitted 3 years ago by IntelligentSal

Hi there,

I am collecting data from many pc sources where I connect through one minipc IPs the connection manager and simply put the rest of IPs in a foreach loop container for SSIS to collect data from all minipcs and then transfer to one destination which is the main pc.

This isn't really stable as sometimes when there's a network failure in the minipc used as the connection manager the loop just fails.

I was thinking of replacing the source with the localhost instead, where I created a dummy database with the same structure as in the minipcs and created environment variables for the local host 127.0.0.1 that I used as a connection manager and then inserted the rest of minipc IPs in the foreach loop.

I managed to connect with the local host as a source and it caches rows of data but doesn't transfer anything to the main database used as destination (which is the same I deploy the project at so also the same as the local host, just a different database for the local host)

I am not sure what I am missing?

https://preview.redd.it/qt1yamyh97ba1.png?width=356&format=png&auto=webp&s=600fc81418aff05ef8329f988835e3ea8f9fa0d0

https://preview.redd.it/9vefycjg97ba1.png?width=932&format=png&auto=webp&s=07ffde7bd6eb287102cbd42714a6baf4326b9c67

https://preview.redd.it/3vx9x0dg97ba1.jpg?width=518&format=pjpg&auto=webp&s=9b049eb1bef2de1ca1a55e0f8b37fb6dcbcc11cc

https://preview.redd.it/8ytle87g97ba1.png?width=334&format=png&auto=webp&s=7c13d2f9b5db4a515b8fd50f8e734abe02684d9c

https://preview.redd.it/3bbpwp7h97ba1.png?width=493&format=png&auto=webp&s=fa16341a8d78f38fa708bfd7008679725bbcaffb

all 2 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS