ShaggyDogg
Technical User
Apologies for the ambiguous title, but was unsure how to headline this query. Windows Server 2008 (x86) with SQL Server 2008, posted images of the task operational details are below, but first a summary of the issue.
I have a very straightforward data flow task to SELECT source data from a PI Wadis database table (access through an ODBC driver installed on the server) and INSERT into an existing SQL 2008 db table. The task is very basic, in theory, so for efficiency was created using the Import and Export Data (32-bit) wizard. On completion, the process was initially ran and executed successfully.
But, when I now try to edit the data flow task in VS2008 BI, the process executes only so far but then halts. It does not fall over or fails, just halts. The ADO.NET Data Source editor using the ODBC driver (referenced, as ‘PI 1’ & SQL command will preview the correct data. The OLE DB SQL Data Source editor will preview the correct data. The task itself will not complete.
I’ve tried various ‘tweaks’ but cannot get this to work – really stumped. Any suggestions welcome, and feel free to ask about anything I have not covered that may help.
Thanks!
I have a very straightforward data flow task to SELECT source data from a PI Wadis database table (access through an ODBC driver installed on the server) and INSERT into an existing SQL 2008 db table. The task is very basic, in theory, so for efficiency was created using the Import and Export Data (32-bit) wizard. On completion, the process was initially ran and executed successfully.
But, when I now try to edit the data flow task in VS2008 BI, the process executes only so far but then halts. It does not fall over or fails, just halts. The ADO.NET Data Source editor using the ODBC driver (referenced, as ‘PI 1’ & SQL command will preview the correct data. The OLE DB SQL Data Source editor will preview the correct data. The task itself will not complete.
I’ve tried various ‘tweaks’ but cannot get this to work – really stumped. Any suggestions welcome, and feel free to ask about anything I have not covered that may help.
Thanks!