Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.
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.
- Posts: 1
- Joined: Wed Mar 05, 2014 8:55 am
Are you using "SQL Server Import and Export Wizard"? Could you e-mail more details to Support?
- Site Admin
- Posts: 305
- Joined: Wed Oct 29, 2008 11:27 pm
Same issue here.
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.
- Bi Alias.jpg (81.86 KiB) Viewed 52 times
- Posts: 5
- Joined: Thu Sep 11, 2014 11:32 pm
Return to SQL Server/DTS/SSIS/Linked servers/Replication
Who is online
Users browsing this forum: No registered users and 1 guest