Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ShaggyDogg
Starting Member
3 Posts |
 Posted - 2011-11-29 : 10:04:59
|
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! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-29 : 11:23:50
|
| is there some warnings generated on background, may be by ODBC connection?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
andris_sh
Starting Member
3 Posts |
Posted - 2011-12-01 : 10:19:16
|
| Does SQL Server Activity Monitor displays anything? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-01 : 10:21:38
|
| I still think its something to do with ADO .NET connection establishment------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ShaggyDogg
Starting Member
3 Posts |
Posted - 2011-12-09 : 09:42:04
|
| I think you're right. I've got a case open with the vendor at the moment and will post an update here when I get this resolved. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 10:13:13
|
| ok great...please post once you get a solution------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
SSIS Data Flow task not completing,but not failing