SQL View not Exporting to Excel via DTS Package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » SQL View not Exporting to Excel via DTS...

SQL View not Exporting to Excel via DTS Package

Rate Topic

Display Mode

Topic Options

Author

Message

nbradley 36689

Posted Tuesday, February 26, 2013 10:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:57 PM
Points: 3, Visits: 11

Hi I hope I am posting this to the correct forum.

I fairly new to SQL Server and SSDT so here goes.

I have a package that does the following steps:

1. File system task that delete a backup file.
2. File system task Renames the current file to backup file name.
3. File system task that copies a existing file that only has headers in it for the extract of the data for a view.
4. Dataflow task that inserts the data from the SQL to the Excel file in step 3. [color=#925d400]This is where the process breaks, the data is not inserted into the Excel file.[/color]
There are 4 more steps that do the same thing as steps 1-4 above the only difference is it is on different files in the same location as steps 1-4 and those 4 steps complete without any issues.

I am wondering if anyone has come across this problem before and how they resolved the issue.

BTW when I run the package from my local SSDT the process runs and works without any issues. The failure only happens when the package is deployed on the SQL Server.

If this isn't the right forum for this question. Please let me know the correct forum and I will be happy to post it there.

Thanks

NB

Post #1424182

opc.three

Posted Friday, March 01, 2013 12:02 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 6,730, Visits: 11,778

Define "breaks." Do you receive an error or does the package execution succeed but no data is present in the Excel file?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425371

nbradley 36689

Posted Friday, March 01, 2013 6:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:57 PM
Points: 3, Visits: 11

Hi, thanks for asking the package succeeds with no error messages, but the data is not written to the excel file.

Post #1425465

opc.three

Posted Friday, March 01, 2013 8:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 6,730, Visits: 11,778

What does your logging say when run through SQL Server as compared to when it runs successfully through SSDT?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1425534

nbradley 36689

Posted Saturday, March 02, 2013 6:34 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:57 PM
Points: 3, Visits: 11

Thanks for the responses, we found this was a permissions issue. The issue has been resolved.

Post #1425912

« Prev Topic | Next Topic »

Permissions