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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2009-12-04 : 12:25:19
|
| I am trying to pull data from a Filemaker database using the ADO.NET ODBC driver in SSIS. I want to populate an SQL server table with the FM data. My plan is to create the SQL Server table on the fly during the process, but I keep running into SelectCommand Property errors.The question: does the SQL Server table have to exist prior to the DataSource Reader control handling the Data Flow Task? I am eventually going to add an Execute SQL Task prior to the Data Flow Task that will check to see if the SQL Server table exists; if so, the table will be dropped and recreated, if not then table will be created. Regards |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2009-12-04 : 16:52:03
|
| I have made good progress. I have 2 Execute SQL tasks setup in my Control Flow. The first SQL tasks handles my SQL table creation. The 2nd SQL task executes a SELECT statement. The problem occurs when I select a Full Result Set for the ResultSet Property. I get this error: "The SelectCommand property has not been initialized before calling 'Fill'. Possible failure reasons: Problems with query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."The query succeeds with ResultSet property set to None; I have no parameters; My query passes the Parse Query test. I am choosing to return a Full Result Set to a variable named '0' with Object type.What does that error mean?Regards |
 |
|
|
|
|
|
SQL Server table definition needed?