HI, I have used a SQL PDW Destination Adapter component in my SSIS package to copy data from SQL OLE DB table to PDW Table. As a sample test my source contains just 2 rows of data. My package is stuck at "Execute Phase is beginning" . I am able to insert records in the target table through NEXUS into the PDW table. Any idea why i am facing this issue? Please help if i am missing some configuration/setting here. Thanks.

Hello, Can you please elaborate more on the issue. Mean while go through the thread below. It may help you. http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/dff5d3a0-55fa-45e0-ae4e-fd85973f1754

HI, I simply have a DataFlow task. The Source is a OLEDB connection (SQL Table) and Destination is the SQL PDW Destination component (table on PDW). All i/p and o/p rows are mapped correctly. When i run the dataflow task, it comes till the Execute Phase is beginning message and stays there. It doesn't give an error neither does it end. :( Aastha

I tried the same package on a different machine. Here are the steps: Installed the msi "SSISSQLPDWDest-amd64". Chose the SQL Server PDW Destination from the Toolbox. Created a new connection. Upon clicking Test Connection, got this error : The assembly folder under "c:\Windows" conatins the entry for the new component as "SqlServer.PDW" The "machine.xml" config file in "C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG" contains the following entries: <DbProviderFactories> <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/><add name="Microsoft SQL Server 2008 R2 Parallel Data Warehouse" invariant="Microsoft.SqlServer.DataWarehouse" description=".Net Framework Data Provider for SqlServerPDW" type="Microsoft.SqlServer.DataWarehouse.PDWFactory, SqlServer.PDW, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c84cd5c63851e072, processorArchitecture=MSIL"/></DbProviderFactories> So i am unable to figure out why I am getting the above error. Please help! :(Aastha