Data flow task executing successfully but not writing any rows to Excel file

sql ssis business-intelligence
gunvant.k picture gunvant.k · Jun 18, 2012 · Viewed 18.4k times · Source

I am working on SSIS package that is fetching data from SQL server and inserting into Excel file... in Data Flow Task i've used OLE Db source and Excel destination.

After configuring OLE Db source i can preview the resulting row and even data flow task executing successfully without giving any error.. but not inserting any row..

Answer

gunvant.k picture gunvant.k · Jun 19, 2012

Well fortunately i found the answer,I did two things..

  1. I just deleted the old Data Flow Task on which i have tried so many different settings and parameters... and Build the Data Flow Task all over again...

  2. In SQL query i'd wrote the Fully qualified name instead of 'Use Database' Statement.

Hope this will help someone..

Related questions

How do I strip the date off of a datetime string in SQL SSIS?

I'm working on a data warehouse project and would like to know how to (preferably in a Derived Column component in a Data flow) strip the date piece off of a SQL datetime record. Once I have the datetime converted …

Read More
How can I get SSIS Lookup transformation to ignore alphabetical case?

Hopefully this is easy to explain, but I have a lookup transformation in one of my SSIS packages. I am using it to lookup the id for an emplouyee record in a dimension table. However my problem is that some …

Read More
Pivot transformation using t-sql

In SSIS there is a task called Pivot transformation that changes columns into rows, but how to do the same task in sql server using t-sql ? this is my sample table location product qty ----------------------- delhi PEPSI 100 GURGAON CAKE 200 NOIDA …

Read More