August 23, 2009 at 4:13 pm
There was a nice blog post over on http://blogs.msdn.com/sqlperf/archive/2009/08/14/using-ssis-to-get-data-out-of-oracle-a-big-surprise.aspx that was mentioned in the Database Weekly email for this week?
I posted there as well, but I figured I would post here as well as I'm not sure how much visibility that post will get.
One drawback I saw with this is that you can not use an expression for the SQL command on the object.
I have a package that I dynamically build a SQL statement to only pull in rows with certain criteria. I suppose I could pull in the entire table and use some of the filtering data flow objects to only take the records i need, but that would somewhat defeat the purpose of limiting the selected rows.
Anyone have the same experience with this tool?
Hopefully it can be built into a newer version, because I would love to use it.
Steve
August 23, 2009 at 5:56 pm
SK (8/23/2009)
Hopefully it can be built into a newer version, because I would love to use it.
That's a good idea, I would write a nice letter to Attunity - I don't think they are monitoring this forum to put together a wish list 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 24, 2009 at 9:17 am
Good idea, I submitted feedback over at this URL:
http://www.attunity.com/request_information
Cheers,
Steve
September 3, 2010 at 12:28 am
Are you performing DB to DB transfer? Would the gain be cancelled out by bring over additional data and having to filter it out?
I'm in the same situation where trying to use sql command variable but Attunity is coming up short.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply