REDSHIFT OLEDB BI Alias provider

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

REDSHIFT OLEDB BI Alias provider

Postby famc » Mon Mar 17, 2014 7:53 am

According to documentation, when using SSIS to import data BI Alias provider should be chosen. However, when I do that, there's no ability to configure connection to Redshift. The connection window looks like the one for SQL Server. Redshift Oledb provider (not BI Alias) doesn't have this problem.
famc
 
Posts: 1
Joined: Wed Mar 05, 2014 8:55 am

Re: REDSHIFT OLEDB BI Alias provider

Postby Moderator » Wed Mar 19, 2014 9:34 pm

Hi,
Are you using "SQL Server Import and Export Wizard"? Could you e-mail more details to Support?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm

Re: REDSHIFT OLEDB BI Alias provider

Postby createg » Tue Oct 21, 2014 2:16 pm

Same issue here.

BIDS- SSIS

Connection manager- reg shift BI alias does not give the data links option or any details to configure the red shift connection.

The only available option is server name and sql server auth.

Attached picture
Attachments
Bi Alias.jpg
Bi Alias.jpg (81.86 KiB) Viewed 49 times
createg
 
Posts: 5
Joined: Thu Sep 11, 2014 11:32 pm

Re: REDSHIFT OLEDB BI Alias provider

Postby Moderator » Wed Oct 22, 2014 9:20 am

Main connection parameters can be specified in the "Connection" pane as shown. Additional parameters can be specified in the "All" pane.
Attachments
rsnpcxn.jpg
All pane
rsnpcxn.jpg (88.31 KiB) Viewed 42 times
rsnpcxn1.jpg
Connection pane
rsnpcxn1.jpg (74.69 KiB) Viewed 42 times
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: Google [Bot] and 3 guests

cron