Viewing 15 posts - 16 through 30 (of 31 total)
... except I'm using Sql Server 2005, and I don't believe it has the Use 32-bit Runtime option when setting up a Sql Server agent job step. I think...
February 13, 2013 at 11:58 am
Looks like I solved my own problem.
The issue really has to do with using a 32 bit DLL (the ODBC driver in this case) and executing a 64...
February 13, 2013 at 10:45 am
You did not state which version of the Access 2010 provider you have installed on the server.
Good point. 32 bit version
December 5, 2012 at 8:32 am
Good point. 32 bit.
December 5, 2012 at 8:23 am
I tried this method this morning, but I must be missing something.
We have SQL Server 2005 running on a 64 bit server. I loaded Microsoft Access Database engine 2010...
December 5, 2012 at 8:00 am
What timing! I just went through the agony of getting the Excel connection to work on a 64 bit machine when running a SSIS package via SQL Server agent....
December 4, 2012 at 6:46 am
There are a couple of ways you can do this:
1. You can have SSIS run under a transaction. Go to the package properties and set the transactionoption property under...
November 19, 2012 at 7:12 am
Truly bizarre. I don't believe the problems I was having have anything to do with lack of memory (except maybe my own).
The OLEDB source I had was using a...
September 28, 2012 at 1:24 pm
These are the errors I'm getting. I also did full logging but basically got the same messages at the point of error.
[blah blah blah [1]] Error: The attempt to...
September 28, 2012 at 7:31 am
Haven't had time to rerun my scenario to see if there are other error messages. I think there are but they were pretty generic "pipeline" messages. I'll try...
September 28, 2012 at 6:53 am
Now this is interesting.
I moved the write of the recordset to the variable in the data flow.
Before:
OLEDB Source
Derived column transform
Data conversion transform
Multicast transform going into:
flow 1 - OLEDB Destination
flow...
September 26, 2012 at 1:37 pm
I'm taking the recordset, saving it to a variable, and using it in a subsequent loop.
I'm sure I can cajigger the subsequent step to read from a temp table or...
September 26, 2012 at 7:50 am
Evil Kraig F, GSquared, both good points.
I let the task run all night, came in this morning, and it still did not complete. However, I did notice...
September 26, 2012 at 6:46 am
Just for chuckles, I changed my initial selection criteria so that only 100 rows get selected, instead of 1,000 or so rows, ending up in the ADO recordset destination...
September 25, 2012 at 3:13 pm
No, it is preceded by a multicast transformation. One leg of the data flow goes into an OLE DB destination and receives 1,210 rows. The other...
September 25, 2012 at 1:10 pm
Viewing 15 posts - 16 through 30 (of 31 total)