<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-4762425244190648087.post3184331393279346225..comments</id><updated>2010-08-06T18:33:55.667+05:30</updated><category term='PIVOT'/><category term='Mahesh Dhola'/><category term='Data Flow Task'/><category term='Office 2010 features'/><category term='Derived Column'/><category term='Microsoft'/><category term='SQL'/><category term='For Each Loop Container'/><category term='Query Performance'/><category term='SQL Server'/><category term='Table Variable'/><category term='Compare Database'/><category term='sp_procoption'/><category term='Log'/><category term='Data Transformation'/><category term='SQL PASS'/><category term='Pinal Dave'/><category term='For Each Container Task'/><category term='BULK INSERT TASK'/><category term='Ahmedabad User Group'/><category term='SELECT'/><category term='Event Viewer'/><category term='COALESCE'/><category term='SQL SERVER 2008 R2'/><category term='SQLYoga'/><category term='Presentation'/><category term='OpenQuery'/><category term='Windows7 Features'/><category term='Row Count'/><category term='Tejas Shah'/><category term='CONTEXT_INFO'/><category term='SSIS'/><category term='ORDER BY'/><category term='ActiveX Task'/><category term='ASP .Net'/><category term='Report Viewer'/><category term='Executing queries'/><category term='sp_MSforeachtable'/><category term='SQL SERVER Reporting Service'/><category term='SQL SERVER CENTRAL'/><category term='Transfer SQL Jobs'/><category term='Report Credentials'/><category term='Import Excel file'/><category term='TRUNCATE'/><category term='SQL Server 2005'/><category term='XML'/><category term='EXISTS'/><category term='Auto Execute Stored Procedure'/><category term='Jacob Sebastian'/><category term='Activity Monitor'/><category term='OpenRowSet'/><category term='Comma Separated List'/><category term='Back up'/><category term='SSRS Reports'/><category term='TRANSACTION'/><category term='SQL DateTime'/><category term='Replicate'/><category term='SQL Services'/><category term='Iterate Each Table'/><category term='RDLC'/><category term='SQL Developer'/><category term='SQL Tips'/><category term='SSRS'/><category term='DELETE'/><category term='DotnetChaps'/><category term='DBA'/><category term='CommunityTechDays'/><category term='Harish Vaidyanathan'/><category term='Disaster Recovery'/><category term='T-SQL'/><category term='Cursor'/><category term='Database Mail'/><category term='SSIS Task'/><title type='text'>Comments on SQL Yoga: SQL SERVER SSIS: How to assign Connection from var...</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://sqlyoga.com/feeds/3184331393279346225/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html'/><author><name>Tejas Shah</name><uri>http://www.blogger.com/profile/04041260304854571049</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='26' height='32' src='http://3.bp.blogspot.com/_55yV6koEy_w/Spz2GL70cwI/AAAAAAAAJoA/FDMLzlPcp3A/S220/TejasSmallImage.JPG'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4762425244190648087.post-5109905984418824693</id><published>2010-08-06T18:33:55.667+05:30</published><updated>2010-08-06T18:33:55.667+05:30</updated><title type='text'>Hi Tejas, great article!! But I would like to know...</title><summary type='text'>Hi Tejas, great article!! But I would like to know, how would I obtain 1 file, not all the files in the directory.  For example, a file such as this: &amp;#39;example_yyyymmdd.txt&amp;#39;.&lt;br /&gt;&lt;br /&gt;Thank you in advance.&lt;br /&gt;Evans</summary><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/5109905984418824693'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/5109905984418824693'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html?showComment=1281099835667#c5109905984418824693' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html' ref='tag:blogger.com,1999:blog-4762425244190648087.post-3184331393279346225' source='http://www.blogger.com/feeds/4762425244190648087/posts/default/3184331393279346225' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-2122200149'/></entry><entry><id>tag:blogger.com,1999:blog-4762425244190648087.post-5253882342702436278</id><published>2010-03-08T10:51:54.095+05:30</published><updated>2010-03-08T10:51:54.095+05:30</updated><title type='text'>Hi Tejas

How can I set value of SQLCommand proper...</title><summary type='text'>Hi Tejas&lt;br /&gt;&lt;br /&gt;How can I set value of SQLCommand property of DataReader Source dynamically while the Data Flow Task is inside the ForEach Loop Container?&lt;br /&gt;&lt;br /&gt;Thanks, Ujjal</summary><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/5253882342702436278'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/5253882342702436278'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html?showComment=1268025714095#c5253882342702436278' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html' ref='tag:blogger.com,1999:blog-4762425244190648087.post-3184331393279346225' source='http://www.blogger.com/feeds/4762425244190648087/posts/default/3184331393279346225' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1925143423'/></entry><entry><id>tag:blogger.com,1999:blog-4762425244190648087.post-1154119838351748233</id><published>2009-12-16T13:28:37.448+05:30</published><updated>2009-12-16T13:28:37.448+05:30</updated><title type='text'>Hi,

We just need to give filer *.*.
By this way, ...</title><summary type='text'>Hi,&lt;br /&gt;&lt;br /&gt;We just need to give filer *.*.&lt;br /&gt;By this way, it will select each file from folder.&lt;br /&gt;&lt;br /&gt;For this we need to make sure that, all files should have same format.&lt;br /&gt;&lt;br /&gt;Thanks,&lt;br /&gt;Tejas Shah</summary><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/1154119838351748233'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/1154119838351748233'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html?showComment=1260950317448#c1154119838351748233' title=''/><author><name>Tejas Shah</name><uri>http://www.blogger.com/profile/04041260304854571049</uri><email>noreply@blogger.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='17116247368334096599'/><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='26' height='32' src='http://3.bp.blogspot.com/_55yV6koEy_w/Spz2GL70cwI/AAAAAAAAJoA/FDMLzlPcp3A/S220/TejasSmallImage.JPG'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html' ref='tag:blogger.com,1999:blog-4762425244190648087.post-3184331393279346225' source='http://www.blogger.com/feeds/4762425244190648087/posts/default/3184331393279346225' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1639380587'/></entry><entry><id>tag:blogger.com,1999:blog-4762425244190648087.post-7208130809190655764</id><published>2009-12-15T11:32:00.577+05:30</published><updated>2009-12-15T11:32:00.577+05:30</updated><title type='text'>How to get the every file name when looping throug...</title><summary type='text'>How to get the every file name when looping through the For each File enumerator container ?</summary><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/7208130809190655764'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/3184331393279346225/comments/default/7208130809190655764'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html?showComment=1260856920577#c7208130809190655764' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://sqlyoga.com/2009/11/sql-server-ssis-how-to-assign.html' ref='tag:blogger.com,1999:blog-4762425244190648087.post-3184331393279346225' source='http://www.blogger.com/feeds/4762425244190648087/posts/default/3184331393279346225' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-766206359'/></entry></feed>
