tag:blogger.com,1999:blog-4762425244190648087.post2917078375360973702..comments2010-01-10T09:27:06.026+05:30Comments on SQL Yoga: SQL SERVER SSIS: Basic Example Of Data Flow TaskTejas Shahhttp://www.blogger.com/profile/04041260304854571049noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4762425244190648087.post-69310585978216634102010-01-10T06:17:23.807+05:302010-01-10T06:17:23.807+05:30Hi,
Can you please tell how to import a CSV file ...Hi,<br /><br />Can you please tell how to import a CSV file which has column names in first row but one of the columns does not have any name?<br />SSIS puts values from two columns with in one and gives a warning that flat file parser can not parse embedded quotes and the rows will fail at run.<br />I have bunch of files like this and package needs to run daily.<br />Is there a solution to this Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4762425244190648087.post-81020542948675218642009-12-22T17:22:13.735+05:302009-12-22T17:22:13.735+05:30I have a query in SSIS can you help me.
i have a T...I have a query in SSIS can you help me.<br />i have a T-SQL query <br />With<br /><br />DefectUnit AS(SELECT SerialNo,MAX(GUTCDateTime)as LastGUTCTime from GPSTrack group by SerialNO having convert(datetime,CURRENT_TIMESTAMP,101) <br />-<br /><br />MAX(convert(datetime,GUTCDateTime,101))>1)select SerialNo,LastGUTCTime from DefectUnit order by SerialNo ASC <br /><br /> <br /> i need to send a Rakehttp://www.blogger.com/profile/11242205589872635043noreply@blogger.com