Create/Update Postgresql table via Microsoft SSIS package

Question

I want to do the following two things:

Create a table "Lite AC" with two columns (id, lite_ac) in a Postgresql database via Microsoft SSIS package
Update that newly created table via another SSIS package

I want to use that table in order to integrate it into a WHERE SUBSTRING IN (Lite AC) statement.

I am using pgAdmin to connect with that Postgresql database. I know how I can export data from Postgreql via an SSIS package so all the drivers should be installed, but no idea how to do that the other way round.

Is that possible?

I don't know, this is no man's land for me. So, shall I just try it as I do it when exporting data from the PSQL DB? Also, what sort of rights are required on the Postgres side to be able to create such a table? — coala
– coala, Commented Jun 3, 2014 at 12:21
Also as the DB in Postgres contains several schemes, how do I specify under which scheme the table is created then? — coala
– coala, Commented Jun 3, 2014 at 12:35

bonCodigo · Accepted Answer · 2014-06-03 14:28:42Z

2

I do not have Postgres installed.

You need two connection managers. One for source and the other for destination. In your case destination is Postgres DB. In order to test out, you may use a Flat File Connection to insert set of sample data from a .txt file. Following tutorial emphasizes on Login credentials to Postgres DB.

Once you are able to connect to Postgres DB via SSIS and rows are inserted into the DB using .txt file - try to add a SQL Scripting Task to be executed after Data Flow Task, so to update the records in the new table.

answered Jun 3, 2014 at 14:28

bonCodigo

14.4k1 gold badge52 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create/Update Postgresql table via Microsoft SSIS package

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related